Hello Shane. I had a trouble regarding this Flow. Apparently sending email from different user does not work anymore. The username appears as 'Sharepoint Online' even though I already specified the email (Yes, the email exist within my company), although the email appears as I stated if I wanted to reply the message. Do you have any idea why/how the settings changed? Is it because of a new update from Microsoft? What about yours is it still running correctly with the username correctly appear as the one you stated on the "From" properties? Thank you if you can help
Wow! I never thought this would be possible to send emails on be half of others!! Is the URi different for different SharePoint sites or I can use the one you put in there?
Thanks for sharing this video with me based on my comment on the other video. However, it doesn't work for the normal Power App connector that doesn't pull inputs (relies on the Get Items to filter inputs to the right distribution list as part of a solution). With that connector, none of the email parameters are available so a join/compose/select is used to create the To/CC and the subject is plain text allowing for use. The rich text body is the problem. It is interesting that it will work at all with the Power App (V2). You would think it would have the same JSON issue of just adding a SharePoint field directly. Do you know if you need to format a rich text SharePoint field added to the request in a certain way? I might be able to use the Power App (V2) connector the way you have it for another portion of the build so thanks for sharing that. I haven't used that connector much yet.
The only emailing people associated is very annoying, we were late to getting o365 functional accounts and the work around still in place was to grant a pointless permission via power automate then wait a few minutes and trigger the sharepoint mail... Definitely a feature that makes me miss the on prem! Thank you though this is a great tutorial!
For the 'To' part of the code (16:28 min) for the flow, will the flow fail if only one address is chosen from the combo box? (because of the comma that the concat inserts) - if i'm wrong and your code works for single choices, great, otherwise, would one create an 'if' statement as a way forward? GREAT video instruction as always, Shane, thank you.
Amazing and very useful video. Thank you! One question, and sorry if I missed this in the video but is there a way to send to an ad group in the org instead of just one person?
You helped me a lot. Thanks! I have one issue and have tried everything but the CC ad BCC are both not working for me. I checked my code a 1000 times, but have still no idea. Can you please help ?
@@ShanesCows thank you Shane for your answer. I already got the data gateway, I can connect to a list of sharepoint on premise, but I don’t know how to send emails with API REST with sharepoint on premise. I will appreciate any comment about it
@@ShanesCows thank you Shane for your answer. I already got the data gateway, I can connect to a list of sharepoint on premise, but I don’t know how to send emails with API REST with sharepoint on premise. I will appreciate any comment about it
This is great stuff. My organization has a sharepoint group that encompasses everyone. If i gave permission in sharepoint to this all inclusive group would this method still work?
Can you set the priority with this send method? I have tried looking it up, but I don't have enough understanding the syntax to interoperate this for power automate.
Such an useful video. Thank you so much Shane! Just a Q. Can I use List of recipients from my PowerApp Gallery which has a selected names - People picker (dynamic list pf People Picker) for each time the an email needs to be sent from PowerApps using the Power Automate. If you have covered that aspect in another video, where can I find it? Thanks again.
5:20..its exactly what i have discovered just today. I fetched a JSON ( with share/mail function ) i just integrated into a column in my list with a pretty cool icon. I tried to email someone outside the sharepoint user list for testing. The person received my mail BUT he couldn't see the data ( because he wasn't allowed in my sharepoint site ) when i could see all data inside ( when i email to myself ).
One of the reason why - I as an admin - would love to block the SharePoint api request action. But SharePoint cannot be blocked so no actions can be blocked. The good thing: you can see in the email header the flow ID and than you can find out who has triggered the flow.
Following the steps outlined in your video, I am receiving 2 emails each time the flow runs. 1 email is from Microsoft Power Apps and Power Automate which includes an Unsubscribe option and a message that the sender is outside of my organization, and the other email is the intended email (result you achieved in the video). Is there a way to not send the Microsoft Power Apps and Power Automate email?
Hello Shane. I had a trouble regarding this Flow. Apparently sending email from different user does not work anymore. The username appears as 'Sharepoint Online' even though I already specified the email (Yes, the email exist within my company), although the email appears as I stated if I wanted to reply the message.
Do you have any idea why/how the settings changed? Is it because of a new update from Microsoft? What about yours is it still running correctly with the username correctly appear as the one you stated on the "From" properties? Thank you if you can help
We are also experiencing the same issue in our environment that started a couple weeks ago. It was all working for months then suddenly stopped.
Can't wait to give it a go, Thanks! Would love to see any insight you have on connecting IP cameras to build a PA CCTV hub.
Interesting Tim. I haven't done that one before. If you send me an IP camera I can figure out though. 😉
Wow! I never thought this would be possible to send emails on be half of others!!
Is the URi different for different SharePoint sites or I can use the one you put in there?
The API portion is the same for all SharePoint sites. 😀
@@ShanesCows Great! Thank you for helping me to be a Power apps developer:)
Thanks for sharing this video with me based on my comment on the other video. However, it doesn't work for the normal Power App connector that doesn't pull inputs (relies on the Get Items to filter inputs to the right distribution list as part of a solution). With that connector, none of the email parameters are available so a join/compose/select is used to create the To/CC and the subject is plain text allowing for use. The rich text body is the problem. It is interesting that it will work at all with the Power App (V2). You would think it would have the same JSON issue of just adding a SharePoint field directly. Do you know if you need to format a rich text SharePoint field added to the request in a certain way? I might be able to use the Power App (V2) connector the way you have it for another portion of the build so thanks for sharing that. I haven't used that connector much yet.
The only emailing people associated is very annoying, we were late to getting o365 functional accounts and the work around still in place was to grant a pointless permission via power automate then wait a few minutes and trigger the sharepoint mail... Definitely a feature that makes me miss the on prem!
Thank you though this is a great tutorial!
Thank you. I have one question: if I want to add an attachment, what should I do?
With this method you cannot. If you want to send attachments maybe use the Outlook connector? th-cam.com/video/gyrU7XljKOw/w-d-xo.html
For the 'To' part of the code (16:28 min) for the flow, will the flow fail if only one address is chosen from the combo box? (because of the comma that the concat inserts) - if i'm wrong and your code works for single choices, great, otherwise, would one create an 'if' statement as a way forward? GREAT video instruction as always, Shane, thank you.
Amazing and very useful video. Thank you! One question, and sorry if I missed this in the video but is there a way to send to an ad group in the org instead of just one person?
If the group has an email address then you can send to that address. Any valid emails will work.
You helped me a lot. Thanks! I have one issue and have tried everything but the CC ad BCC are both not working for me. I checked my code a 1000 times, but have still no idea. Can you please help ?
You can leave a new commment with your formula and I can try to help.
This is really great. thanks for sharing Shane Young
Happy to help :)
Hi thanks... but how to add an attachment file with this HTTP request ?
Thank you .
I am sure it is possible but haven't done that one. Sorry.
Hello! Did you find how to send attachments ?
great video.... but, what to do in sharepoint on premise?
With SharePoint on-prem there is a gateway. The video is super old but should give you the concept. th-cam.com/video/uqx_h4Ym8ng/w-d-xo.html
@@ShanesCows thank you Shane for your answer. I already got the data gateway, I can connect to a list of sharepoint on premise, but I don’t know how to send emails with API REST with sharepoint on premise. I will appreciate any comment about it
@@ShanesCows thank you Shane for your answer. I already got the data gateway, I can connect to a list of sharepoint on premise, but I don’t know how to send emails with API REST with sharepoint on premise. I will appreciate any comment about it
This is great stuff. My organization has a sharepoint group that encompasses everyone. If i gave permission in sharepoint to this all inclusive group would this method still work?
Can you set the priority with this send method? I have tried looking it up, but I don't have enough understanding the syntax to interoperate this for power automate.
Not that I know of Tim.
Such an useful video. Thank you so much Shane! Just a Q. Can I use List of recipients from my PowerApp Gallery which has a selected names - People picker (dynamic list pf People Picker) for each time the an email needs to be sent from PowerApps using the Power Automate. If you have covered that aspect in another video, where can I find it? Thanks again.
How to add an extra line in the body? I need to send a couple of lines in body.
How can we format the email body to add line returns,.bold, etc.?
The easiest way is to use HTML in the body. So is a line break This is bold is what I would do.
Awesome, as always!!
Thank you! Cheers!
Thanks for another great video. New knowledge gained 😇
So glad!
Oluwatobi is from Nigeria
Is there a way to change the from to show a custom text? On prem I believe there was a way
Not that I know of but I haven't looked. 😬
5:20..its exactly what i have discovered just today. I fetched a JSON ( with share/mail function ) i just integrated into a column in my list with a pretty cool icon. I tried to email someone outside the sharepoint user list for testing. The person received my mail BUT he couldn't see the data ( because he wasn't allowed in my sharepoint site ) when i could see all data inside ( when i email to myself ).
One of the reason why - I as an admin - would love to block the SharePoint api request action. But SharePoint cannot be blocked so no actions can be blocked.
The good thing: you can see in the email header the flow ID and than you can find out who has triggered the flow.
I had never thought about SharePoint being completely unblockable. Interesting note. 🤔
Following the steps outlined in your video, I am receiving 2 emails each time the flow runs. 1 email is from Microsoft Power Apps and Power Automate which includes an Unsubscribe option and a message that the sender is outside of my organization, and the other email is the intended email (result you achieved in the video). Is there a way to not send the Microsoft Power Apps and Power Automate email?
Super useful! Thanks for sharing Shane!
You bet! Always crazy the different ways we can solve the same issue. 😀
From email is showing sharepoint online. Please help how to set it as username
That is the only option with this technique. Maybe use Outlook instead? th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
@@ShanesCows thank you Shane
Meaning that if the SharePoint site permission is public then we can send the email to anyone in Organization?
I *think* the user would have had to opened the SharePoint site once.
@@ShanesCows Do you know how long after a user has opened the Sharepoint site will power apps pick up the user in the "user table" ?.
Thank you Shane.
Happy to help. Have a great day. 🐶
This is amazing! Thanks for sharing
Glad you enjoyed it!
Super useful to send email "as my boss"
Don't get in trouble. 😂
Too bad that it doesn't send to shared mailboxes
I dig it
Thanks! 🐶