@@ShanesCows Shane, sorry for bothering you - you must go crazy from all the comments. However I wonder if you could help. I connected D365 Finance to my canvas powerapp. I want to create purchase requisitions using powerapps. The problem is I need to submit the requisition with a number sequence ID that D365 expects. Can I solve this? Or am I using power apps incorrectly when I try to do this? Thank you! Lukas
Shane thanks for all of your videos they have been a tremendous help. I've been watching all of them for a couple months now preparing for my place of employment to start utilizing Power Apps. I've been informed we are now going to be utilizing model driven apps. I love the way you teach and was hoping you could point me in the right direction for resources to continue to learn.
Thanks for this video Shane, you have taught me so much about PowerApps over the last few months! Always well delivered with enough information to get you going but with lots of other little tips along the way.
Thank you. Very helpful. Do you have any video on error handling? Like: iferror, isblankorerror, how to handle system errors, like you getting lets say calendar event, and if it does not exists you get system error. How to do something like try catch.
So helpful, Shane, as always and you do an awesome job of breaking it down. Love the use of labels as secret decoder rings! Is it possible to add more than 1 Bcc email address? Thanks!!
Hi Shane, great video, one question I have is how do you reset the values in each field for when a user wants to submit another email so that they aren't greeted with the text they previously sent. Edit: just figured it out for anyone wondering you can include: & Reset(TextInput1)
Hey Shane, came here from an earlier episode. I have a slightly involved question, I want to send out a duplicate email to multiple people. But these people are going to be different every time. For example I want to send an email to everyone in a SharePoint list that has a column value of 1 or of 2. Should I use a ForAll or should I use a Flow? Thank you!! You've been a big help.
Hi Shane! Thanks for all your videos, it´s really helpful. I hope you can help me with a duplicate email problem. I made a Offline APP and when it sync to my Sharepoint it was supose to send an email, but I don´t no why, sometimes it send a lots of blank emails. Thanks again.
I assume you are using a table to loop through that you are sending emails from? Maybe filter the table for blank records and only send for records that are not blank?
Thank you!! very nice; and then, if you send email from form how can you Put in BCC the same email address from the people who do the form? exist any way?
Hi Shane! Thank you for this super video! Is it possible to add a notification when mail sent on Power Apps? Like a message "Mail sent" show up when we clicked "Send email". Otherwise my users may click 10times...to be sure.
@@ShanesCows thank you for your reply Shane. And by the way thank you for sharing very educative videos. It was a great help to me. I did not ask correctly my question. Let me give an example: I want to use Launch("MailTo: to get the email in draft because the sender may decide to add /modify the given template, and I want to include a deeplink to Powerapps inside the body. My deeplink works well in a browser, but it is not displayed as a hyperlink in the email.
Hey Shane, thank you for sharing your knowledge, you'll be blessed for that. I just have one question, what if one wanted to send an email to someone outside the organization. How do we get that email address in the "To:" Dropdown?
That is up to you. Power Apps doesn't care what the email address is as long as it is text. So you could have a text input control name inpEmail and then set your TO in the formula to be inpEmail.Text and Power Apps would be happy.
Hello Shane, thanks for sharing, quick question, how do you send the email to a different person every time coming from a gallery, I want to improve the Meeting notes App from the PowerApps template to be able to attach docs also, and send those attachments to the attendees.
@@ShanesCows thanks, well I have a gallery where the emails are located and you can add / eliminate emails, so I don't know how to get that text in order to use the Office365Outlook.Sendemailv2
Shane you a legend! . but i got a problemo - My users are not visible in the combobox?. I jsut see like blank rows...no names appear.. do i need to right the concat formula too?
Hi Shane, great video but wondering could you help me with something? I have a form connected to a SharePoint list. One of the fields is a people picker - I call this Assigned To. When I submit this form I would like to send an email to the person selected in the Assigned To field. Could you tell me how to do this? Thanks Debbie
Hi Shane, thanks for the quick response. I had a look and although it gives me some ideas doesn’t quite solve my problem. Is it possible to have a code something like the following that calls on a value entered into a form; Office365OutlookSendEmailV2(‘data source’.AssignedTo.Value’,”subject”,”body”) the Assigned to field in this case is not the current user logged in. Many thanks Debbie
Hello Shane, Great video as always! One question, I want to fetch the outlook contact groups(My contacts) and send an email to that group. I am able to send an email to an O365 group but not the contact groups. Kindly suggest how it can be done. Thanks in advance!
Hey Shane! Excellent video like always....speaking of emails, what about actionable emails (messages)? I know its more like a Flow thing but I think it would be very useful an approach on how to integrate that type of email with an App waiting for some user button action. Thanks!
Thanks for the video! I do have a question for you... I have a combo box and want to send email to users that are selected in the combobox. I did as what you said and the result come back as “builtinicon:mail” instead of emails. Any help would be great!
You created an email in power app, I need to be able to use a flow, not an app. I ALMOST have it figured out, but I can't quite get there. I was hoping you'd know - or have a resource that would - how to create the flow to send an email AND Cc a person/group when a status changes, for example.
Very helpful! I have a question, can I trigger email notifications to send emails without triggering the "button" everytime PowerApps has an update? Thank you so much
Good afternoon Shane, I do have a small question. On a separate screen I do Create a "HTML Text" body. This is updated after few seconds. I created a timer on a send button waiting for 20 seconds. On timer end it has the create mail stuff with sent, subject and as body the "HTML Text". But every time I nicely wait the 20 seconds it sends over an email with "Put HTM text here" Only after sending a 2nd time the body is attached. What am I doing wrong here? I do like your Video's switching back and forth between them to get stuff done. Thank you.
Very nice video and well explained, I have a question what if I want the emails to always come from the app creator ? like if we have forms and it doesn't matter who filled it -> once it is filled the app creator notify someone from his email. Thanks!
Hi Shane - love your videos - have been a great help!!! I am trying to combine two apps - shopping cart and email and want to send the email to the person who placed the order with the Order Id - but order ID is a variable - any idea on how can I do this ? I am also storing the variable in a container
Hi Shane, thanks for sharing this! I just wanted to know if there exists some time of solutions to send emails in Outlook Groups (with Group Id or such) becuase I didn't found a standard solution yet. So instead of the personal calendar I would need to display the Outlook groups calendar and also to create meeting from Power Apps to the group. Such solution would help me for my use case. Thank you!
Hey this video was helpful, but I was wondering if I was able to send a copy of an edit form they filled out created by a sharepoint list in power apps to users if they wanted one. I have done a lot of research on this issue, but I have hit a dead end. I have no idea how I can create this feature for the users. Any insight?
Great video. What if I set up an app like this up for an organization, but I get another job and my Outlook account is eventually deleted. Will the send email function still work, even though I would no longer have a 365 account?
@@ShanesCows thanks! That's good to know. I'm working on a few powerapp applications for an organization, but I won't be working for them for too much longer.
Thank you Shane for this video. I was wondering if it is possible to add one or many attachements (based on the user choice) from an existing table in Dataverse where we have already loaded our files. Thank you in Advance
Hi Shane, is it possible to just preview the email first but not send it right away? I would want to give the users the chance to review the email before sending in case they would want to add some extra discussions. Great vids, been a follower and learned so much from you!! Lots of love dude
Great video as usual Shane! I have a question if possible: I have a gallery, filtered by a dropdown, how do I email only the filtered items and not the entire gallery?thank you Valentina
Hi shane, Ive watched alot of your videos but this one has me a little confused, can you advise where im going wrong, Office365Outlook.SendEmailV2("Email.Address@gmail.com","Please reorder Toner","Can you please order more of the following: " & Tonercode_Dropdown.Selected.Value & Quantity_Input.Text) I've been playing around but cant seem to get both information on the email and if they are they are not spaced out to make it easier to read. Would appreciate the help. Thanks
@@ShanesCows the body is fine that shows up but for some reason the value selected in tonercode_dropdown.selected.value & quantity_input.text doesn't show on the email body
@@ShanesCows Hi Shane - So Glad to have found you. I have the same problem as @Scott Claxton and see you haven't yet replied to his question. I hope you have a solution for us!
I was hoping to email the view (image) of a bar graph table I created. I understand that if I can capture the table as and image to a collection or some other location I can use the SharePoint attachment resource you mentioned here to "attach" that image. How can I capture the "static" image of the table into a table. (do you have another video I could reference or could you advise) Thanks GB
There are a few ways. This is how we did it for a few customers ruclips.net/video/l8NJkauGJ7U/видео.html You could also use the connector called "Mail" and it comes from a generic Microsoft account.
Hi Shane, thank you so much for the video. I am having issues with having PowerApps properly sending the emails. The powerapp is connected to a sharepoint list which records data the user enters once the powerapp form is submitted. When I submit the form or some other members of my group submit the form, the app properly sends the email to my director. However when other members across my organization (not within my group) submit the form no email is being sent. Is this an issue with permission levels in the sharepoint list? All of the people using the form are part of my organization/company and have outlook accounts within the organzation.
It shouldn't be a security issue. I would put a simple button to send a test email on the screen and have one of those people press it. Does it work? I am not sure what your challenge is.
Hey Shane, Great video as always Thanks! Just a quick question if i add the outlook connector I’m using that to generate an OTP and send it to the user but i want the email to be sent by a service account instead it’s going from that logged in users account, I don’t want to provide the from as access to all the users so that they can do that any workaround without giving access?
Thanks Again Shane ! Much appreciated your help! I had another query in which i want to check if a library contains files or not if it does then let the user open a power app screen and start the approval process but if not then that user should be directed to a power apps screen where there it is showing that please upload a file in the library then start your approval is there any way to trigger the flow on uploading a file or creating a new library and run to check and update the file count so that way we can figure out if there’s any thing in the library or the user is just running approval on an empty library? Any ideas for this i tried the inbuilt function of file count that is in Sharepoint but I’m unable to use that in power apps so any work around for this?
Hi Shane! Thank you for this super helpful video! Do you happen to have another where you go into depth on getting an image into the html table/format so that you can embed a variable image into the body of the email?
I have written HTML for my email body, however, I can’t wrap my head around where PowerApps expects the various ” and & operators so I keep seeing the error Expected operator. We expect an operator such as +,*, or & at this point in the formula . Do you have an videos that explains this syntax further?
Try writing plain HTML for the body first SendEmailV2(User().Email, "Subject goes here", "Body goes here") Once you get that to work then slowly add a bit of html until you find the piece that trips you up. One guess might be that you are using " inside of your html like That wouldn't work in Power APps. But anywhere you are using " you can change it to ' and that would work. HOpe that helps
HI Shane.. thanks, this is really helpful. Is there a way to send email using the email address provided in the form itself? Like, link the email to the "Requestor" datacard in the form itself and upon submission can we send the entire form content to these requestors?
Hi Shane, tks for your molto helpful video. If it's possible I have a question for you. I understund how send an email from Powerapps, but I don't understand if it’s possible update a specific column in LIST whit a label “send” each time that I send a email. Es. I have a list of user and i want to know which user I have send the email e which no, I hope you have understand my english i write from Italy.. Tks in adv
Hey Shane thanks for the updates as always! I would like to know though, is it possible to use this connector to send an email notification from the app without having your name seen as the sender. Like making the app itself as the sender. I know their Mail connector but that thing's depreciated. Thanks in advance!
Hello Shane, I have this challenge: sending emails in bulk with parameters from a list, the issues is that I understand I need to save the attachment first to the attachment column in the list, and then send the bulk emails. How can I achieve that?
Hello again Shane. I have more than 999 people in my organization. In the video you mention you have a video that covers a workaround. I don't see it in the video list you provided. Can you please let us know which one to watch? Thanks!
Great videos! I appreciate everything you do Shane! Is there a way to send out emails from a generic email address as notifications. For example: I am making an Asset Checkout application. When a user checks out something from the inventory, I want an email or notification to go out to that user as a confirmation and to the application owner (and others) as informational for awareness, but I don't want the user to have to sign into outlook every time they login to the app.
The emails typically come from the user who clicks the button. If you want the email to come from a SendAs then yes, you will need to give permissions.
@@ShanesCows Hi, please, do you have any solution for when we have an open access power apps solution and we cannot grant access to everyone in the shared mailbox?
Hi Shane, does power apps have a limitation on number of SP list connection? i do have 30+ SP list with same structures on different url and planning to create a one app for that. or should i go with SQL? thanks in advance
Really Great ... Can we send email to Azure Ad users ..? using Microsoft365Outlook connector ..? Can we configure/HardCode(Shared Mail Box) From Email instead of connected account, so that it will trigger always from HardCoded email? Please reply.
How did you configure your Combo Box, so you can type in it? I have a separate search Text Input Box where user’s type in their name and it populates in the Combo Box.
Hi Shane, thanks for another awesome video! I’m interested in generating a pop-up window when “need more info” is selected from a drop down (versus setting a contextual variable in on select of a button). Is that possible to do OnChange? Have you had to do that for a customer yet? If so, would you mind recording a video on the topic?
thanks for the video. Its awesome. wat if i need to send email to different recipients based on dept; for eg; if I select Dept A - while submitting form it should trigger to person A; if I select Dept B - while submitting form it should trigger to person B; Any suggestions please
The email always comes from the person who "presses the button" or triggers the action in Power Apps. So if you put the SendEmailV2 function OnSuccess of your form then the email would come from the user who submitted the form, not you the person who made the app.
Love your videos, Shane! I have learned so much in the last three months. I have one issue though, the Powerapps form I created to email me the content, only works for me and not other uses. They receive the email but it only contains the default language in the body, but none of the content that the user would fill out in the form. Any ideas?
Linda try putting a label on the screen that shows what would go on the body. See if they see the right text in the label. I am guessing no. Troubleshoot from there. 😊
This video show how to use the Concat function to make a dynamic table. Also, you can use this ruclips.net/video/bfXV_GXc_JM/видео.html to learn more about it. This one produces a PDF but once it shows you how to make the HTML you could apply that to an email.
Hi Shane, I have used your method of uploading files to a Sharepoint Document Library using the stole attachment control, and its working fantastic! I have built my entire flow based on that video, and when I'm the one submitting the form using the Outlook Send Mail V2 option it works fine. When I try to change the connection in PowerAutomate to a different account (a service account with a no-reply email address) I constantly get a "Failed during HTTP Send Request" error when I try to re-attach the updated Flow to the Submit button. I've tried editing the app and the flow as the service account, and I still get the same error. If I change the email notifications to "Mail" they work fine, or if I am the connection for the Outlook Send Mail it works fine (but sends emails from my personal address), but the second I change the connection it fails again. We are using the same account as the connection for a different automated flow, and it works fine. Are you aware of any problems caused by changing the connection when using an Instant flow vs. an automated flow?
Hi Shane great job with the videos. Is there any way on earth one can embed images in the body of a powerapps email, or any type of workaround? Ctrl-C, Ctrl-V would be a big help in my teams process flow.
Hi Shane, great deep dive on email video. I still have one question though. In one of your Videos you send a email and had three buttons, well at least that is what it looked like. One of them had Good Job written on it. Anyway, are thoose written via HTML and secondly can a click on one of them update the sharepoint list. Like an approval?
I think I talk about using Email with Options in this video to do something very similar to that ruclips.net/video/umBegXooiKU/видео.html if you go to www.powerapps911.com and fill out the contact form you will get an email to see what it looks like. 😀
@@ShanesCows Hi Shane, I am trying to get an HTML field in the body of an email (using launch) and can't get around the limitations 😓... do you think there may be a Power Automate/PowerApps combo solution that can accomplish this?
Thanks for eudcating us…i have a requirement to automate thr browser from outlook. Through power automate i was able to send the email with links and attachments. But the requirement is to open the browser as soon as the user opens the email body. Kindly share any information ℹ️ thank you!!
@@aracellisierravega.3123 NO, tuve que crear una forma en sharepoint y luego bajarla automatica en powerapps. Pero lo que yo queria era enviar la forma bonita asi talcual aparese en powerapps, pero solo se envia en email los valores y en forma escrita no en formato de "forma".
Hi Shane, just being introduced to power Apps and looking for so e information. I'm looking to create a workflow for external users go submit a product inspection request. Can external users be given access, or do you have to create a special account for external user access? Also can power Apps link to other systems like Oracle?
Shane im smilimg. I'm old enough to understand Cc and Bcc. Carbon Copy. in the days of hand written mail, carbon copy paper was used to keep a copy of the letter.Bcc was new when email was introduced. Blind carbon copy. make a carbon copy but dont let people know you are doing it. I wonder if theses terms will be around after another 50 years of email?
Hello Shane, I don't see the "From: " option in the additional function parameters, my connector enables a function like...."Office365Outlook.SendEmailV2(...." not like the one you show as "Microsoft365Outlook.SendEmailV2(...", do you know why?
Hi Shane, love all of your videos and this one is no exception. However, I am getting hung up with an error. I have search the interwebs for this error with no luck. Instead of getting an email address when I use concat I get "builtinicon:Mail". The rest of the concat function works (format, there separators, number of recipients) but each email address just reads "builtinicon:Mail". Data source is a SharePoint list with column type of Person. Someone else had mentioned this below. Any ideas how to troubleshoot this?
Hey Shane, I have a sharepoint list which contains deeplinks for all the screens i've created in powerapps. I've been able to send email with this link using the ThisItem.'PowerApps Deeplink', however how do i shorten it to just show a hyperlink eg. "click Link" (similar to what you have in your video) instead of the whole url sting which looks messy? thanks
In powerapps can we use lookup function inside patch function? Actually I want to use some refrence name instead of column names in patch function. For ex instead of writing column name I will write any label which will have column name in patch function. Please revert if this can be done!! Thankyou
Hi sir, can we send email automatically without button. Example if my label value is grater then 10 automatically send email and also call power automate flow. Please help
I guess if they had an input you could send email/run flow using the OnChange property. If it is a lable it does not have that property. Maybe send the email OnVisible of the screen?
Hello shane, just wondering re sa premium accounts for powerbi, if i have a premium account, technically, I can use SQL Database as a back-end/repository for my data. If I am going to publish the apps and let other users with just standard account, are they allowed to Create/Edit/Update/Delete data connected to the SQL Database?
Thanks Shane. I selected email IDs from combo box and added them as text in label box and see that the output is ".+@.+\.[^\.]{2,}" instead of actual email id. Can you please let me know what am i missing? It was working fine fist time.
I am almost worried how good I will be at Power apps after watching your videos!! Greetings from the Czech Republic.
Glad to hear that! Work hard and you will be the best!
@@ShanesCows Shane, sorry for bothering you - you must go crazy from all the comments. However I wonder if you could help. I connected D365 Finance to my canvas powerapp. I want to create purchase requisitions using powerapps. The problem is I need to submit the requisition with a number sequence ID that D365 expects. Can I solve this? Or am I using power apps incorrectly when I try to do this? Thank you! Lukas
Shane thanks for all of your videos they have been a tremendous help. I've been watching all of them for a couple months now preparing for my place of employment to start utilizing Power Apps. I've been informed we are now going to be utilizing model driven apps. I love the way you teach and was hoping you could point me in the right direction for resources to continue to learn.
Hey Mike i haven’t done much with model driven. Boo me. 😑
Thanks Shane your videos are very informative and unique and really helps me out during my training period
Great to hear!
awesome explanation for attachments - it saved my project!
Great to hear!
Thanks for this video Shane, you have taught me so much about PowerApps over the last few months! Always well delivered with enough information to get you going but with lots of other little tips along the way.
Glad you like them and love the puppy picture!
@@ShanesCows He's one of my two canine overlords!
This video is a lifesaver, thank you for sharing this!
Glad it was helpful!
Thank you!! This helped me resolve an issue I was having using Launch("mailto:") and is better than it was.
Awesome.
Was redirected here from earlier video. Thank you so much for this!
Glad it was helpful!
You really helped me out a lot, thank you Shane. Youre doing great work :)
Happy to help!
Very comprehensive and useful. Cheers
Glad to help. 😀
Thanks Shane awesome video and for all your effort to teach and share your knowledge
My pleasure!
Thank you. Very helpful. Do you have any video on error handling?
Like: iferror, isblankorerror, how to handle system errors, like you getting lets say calendar event, and if it does not exists you get system error. How to do something like try catch.
I haven't made any content on that... added to the list.
Hi Shane, thanks for another awesome video!
Glad you enjoyed it!
Nice one, this is exactly what I was looking for...:)
😻
So helpful, Shane, as always and you do an awesome job of breaking it down. Love the use of labels as secret decoder rings!
Is it possible to add more than 1 Bcc email address?
Thanks!!
Yes, separate them by a ;
Hi Shane, great video, one question I have is how do you reset the values in each field for when a user wants to submit another email so that they aren't greeted with the text they previously sent.
Edit: just figured it out for anyone wondering you can include:
& Reset(TextInput1)
Awesome 🤩
The function changed to Office365Outlook.SendEmailV2 you´re welcome oh and Shane thanks for the effort you´ve put into this
Thanks 🐶
Hey Shane, came here from an earlier episode. I have a slightly involved question, I want to send out a duplicate email to multiple people. But these people are going to be different every time. For example I want to send an email to everyone in a SharePoint list that has a column value of 1 or of 2. Should I use a ForAll or should I use a Flow? Thank you!! You've been a big help.
Hi Shane! Thanks for all your videos, it´s really helpful. I hope you can help me with a duplicate email problem. I made a Offline APP and when it sync to my Sharepoint it was supose to send an email, but I don´t no why, sometimes it send a lots of blank emails. Thanks again.
I assume you are using a table to loop through that you are sending emails from? Maybe filter the table for blank records and only send for records that are not blank?
Thanks Shane. Awesome video and info.
You bet!
Thank you!! very nice; and then, if you send email from form how can you Put in BCC the same email address from the people who do the form? exist any way?
{Bcc:User().Email}
Hi Shane! Thank you for this super video!
Is it possible to add a notification when mail sent on Power Apps?
Like a message "Mail sent" show up when we clicked "Send email".
Otherwise my users may click 10times...to be sure.
Any way to have both: html inside the body AND open the email (in outlook) as draft to let user add info to the body before to send it?
www.w3docs.com/snippets/html/how-to-create-mailto-links.html should have the answers.
@@ShanesCows thank you for your reply Shane. And by the way thank you for sharing very educative videos. It was a great help to me. I did not ask correctly my question. Let me give an example: I want to use Launch("MailTo: to get the email in draft because the sender may decide to add /modify the given template, and I want to include a deeplink to Powerapps inside the body. My deeplink works well in a browser, but it is not displayed as a hyperlink in the email.
Hey Shane, thank you for sharing your knowledge, you'll be blessed for that. I just have one question, what if one wanted to send an email to someone outside the organization. How do we get that email address in the "To:" Dropdown?
That is up to you. Power Apps doesn't care what the email address is as long as it is text. So you could have a text input control name inpEmail and then set your TO in the formula to be inpEmail.Text and Power Apps would be happy.
Hello Shane, thanks for sharing, quick question, how do you send the email to a different person every time coming from a gallery, I want to improve the Meeting notes App from the PowerApps template to be able to attach docs also, and send those attachments to the attendees.
The to field is just text. You can pass it different values each time. The question is how do you want to get those values.
@@ShanesCows thanks, well I have a gallery where the emails are located and you can add / eliminate emails, so I don't know how to get that text in order to use the Office365Outlook.Sendemailv2
Thanks Shane, i love your content!
You are welcome 🙏 Have a great day!
Shane you a legend! . but i got a problemo - My users are not visible in the combobox?. I jsut see like blank rows...no names appear.. do i need to right the concat formula too?
Click on the combo box in Studio. Then on the right click on Field. Choose a name field, you are showing a blank field right now.
Hi Shane, great video! One question is there any way to have your signature on the email? Thanks!
Alan email signatures are stored in your Outlook client, not in Exchange online. :( So I don't think you can get them.
Hi Shane, great video but wondering could you help me with something? I have a form connected to a SharePoint list. One of the fields is a people picker - I call this Assigned To. When I submit this form I would like to send an email to the person selected in the Assigned To field. Could you tell me how to do this? Thanks Debbie
Hey Debbie this should help. ruclips.net/video/q2bhlBAqN_E/видео.html It is about having the email go out OnSuccess of your form submission.
Hi Shane, thanks for the quick response. I had a look and although it gives me some ideas doesn’t quite solve my problem. Is it possible to have a code something like the following that calls on a value entered into a form;
Office365OutlookSendEmailV2(‘data source’.AssignedTo.Value’,”subject”,”body”)
the Assigned to field in this case is not the current user logged in. Many thanks Debbie
Hello Shane, Great video as always! One question, I want to fetch the outlook contact groups(My contacts) and send an email to that group. I am able to send an email to an O365 group but not the contact groups. Kindly suggest how it can be done. Thanks in advance!
Hi Shane
You didn't show that what you used deep linking mail . can I get that functions ... Please
This video ruclips.net/video/A5Pi5P2YKds/видео.html
65,000 more views on that last video since you posted this :D
Hey Shane! Excellent video like always....speaking of emails, what about actionable emails (messages)? I know its more like a Flow thing but I think it would be very useful an approach on how to integrate that type of email with an App waiting for some user button action.
Thanks!
I think I show email with options in this video. ruclips.net/video/umBegXooiKU/видео.html
Thanks for the video! I do have a question for you... I have a combo box and want to send email to users that are selected in the combobox. I did as what you said and the result come back as “builtinicon:mail” instead of emails. Any help would be great!
Sorry I am slow. Check the syntax of your Concat function.
Do you happen to have a video about how to use SharePoint flows to do some of these things in email or can you point me in the right direction??
Sorry, I don't follow what you are looking for?
You created an email in power app, I need to be able to use a flow, not an app. I ALMOST have it figured out, but I can't quite get there. I was hoping you'd know - or have a resource that would - how to create the flow to send an email AND Cc a person/group when a status changes, for example.
Hi Shane thank you for the great video, you're Super!
Thanks 😊
Hi Shane, amazing video!! - how can i send email based on user signed in and not pre define it in the formula bar?
Use the User() function to get the information about the signed in user. ruclips.net/video/FpXrF5NDZbI/видео.html
@@ShanesCows thanks shane🙏🏼highly appreciated
Do you have a video where you select multiple records in a gallery and send an email for each record with a click of one button?
This video would have the mechanics Power Apps Select Multiple Items in A Gallery
ruclips.net/video/wpZbYPvPO68/видео.html
Hey thanks a lot, but how make it to clear the fill boxes after sending?
You can use the Reset function. Reset(TextInput1) for example
Very helpful! I have a question, can I trigger email notifications to send emails without triggering the "button" everytime PowerApps has an update? Thank you so much
Good afternoon Shane, I do have a small question. On a separate screen I do Create a "HTML Text" body. This is updated after few seconds. I created a timer on a send button waiting for 20 seconds. On timer end it has the create mail stuff with sent, subject and as body the "HTML Text". But every time I nicely wait the 20 seconds it sends over an email with "Put HTM text here" Only after sending a 2nd time the body is attached. What am I doing wrong here? I do like your Video's switching back and forth between them to get stuff done. Thank you.
You will need to put the HTML control on the screen the Send button is on. YOu can set Visible to false so no one sees it.
If I only knew it was this simple, Thank you
Hi Shane, do you know how to transpose the html table? Thanks!
We have done it but it is painful. No quick pointer. Sorry. Brute force 😑
@@ShanesCows I managed to do it. The bad thing is getting a PDF from that table shows a mess between rows and columns.
Very nice video and well explained, I have a question what if I want the emails to always come from the app creator ? like if we have forms and it doesn't matter who filled it -> once it is filled the app creator notify someone from his email.
Thanks!
Maybe something like this? ruclips.net/video/l8NJkauGJ7U/видео.html
@@ShanesCows Thanks!
Hi Shane - love your videos - have been a great help!!! I am trying to combine two apps - shopping cart and email and want to send the email to the person who placed the order with the Order Id - but order ID is a variable - any idea on how can I do this ? I am also storing the variable in a container
hi shane can u upload a video like after submit a form it will email the details to the sender?
I replied to your other comment with a guide. :)
Hi Shane, thanks for sharing this! I just wanted to know if there exists some time of solutions to send emails in Outlook Groups (with Group Id or such) becuase I didn't found a standard solution yet. So instead of the personal calendar I would need to display the Outlook groups calendar and also to create meeting from Power Apps to the group. Such solution would help me for my use case. Thank you!
Hi Shane, great vid! How do I add new lines to the body text of the email? Thanks
Email body is HTML. So you can use to create blank lines.
Thank you sir 😊
Most welcome
Hey this video was helpful, but I was wondering if I was able to send a copy of an edit form they filled out created by a sharepoint list in power apps to users if they wanted one. I have done a lot of research on this issue, but I have hit a dead end. I have no idea how I can create this feature for the users. Any insight?
Create html to represent the form and send it as the body of the email.
Great video. What if I set up an app like this up for an organization, but I get another job and my Outlook account is eventually deleted. Will the send email function still work, even though I would no longer have a 365 account?
Yes, the email comes from the person who clicks the button in the app, not you.
@@ShanesCows thanks! That's good to know. I'm working on a few powerapp applications for an organization, but I won't be working for them for too much longer.
Thank you Shane for this video.
I was wondering if it is possible to add one or many attachements (based on the user choice) from an existing table in Dataverse where we have already loaded our files.
Thank you in Advance
Hi Shane, is it possible to just preview the email first but not send it right away? I would want to give the users the chance to review the email before sending in case they would want to add some extra discussions. Great vids, been a follower and learned so much from you!! Lots of love dude
Use Mailto ruclips.net/video/OGcofeqPFlc/видео.html
Great video as usual Shane! I have a question if possible: I have a gallery, filtered by a dropdown, how do I email only the filtered items and not the entire gallery?thank you Valentina
Gallery.AllItems has a table of the records. Use it combined with Concat to get the email addresses.
Hi shane, Ive watched alot of your videos but this one has me a little confused, can you advise where im going wrong,
Office365Outlook.SendEmailV2("Email.Address@gmail.com","Please reorder Toner","Can you please order more of the following: " & Tonercode_Dropdown.Selected.Value & Quantity_Input.Text)
I've been playing around but cant seem to get both information on the email and if they are they are not spaced out to make it easier to read.
Would appreciate the help. Thanks
The body is html text. So you can format it to look as nice or as ugly as you want. 😀 your syntax looks good for basic text though.
@@ShanesCows the body is fine that shows up but for some reason the value selected in tonercode_dropdown.selected.value & quantity_input.text doesn't show on the email body
@@ShanesCows Hi Shane - So Glad to have found you. I have the same problem as @Scott Claxton and see you haven't yet replied to his question. I hope you have a solution for us!
Using the new Microsoft365Outlook connector how would the code now look from your Video No2 when sending the PenInput image as an attachment? Cheers
Only part that would be different is the email function name. The code for package up the signature is the same.
Hey Shane, loved your videos!
Q: I was trying to encrypt emails using Power Apps with Outlook, any tips on that ?
I haven’t tried that one. Sorry. Let me know what you find. 😊
I was hoping to email the view (image) of a bar graph table I created.
I understand that if I can capture the table as and image to a collection or some other location I can use the SharePoint attachment resource you mentioned here to "attach" that image.
How can I capture the "static" image of the table into a table. (do you have another video I could reference or could you advise)
Thanks GB
Hi Greg. There is no way to take what see on the screen and send it. You would need to create a table via HTML would be you best chance. Maybe SVGs?
@@ShanesCows Thanks Shane - I appreciate you helping me to avoid a rabbit trail.
Is there a way that the emails generated from PowerApps or a flow to come from PowerAutomate or PowerApps, instead of the user?
There are a few ways. This is how we did it for a few customers ruclips.net/video/l8NJkauGJ7U/видео.html You could also use the connector called "Mail" and it comes from a generic Microsoft account.
Hi Shane, thank you so much for the video. I am having issues with having PowerApps properly sending the emails. The powerapp is connected to a sharepoint list which records data the user enters once the powerapp form is submitted. When I submit the form or some other members of my group submit the form, the app properly sends the email to my director. However when other members across my organization (not within my group) submit the form no email is being sent. Is this an issue with permission levels in the sharepoint list? All of the people using the form are part of my organization/company and have outlook accounts within the organzation.
It shouldn't be a security issue. I would put a simple button to send a test email on the screen and have one of those people press it. Does it work? I am not sure what your challenge is.
Hey Shane, Great video as always Thanks! Just a quick question if i add the outlook connector I’m using that to generate an OTP and send it to the user but i want the email to be sent by a service account instead it’s going from that logged in users account, I don’t want to provide the from as access to all the users so that they can do that any workaround without giving access?
This is one way I did exactly that. ruclips.net/video/l8NJkauGJ7U/видео.html
Thanks Again Shane ! Much appreciated your help! I had another query in which i want to check if a library contains files or not if it does then let the user open a power app screen and start the approval process but if not then that user should be directed to a power apps screen where there it is showing that please upload a file in the library then start your approval is there any way to trigger the flow on uploading a file or creating a new library and run to check and update the file count so that way we can figure out if there’s any thing in the library or the user is just running approval on an empty library? Any ideas for this i tried the inbuilt function of file count that is in Sharepoint but I’m unable to use that in power apps so any work around for this?
Hi Shane!
Thank you for this super helpful video!
Do you happen to have another where you go into depth on getting an image into the html table/format so that you can embed a variable image into the body of the email?
This is probably the best I have. ruclips.net/video/bIne3DD3HAg/видео.html
I have written HTML for my email body, however, I can’t wrap my head around where PowerApps expects the various ” and & operators so I keep seeing the error Expected operator. We expect an operator such as +,*, or & at this point in the formula . Do you have an videos that explains this syntax further?
Try writing plain HTML for the body first SendEmailV2(User().Email, "Subject goes here", "Body goes here")
Once you get that to work then slowly add a bit of html until you find the piece that trips you up. One guess might be that you are using " inside of your html like That wouldn't work in Power APps. But anywhere you are using " you can change it to ' and that would work.
HOpe that helps
HI Shane.. thanks, this is really helpful. Is there a way to send email using the email address provided in the form itself? Like, link the email to the "Requestor" datacard in the form itself and upon submission can we send the entire form content to these requestors?
Hi Shane,
tks for your molto helpful video. If it's possible I have a question for you. I understund how send an email from Powerapps, but I don't understand if it’s possible update a specific column in LIST whit a label “send” each time that I send a email. Es. I have a list of user and i want to know which user I have send the email e which no, I hope you have understand my english i write from Italy.. Tks in adv
Hey Shane thanks for the updates as always! I would like to know though, is it possible to use this connector to send an email notification from the app without having your name seen as the sender. Like making the app itself as the sender. I know their Mail connector but that thing's depreciated. Thanks in advance!
Not this connector but I did it differently in this video. ruclips.net/video/l8NJkauGJ7U/видео.html
@@ShanesCows Hi! sorry for the very late reply but just wanna say thanks!
Hello Shane, I have this challenge: sending emails in bulk with parameters from a list, the issues is that I understand I need to save the attachment first to the attachment column in the list, and then send the bulk emails. How can I achieve that?
Give this a watch. I show you how I sent out bulk emails. ruclips.net/video/umBegXooiKU/видео.html
Hello again Shane. I have more than 999 people in my organization. In the video you mention you have a video that covers a workaround. I don't see it in the video list you provided. Can you please let us know which one to watch? Thanks!
Nevermind Shane, I just saw your Contact function link above. Have a great day! Give Chewy a pat for me :)
This one is that referenced video ruclips.net/video/QhGV4AhCFRc/видео.html
Chewy says thanks🐶
Shane Young Thanks Shane! I used to have a Golden Doodle too. They are sweet dogs.
Great videos! I appreciate everything you do Shane! Is there a way to send out emails from a generic email address as notifications. For example: I am making an Asset Checkout application. When a user checks out something from the inventory, I want an email or notification to go out to that user as a confirmation and to the application owner (and others) as informational for awareness, but I don't want the user to have to sign into outlook every time they login to the app.
Yes, using the SMTP connector. It is on my video list to make. Soon I hope.
@shane is it possible to send email only to Bcc , and no recipients in to and cc ?
I don't know... I have never tried.
amazing video, one question, do I need to give send as permission to everyone to send email from a specific sender?
The emails typically come from the user who clicks the button. If you want the email to come from a SendAs then yes, you will need to give permissions.
@@ShanesCows Hi, please, do you have any solution for when we have an open access power apps solution and we cannot grant access to everyone in the shared mailbox?
Hi Shane, does power apps have a limitation on number of SP list connection? i do have 30+ SP list with same structures on different url and planning to create a one app for that. or should i go with SQL? thanks in advance
I don’t think so. I have had a lot but never counted them.
Really Great ...
Can we send email to Azure Ad users ..? using Microsoft365Outlook connector ..?
Can we configure/HardCode(Shared Mail Box) From Email instead of connected account, so that it will trigger always from HardCoded email?
Please reply.
Try this ruclips.net/video/l8NJkauGJ7U/видео.html
How did you configure your Combo Box, so you can type in it?
I have a separate search Text Input Box where user’s type in their name and it populates in the Combo Box.
You can set the ComboBox to IsSearchable = true and then you can define the search field. Should work from there 😎
Hi Shane, thanks for another awesome video! I’m interested in generating a pop-up window when “need more info” is selected from a drop down (versus setting a contextual variable in on select of a button). Is that possible to do OnChange? Have you had to do that for a customer yet? If so, would you mind recording a video on the topic?
Your Dropdown has an OnChange property where you can put code the same as OnSelect of a button. 😀
Shane Young great, thank you 😊
thanks for the video. Its awesome. wat if i need to send email to different recipients based on dept; for eg; if I select Dept A - while submitting form it should trigger to person A; if I select Dept B - while submitting form it should trigger to person B; Any suggestions please
How would you use this method to send an email from the person that last modified the form?
The email always comes from the person who "presses the button" or triggers the action in Power Apps. So if you put the SendEmailV2 function OnSuccess of your form then the email would come from the user who submitted the form, not you the person who made the app.
Love your videos, Shane! I have learned so much in the last three months. I have one issue though, the Powerapps form I created to email me the content, only works for me and not other uses. They receive the email but it only contains the default language in the body, but none of the content that the user would fill out in the form. Any ideas?
Linda try putting a label on the screen that shows what would go on the body. See if they see the right text in the label. I am guessing no. Troubleshoot from there. 😊
@@ShanesCows Thanks for the tip, Shane!
Is their any limitation with outlook 365 connector like 10k emails per day? How can we over come that?
Not that I know of.
clap clap now i know what i will do in case i get a request like that thank you
Awesome 😎
Hi, Great video, really helped a lot. Question though, how would I send a form through outlook?
I am not sure. I have not done forms or adaptive cards in Outlook.
@@ShanesCows oh maan. I'm really struggling with getting a button to submit a form then get the results of that form to send off through outlook.
It is awesome video shane :)....how to print dynamic table in Outlook without header?
This video show how to use the Concat function to make a dynamic table. Also, you can use this ruclips.net/video/bfXV_GXc_JM/видео.html to learn more about it. This one produces a PDF but once it shows you how to make the HTML you could apply that to an email.
Hi Shane, I have used your method of uploading files to a Sharepoint Document Library using the stole attachment control, and its working fantastic! I have built my entire flow based on that video, and when I'm the one submitting the form using the Outlook Send Mail V2 option it works fine. When I try to change the connection in PowerAutomate to a different account (a service account with a no-reply email address) I constantly get a "Failed during HTTP Send Request" error when I try to re-attach the updated Flow to the Submit button. I've tried editing the app and the flow as the service account, and I still get the same error. If I change the email notifications to "Mail" they work fine, or if I am the connection for the Outlook Send Mail it works fine (but sends emails from my personal address), but the second I change the connection it fails again. We are using the same account as the connection for a different automated flow, and it works fine. Are you aware of any problems caused by changing the connection when using an Instant flow vs. an automated flow?
I think you need to remove the flow from the Power App and then add it again.
Hi Shane great job with the videos. Is there any way on earth one can embed images in the body of a powerapps email, or any type of workaround? Ctrl-C, Ctrl-V would be a big help in my teams process flow.
This video. ruclips.net/video/bIne3DD3HAg/видео.html 😀
Great video Shane. One question, what's the maximum number of emails we can send from the SharePoint list using power automate in one click?
I don’t know of a limit.
Hi Shane, great deep dive on email video. I still have one question though. In one of your Videos you send a email and had three buttons, well at least that is what it looked like. One of them had Good Job written on it. Anyway, are thoose written via HTML and secondly can a click on one of them update the sharepoint list. Like an approval?
I think I talk about using Email with Options in this video to do something very similar to that ruclips.net/video/umBegXooiKU/видео.html if you go to www.powerapps911.com and fill out the contact form you will get an email to see what it looks like. 😀
Hey Shane, Can I open Outlook desktop client with powerapps with preloaded data(email body, attachment, to, cc etc)
Yes. Use the Launch function to trigger the html MailTo. It is on my list to cover in a video soonish.
@@ShanesCows thanks
@@ShanesCows Hi Shane, I am trying to get an HTML field in the body of an email (using launch) and can't get around the limitations 😓... do you think there may be a Power Automate/PowerApps combo solution that can accomplish this?
Thanks for eudcating us…i have a requirement to automate thr browser from outlook. Through power automate i was able to send the email with links and attachments. But the requirement is to open the browser as soon as the user opens the email body. Kindly share any information ℹ️ thank you!!
I started a canvas from scratch, how can I send my app content as it shows in the form through email? Need Help PLS!
You would reference your app controls in the body of the email section as shown in this video.
@@ShanesCows I followed your video but the formula still shows errors. I am desperate.
Hola, disculpa que me entrometa, pero lo conseguiste? Estoy en busca de lo mismo!!
@@aracellisierravega.3123 NO, tuve que crear una forma en sharepoint y luego bajarla automatica en powerapps. Pero lo que yo queria era enviar la forma bonita asi talcual aparese en powerapps, pero solo se envia en email los valores y en forma escrita no en formato de "forma".
Hi Shane, just being introduced to power Apps and looking for so e information. I'm looking to create a workflow for external users go submit a product inspection request. Can external users be given access, or do you have to create a special account for external user access? Also can power Apps link to other systems like Oracle?
Can you do the same with 365groups connector? I'm trying to send to all emails in a 365 group.
I haven't tried that. If the group has an email address, and it should, you can use this to send the email to the group's email address.
Shane im smilimg. I'm old enough to understand Cc and Bcc. Carbon Copy.
in the days of hand written mail, carbon copy paper was used to keep a copy of the letter.Bcc was new when email was introduced. Blind carbon copy.
make a carbon copy but dont let people know you are doing it. I wonder if theses terms will be around after another 50 years of email?
how might you have all the email information be on another screen but have it still email the user with the information the other email screen?
Hello Shane, I don't see the "From: " option in the additional function parameters, my connector enables a function like...."Office365Outlook.SendEmailV2(...." not like the one you show as "Microsoft365Outlook.SendEmailV2(...", do you know why?
Found the issue... I have to use the Microsoft365Outlook connector
Glad you got it.
Hi Shane, love all of your videos and this one is no exception. However, I am getting hung up with an error. I have search the interwebs for this error with no luck. Instead of getting an email address when I use concat I get "builtinicon:Mail". The rest of the concat function works (format, there separators, number of recipients) but each email address just reads "builtinicon:Mail". Data source is a SharePoint list with column type of Person. Someone else had mentioned this below. Any ideas how to troubleshoot this?
Leo leave a new comment with your formula and let me see what I can do.
Hey Shane, I have a sharepoint list which contains deeplinks for all the screens i've created in powerapps. I've been able to send email with this link using the ThisItem.'PowerApps Deeplink', however how do i shorten it to just show a hyperlink eg. "click Link" (similar to what you have in your video) instead of the whole url sting which looks messy?
thanks
You need to create an html A tag. www.w3schools.com/tags/tag_a.asp
In powerapps can we use lookup function inside patch function?
Actually I want to use some refrence name instead of column names in patch function. For ex instead of writing column name I will write any label which will have column name in patch function.
Please revert if this can be done!!
Thankyou
Not possible I don’t think. Sorry
Hi sir, can we send email automatically without button. Example if my label value is grater then 10 automatically send email and also call power automate flow. Please help
I guess if they had an input you could send email/run flow using the OnChange property. If it is a lable it does not have that property. Maybe send the email OnVisible of the screen?
@@ShanesCows thank you sir
Hi Shane, i need to hide the email sender to avoid 'spam' to our technicians from our customers. Is there a possibility to do this?
This is one way to do it. ruclips.net/video/l8NJkauGJ7U/видео.html
Hello shane, just wondering re sa premium accounts for powerbi, if i have a premium account, technically, I can use SQL Database as a back-end/repository for my data. If I am going to publish the apps and let other users with just standard account, are they allowed to Create/Edit/Update/Delete data connected to the SQL Database?
Not they have to have a premium license also b
Thanks Shane. I selected email IDs from combo box and added them as text in label box and see that the output is ".+@.+\.[^\.]{2,}" instead of actual email id. Can you please let me know what am i missing? It was working fine fist time.
I would have expected it to be Combobox.Selected.Mail
@@ShanesCows Thanks Shane, it worked. Your videos are of great help.