Hey, thanks it helped. Got a question.. Is it possible to add a condition to send emails only if the item added is ice cream in one of the column. My situation is: I have list with 20 columns and I want to receive an email only when one of the columns in the list has "Yes" in it and not for all of the items added in the list. The column I am talking about has a validation with Yes, No, NA
Hi Micheal, been watching you for awhile and thanks for your effort to help us newbie :) I have a question regarding automate flow, im using automated flow, create item sharepoint, update item sharepoint then send email v2. but i having an issue, iwant that my user that makes the item they are the ones that should sent the email notification, now is that my email is the one that sending the notification. can you help me with this? more videos to come Thanks
Hi, this logic works for me , but i am receiving too many mails , from different users, what is the issue, i shared my flow- as " send a copy" eithers thats the issue
Hi Michael Alex... really great tutorial. Learned a lot. Thanks. How do you go about sending the email and at the same time redirects the user to another SharePoint page?
Hi Michael! Thanks this is really helpful. Do you think it would be possible for me to send out email campaigns through power automate and Microsoft list? Let's say I have a list of people and with a column dedicated to their email.
Hello, Thank you for this, do you have an idea if this would work for a shared mailbox? Im thinking to use this in a case where I have several shared mailboxes or alternatively use one mailbox but with different alias addresses mapped to same account.
i need to see if when the same item is modified power flow should send another email that item is changed or updated, how i should add a second email and a condition, kindly make a video ...thanks in advance
Nice walk-through. In a case where you would also like to include an item from another list leveraging the List ID (One to Many relationships), How do you go about this?
Suppose i wanted to have a space in my sharepoint form where I manually type in an email. I want to have a flow automatically send to the email that is one of the list item entries(let's say it's in the first, Title, slot, with a summary of the rest of the item information to that email. For some reason. When I make this, it will send to a gmail, pulling from the email that is entered into the sharepoint list, but when I use my outlook email, it won't send the email. Any help?
DO you know if its possible to create a flow that uses a certain list column "yes/no" value to send an email and to only send 1 time if I have multiple "yes/no" values in the column? :) have been workign on it for a while and tried with chatgpt as well but no luck so far D:
Nice video, Is it possible to automate an email that pulls from a list or calendar based on week by chance. example - If you want to automatean email every monday to show upcoming sales or events for the week?
I think it's possible. You would need a weekly scheduled Flow to run on Monday's. Then, need to store the upcoming dates in variables or an array in Power Automate. If the SharePoint item date is included in one of those dates, toss the information you want an HTML table. After, send an email using that HTML table. It's more advanced Power Automate.
Hi Michael, thanks for the awesome. I wanted a flow where email is sent as soon as a list item is created but the email should go from the person who entered the list item can that be possible. I see there is an option to select creators email ID. but when I run the flow it gives error that the sensor does not have access.
No, unfortunately that can't be done. It will use whoever connection is on the "Send an Email" action. You can't send emails on other users behalf as far as I know.
@@michaelalex2322 Hey thanks I got another workaround by using send email wherein the from email ID is generic Microsoft powerautomate which will do thanks for the reply Michael.
Hi! How can I create a flow for when a new list item is created that falls a specific category, email the person associated with that category? I feel like this video was a good starting point but I may need a few extra steps.
Contain the matching category and person in a separate list. When a new item is created, lookup that category and matching person. Likely make a video on it because it happens a lot.
My price value is pulling in a number with 10 decimal places. The sharePoint online field is a calculated currency. I don’t know how to get it to show as a currency in the power automate email?
In the Calculated Field in the List settings, there should be a 'Number of decimal places:' field where you can limit the decimal places. Also, you can add your currency icon and then the dynamic content of the calculated field in the email.
How would you send email to certain people depending on what's been added. i.e. Bill only when you purchase Ice cream, Mary when you purchase turkey, etc?
Hey Alex, can an email (with the body of the content) be sent to someone without permissions to the list?) I know in previous versions of sharepoint this was able to be done. Hope that makes sense. Im trying to troubleshoot something at the moment
Alex, great stuff. Could you create a video on how to use Power Automate to send multiple emails based on conditions gathered from forms?
Very helpful! Thanks for sharing this.
You bet!
Thank you for sharing. Really helpful video.
Glad it was helpful!
Alex, could you please create video on how to send an email on New Sharepoint list item with attachements.
Hey, thanks it helped. Got a question.. Is it possible to add a condition to send emails only if the item added is ice cream in one of the column.
My situation is:
I have list with 20 columns and I want to receive an email only when one of the columns in the list has "Yes" in it and not for all of the items added in the list. The column I am talking about has a validation with Yes, No, NA
Hi Micheal, been watching you for awhile and thanks for your effort to help us newbie :) I have a question regarding automate flow, im using automated flow, create item sharepoint, update item sharepoint then send email v2. but i having an issue, iwant that my user that makes the item they are the ones that should sent the email notification, now is that my email is the one that sending the notification. can you help me with this? more videos to come Thanks
Hi, this logic works for me , but i am receiving too many mails , from different users, what is the issue, i shared my flow- as " send a copy" eithers thats the issue
Hi Michael Alex... really great tutorial. Learned a lot. Thanks. How do you go about sending the email and at the same time redirects the user to another SharePoint page?
Hi Michael! Thanks this is really helpful. Do you think it would be possible for me to send out email campaigns through power automate and Microsoft list? Let's say I have a list of people and with a column dedicated to their email.
Hello, Thank you for this, do you have an idea if this would work for a shared mailbox? Im thinking to use this in a case where I have several shared mailboxes or alternatively use one mailbox but with different alias addresses mapped to same account.
i need to see if when the same item is modified power flow should send another email that item is changed or updated, how i should add a second email and a condition, kindly make a video ...thanks in advance
Nice walk-through. In a case where you would also like to include an item from another list leveraging the List ID (One to Many relationships), How do you go about this?
You would use the 'Get items' action and Filter it using the List ID
Please create video if someone will raise sharepoint access request via email so it will auto approve on some time
Suppose i wanted to have a space in my sharepoint form where I manually type in an email. I want to have a flow automatically send to the email that is one of the list item entries(let's say it's in the first, Title, slot, with a summary of the rest of the item information to that email. For some reason. When I make this, it will send to a gmail, pulling from the email that is entered into the sharepoint list, but when I use my outlook email, it won't send the email. Any help?
Thanks so much for this!
You're so welcome!
DO you know if its possible to create a flow that uses a certain list column "yes/no" value to send an email and to only send 1 time if I have multiple "yes/no" values in the column? :) have been workign on it for a while and tried with chatgpt as well but no luck so far D:
Nice video, Is it possible to automate an email that pulls from a list or calendar based on week by chance. example - If you want to automatean email every monday to show upcoming sales or events for the week?
I think it's possible. You would need a weekly scheduled Flow to run on Monday's. Then, need to store the upcoming dates in variables or an array in Power Automate. If the SharePoint item date is included in one of those dates, toss the information you want an HTML table. After, send an email using that HTML table. It's more advanced Power Automate.
how do you avoid the string coding appearing in the emails?
Hi Michael, thanks for the awesome. I wanted a flow where email is sent as soon as a list item is created but the email should go from the person who entered the list item can that be possible. I see there is an option to select creators email ID. but when I run the flow it gives error that the sensor does not have access.
No, unfortunately that can't be done. It will use whoever connection is on the "Send an Email" action. You can't send emails on other users behalf as far as I know.
@@michaelalex2322 Hey thanks I got another workaround by using send email wherein the from email ID is generic Microsoft powerautomate which will do thanks for the reply Michael.
Is it possible to do this for a single item within a sharepoint
In this video only 1 titile is there so you are taking 1 title, for me I have multiple tile with filter option how can I bring those
I think have to create html table. But I was stuck on the filter query to get the recent item instead of the whole list of past items added
Hi! How can I create a flow for when a new list item is created that falls a specific category, email the person associated with that category? I feel like this video was a good starting point but I may need a few extra steps.
did you get one i need this ans
Contain the matching category and person in a separate list. When a new item is created, lookup that category and matching person. Likely make a video on it because it happens a lot.
@@michaelalex2322 plz make a video and ping me i need to seenit
how do you send an email of a copy of the submission to the user who submitted it? they are all in Outlook
--- @jenniferbabicz6954 let me know if you get an answer, because I have the same request --- 24JUL24
My price value is pulling in a number with 10 decimal places. The sharePoint online field is a calculated currency. I don’t know how to get it to show as a currency in the power automate email?
In the Calculated Field in the List settings, there should be a 'Number of decimal places:' field where you can limit the decimal places. Also, you can add your currency icon and then the dynamic content of the calculated field in the email.
@@michaelalex2322 thank you so much! I did the first part, let me try the second.
How would you send email to certain people depending on what's been added. i.e. Bill only when you purchase Ice cream, Mary when you purchase turkey, etc?
You would have to use the Switch action. Maybe I'll make a video on this because I haven't yet.
@@michaelalex2322 I have the exact question posed above - this would be massively helpful! 🙂
Hi, what if the "list name" is empty after choosing the "site address"?
Are you sure the list is in that SharePoint site?
Hey Alex, can an email (with the body of the content) be sent to someone without permissions to the list?) I know in previous versions of sharepoint this was able to be done. Hope that makes sense. Im trying to troubleshoot something at the moment
I would think the dynamic content could be included in the email body
How to create a flow in power automate, the email will automatically sent to the person once item created in SharePoint