It worked. I worked on this all day and didnt think to just manually send it from my app every morning. haha! automation 101. if it take more time to automate it. you're doing it wrong....
Timing couldn't have been much better as I'm in the middle of a project that will require sending emails from within the App, after 3pm on Friday's so this concept will be handy. Thanks for sharing. Really appreciated
Oh man TY. This is actually kinda what I was doing today. I didnt even think to try the HTML method from within power apps. That seems much easier and more versitile. Night project!!
Thank you so much! I was able to send an email with an attachment! New issue unlocked lol.... I am creating a form that writes to a sharepoint list. I only need to send an email with attachment if the file size is over 10MB, as that is the limit for actually writing to my sharepoint list. ..... Is this possible?
Thanks Shane, this is very helpful for my app. But my app also has some flows that are triggered based on certain values changing on a sharepoint list. Those all have me as sender no matter who uses the app, since I'm the owner. Also to add even more fun and complexity, the emails I'm sending are Send Email with Options which has no "From" field or Send As. I saw a video that talked about a shared mailbox and sending the mails twice to achieve this. Could you possibly do a video on that? I find your videos much more understandable. Or, if you have any suggestions, I'm open to them. Thank you very much for all you share with us.
Yeah, with the flows since they are triggered when an Item changes, they will be tied to the connection you specified in flow, usually the owner of the flow. Could you change the flow to be triggered by the app so it came from the person using the app? We have a similar internal process. What we did was created an account for HelpNow and then added it as a co-owner of the flow. Then used its connections. So now all of those emails come from HelpNow not me. 😊
Hi shane, Is there any way to pass the datasource dynamically in powerapps. Because i am having same list schemma but in different sharepoint site, i have a selection screen at the first. When the user selects the value from the dropdown. That datasource is loading now. But in my case, i have 4 datasource it is working as expected. If i add more datasource, the performance is getting reduced. Could you please suggest your thoughts over here
Hi, Send email with HTML Control works perfectly in Edit Mod, but it doesn't work when published. Email is not send, it's like Power apps doesn't see this HTML control...How to face it?
My problem was that the mailto wouldn't recognize certain properties. My goal was to create a draft from my form into a table and list the attachments at the bottom. Every time I tried to do anything other than text from the control it would break everything. Eventually I ended up using power automate which is so redundant for something like this. And makes sending multiple attachments a headache I still haven't figured out. I wanted my users to just toggle control whether they wanted to send an email when they submit their form and then boom it opens a draft when they submit their data, in an HTML table and shows the attachments at the bottom. Another issue I always get criticism about is users not able to paste an image or multiple images, and that causes them to lose their form data by having to go take the image or screenshot, and start all over so now I gotta add a save component to my form just because power apps doesn't have a feature to let users pick up where they left off
From a regular mailbox is easy th-cam.com/video/MeQDIBrJjRg/w-d-xo.html From a shared? I have never tried but I think the only chance is if you can do it via the Graph API. There is no built in action for it as far as I know.
You state that the email is sent on behalf of the user who pressed the button in the form. I don't think this is correct. The sender is the user who was specified when setting up the Office365 connector.
When you setup Power Apps to use the Outlook connector the email will always come from the person who pressed the button, not the maker of the app. This is why when you use the app the first time you ahve to consent to using your authentication.
There is a From: optional parameter but, to use it, you have to have permissions to send as that user. About the 12:05 mark I talk through it a little bit.
@@ShanesCows Yes, Shane. I tried that as well. But what I want to achieve is to allow my PowerApps users to send emails on behalf of a particular email account. The catch is I cannot give permission to all of my users to do that. I know how to achieve that in Power Automate though. Thanks for the video, Shane
@@HPTeguh Glad to help. I will say for one of our internal processes we do the same and we used the SMTP connector. Just another random thought if it helps th-cam.com/video/l8NJkauGJ7U/w-d-xo.html
User().Email is the formula to get the logged in users email. If you want the email to automatically go when someone submits a form, you can put the code in the OnSubmit property of the Form control.
It worked. I worked on this all day and didnt think to just manually send it from my app every morning. haha! automation 101. if it take more time to automate it. you're doing it wrong....
Yeah, once you start writing HTML craziness in Power Apps you almost never use Automate to do it anymore. :)
Great video and super helpful, thank you!
Is there a way to refresh the form once the email has been sent at all please?
Deep Links concept... So Awesome. Loving this stuff Shane keep it coming
Deep linking is one of my favorites, opens so many doors.
@@ShanesCows would you be able to dynamically change the ID from the link? lets say based on the selected item from the gallery?
@@rlsid Yes, this video th-cam.com/video/olJWU756tl0/w-d-xo.html
Timing couldn't have been much better as I'm in the middle of a project that will require sending emails from within the App, after 3pm on Friday's so this concept will be handy. Thanks for sharing. Really appreciated
Glad it helped!
Perfect timing! I am working on a project that needs this function. So thank you Shane. Question: Can you link this to a SharePoint mailing list?
Any valid email address will work in the To: 😎
Beautiful Shane. Really enjoyed this video
Glad you enjoyed it
Thank you Shane
Have a good weekend!
Oh man TY. This is actually kinda what I was doing today. I didnt even think to try the HTML method from within power apps. That seems much easier and more versitile. Night project!!
Glad I could help!
Thank you so much! I was able to send an email with an attachment! New issue unlocked lol.... I am creating a form that writes to a sharepoint list. I only need to send an email with attachment if the file size is over 10MB, as that is the limit for actually writing to my sharepoint list. ..... Is this possible?
I don't think there is any way for Power Apps to know the file size 🤔
Thanks Shane, this is very helpful for my app. But my app also has some flows that are triggered based on certain values changing on a sharepoint list. Those all have me as sender no matter who uses the app, since I'm the owner. Also to add even more fun and complexity, the emails I'm sending are Send Email with Options which has no "From" field or Send As. I saw a video that talked about a shared mailbox and sending the mails twice to achieve this. Could you possibly do a video on that? I find your videos much more understandable. Or, if you have any suggestions, I'm open to them. Thank you very much for all you share with us.
Yeah, with the flows since they are triggered when an Item changes, they will be tied to the connection you specified in flow, usually the owner of the flow.
Could you change the flow to be triggered by the app so it came from the person using the app?
We have a similar internal process. What we did was created an account for HelpNow and then added it as a co-owner of the flow. Then used its connections. So now all of those emails come from HelpNow not me. 😊
Your videos are great! Thank you!
You're very welcome!
Is there a way to get emails from your outlook? Like getting all the emails you sent out last week from your outlook?
Yes, Office365Outlook.GetEmails() is where you can start and then work on filtering and refining from there. 😎
@@ShanesCows Awesome! Thanks 🙏
Any idea why the new modern button control don't has any tooltip? If we use just icons on buttons a hint would be a handy thing ....
Nope. The modern controls are a mixed bag of features 🙃
Hi shane,
Is there any way to pass the datasource dynamically in powerapps.
Because i am having same list schemma but in different sharepoint site, i have a selection screen at the first. When the user selects the value from the dropdown. That datasource is loading now. But in my case, i have 4 datasource it is working as expected. If i add more datasource, the performance is getting reduced. Could you please suggest your thoughts over here
There isn't really a better way to do it. 🙃 Sorry.
@@ShanesCows ok 👍
Hi,
Send email with HTML Control works perfectly in Edit Mod, but it doesn't work when published. Email is not send, it's like Power apps doesn't see this HTML control...How to face it?
That is odd, that hasn't happened. Do you have the HTML control shown on the screen? That way you can confirm it has the info you think it does?
My problem was that the mailto wouldn't recognize certain properties. My goal was to create a draft from my form into a table and list the attachments at the bottom. Every time I tried to do anything other than text from the control it would break everything. Eventually I ended up using power automate which is so redundant for something like this. And makes sending multiple attachments a headache I still haven't figured out.
I wanted my users to just toggle control whether they wanted to send an email when they submit their form and then boom it opens a draft when they submit their data, in an HTML table and shows the attachments at the bottom.
Another issue I always get criticism about is users not able to paste an image or multiple images, and that causes them to lose their form data by having to go take the image or screenshot, and start all over so now I gotta add a save component to my form just because power apps doesn't have a feature to let users pick up where they left off
Yeah, not surprised that MailTo scenario doesn't work, it isn't the most robust of abilities in my experience.
Sorry it is causing you issues.
Cool solution! Can an outlook event be created and sent from a shared mailbox?
From a regular mailbox is easy th-cam.com/video/MeQDIBrJjRg/w-d-xo.html
From a shared? I have never tried but I think the only chance is if you can do it via the Graph API. There is no built in action for it as far as I know.
You state that the email is sent on behalf of the user who pressed the button in the form. I don't think this is correct. The sender is the user who was specified when setting up the Office365 connector.
I could also imagine that this depends on which settings have been made for user consent in the tenant. Perhaps you also have some insights into this?
When you setup Power Apps to use the Outlook connector the email will always come from the person who pressed the button, not the maker of the app. This is why when you use the app the first time you ahve to consent to using your authentication.
Can you help me? not work.. error 400, message: Paratamert, Attachment Content, cannot be null or empty.
Do you not have an attachment? You might need to add logic If(attachment is empty, don't try to send it) kind of thing
Thanks Shane 🙏🙏🙏
Happy to help!
So it's still not possible to send email as other account as the sender (other than using Power Automate)
There is a From: optional parameter but, to use it, you have to have permissions to send as that user. About the 12:05 mark I talk through it a little bit.
@@ShanesCows Yes, Shane. I tried that as well. But what I want to achieve is to allow my PowerApps users to send emails on behalf of a particular email account. The catch is I cannot give permission to all of my users to do that. I know how to achieve that in Power Automate though. Thanks for the video, Shane
@@HPTeguh Glad to help. I will say for one of our internal processes we do the same and we used the SMTP connector. Just another random thought if it helps th-cam.com/video/l8NJkauGJ7U/w-d-xo.html
Thanks!
Thanks for the support Colin. 👍
how do you send an email report of the submission to the user who submitted it?
User().Email is the formula to get the logged in users email. If you want the email to automatically go when someone submits a form, you can put the code in the OnSubmit property of the Form control.
🖱 ⌨ 🖥 😁 👍 ⚡ 👌🖥
Thanks
@@ShanesCows Thank you and you are welcome