How would you use this logic in other flows? Let me know down below!👇👇👇 Also, the line break at 17:49 isn't necessary. Outlook actually ignores it anyway 🫠. If you want to insert a line break-use a tag instead! If your SharePoint list has multiple assigned to users, check out this YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate: ruclips.net/video/0D2YcmdOuL8/видео.html
I have a scenario here where three engineers and designers have told me it would be too complex to use SP list and manage by the powerautomate flow. However I am convinced especially after watching your video! What I’d like is to combine multiple items on the SP list and send to different assigned email recipients. Each item can be assigned to up to 6 recipients. And I want to send a consolidated list of multiple items to individual recipient who are listed for those items. Will this flow work in that scenario?
I discovered a flaw in this video and hope you could improve it, as well as clarify that this video only applies to SharePoint List columns that contain a single email for each item. There will be a problem at 7.33min "Select" action the way you are doing it. Map Email with item[]?['AssignedTo]['0'].['Email']. If the people columns contain more than two emails within the same items and ID, only the first one will be selected, and the remaining emails will be missed. Anyway, I really appreciate your video. You have been extremely helpful to me! Thank you for being present!
This has been a very in depth tutorial for this type of automation and it's been exactly what I was looking for. The suggestion of getting the outputs have been really useful as well.
This was perfect. I had a list of items I needed to notify owners needed to be addressed. My trigger is biweekly, and I just filtered the get items with the item date field, so it only gets items that are 180 days older than today. Then I followed the rest of your steps, and it worked like a charm. You made my week with this demo. Thank you!
THANK YOU!!!! This was super helpful. You've set your videos up in a way that makes them very clear and easy to follow. Even the little dropdown that shows when you say what code we should type in. In addition, just you saying "question mark, square bracket snd single quotes" out loud helped me to remember it. Your voice is perfect and the additions at the end were very helpful. Thanks for sharing!
This video along with many of your other videos has been very helpful! I am 100% new to Power Automate and no nothing about code. I have used Chat GPT to help flow ideas but the execution is difficult. Your examples, cadence, and pace are excellent and have improved from your earlier videos. You are Da Boom! I would love to see more videos on summing, averaging, or anything with math through List or approval responses. Anyways, you are freaking awesome "A Creative Opinion" and have made learning Power Automate easier 🙂
Thank you thank you thank you thank you! I've been working on my flow for 3 weeks and couldn't get it to work. thanks to your video I was able to identify the issue with my date formatting and solve it. THANK YOU!
Nice tutorial. Just a problem that I'm facing now, how to achieve this with SharePoint list with people column that allows multiple values? Thanks a lot.
Thanks for this video. This is exactly what I want to build. However my list has multiple users in the "assigned to" column how would I set this up to send one email to each user that lists the tasks assigned to that user?
Thanks for watching! Check out my latest YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate: ruclips.net/video/0D2YcmdOuL8/видео.html
It would be awesome if you created a small video that covers the nuances of inline HTML/CSS styling with some good to knows. Love your style of videos and know you'd knock it out of the park!
What would be the best way to tackle providing email recipients an option to unsubscribe from an automated email message? My current plan is to have a list of subscribed users and then have a column with a button to remove or add themselves to the list. I'd like them to be able to do that directly from the email. Love the content. High quality, no nonsense. Keep it coming! Appreciate any help you can provide.
Thanks for watching! To clarify-you say that your current plan is to have users remove or add themselves to a list, would that be a SharePoint list? How do you plan to manage permissions on that? If you'd like them to directly add themselves to a list you'd need allow users to create new items in a SP list (which I wouldn't recommend). Allowing users to unsubscribe directly from an email isn't really possible (in a sense that it won't be a button they can click in an email to remove themselves). Instead, your button would need to link to a form which you can then use to collect the information of the user who wants to be unsubscribed. This process can be automated-but the user would be required to submit a form to trigger the removal. Hope this helps!
This is so very helpful. Thank you! I would like to take this idea one step further but I don't know how to achieve it. What I'd would like to do is include data from another sharepoint list that is connected to the first sharepoint list via a lookup column. For example, the second list is sub tasks associated to the "parent" task list, and in the email to list each task in a row and the sub tasks directly below each unique task. What are your thoughts?
Thank you for this, it has helped us out a lot. Is there a way to set the flow to branch off with an email that sends the user a message that all there task are complete?
Use a Filter Array action to filter out items that you'd like to email. For more details on how to use the Filter Array action-check out this YT Tutorial: ruclips.net/video/HVAf1aTEQNg/видео.html
Great video! It is helping me work out an longstanding need in my team. I have one problem, my get items property does not seem to be returning my people column email addresses. It only shows the created by and modified by email as dynamic content. Any ideas why? I am at the step of the first condition to count open items and in the select map section i do not get the dynamic content email for my AssignedTo column (Mine is called Responsible). I'm stuck and am so looking forward to using this flow. Help is appreciated.
same here!, in order to get AssignedTo Display Name and Email properties, it is necessary to have an apply to each loop i guess but i do not know how to handle the rest of the steps, if anyone helps, it'd be appreciated a lot! :)
Thanks for this helpful video! I would love to see another one that covers the scenario where you want to send a SINGLE email to ALL unique users, rather than one email to each user. I have tried to edit the flow described in this video, but it keeps sending multiple emails 😅
Thanks for watching! You can reference this YT Tutorial: How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate - ruclips.net/video/0D2YcmdOuL8/видео.html Hope that helps!
Hi thank you for this video 😊 What changes do I need to make to send one email to a team. And in the email to list the Task Owner's name one time with all the details listed below? If you have a video that explains please share. Again thank you!
Ah wow this is soooo amazing and easy to follow with your clear explanation, I am going to change quite a few of the flows using your method for 7 day reminders of documents due for review and audit actions. How would I set this to run for any dates that are overdue e.g. older than Today(), so I can send a monthly reminder to owners for any actions that are Open and overdue?
Thanks for watching! You'll just need to change the conditions of your Filter Query to check for items that are older than today's date. You can use the utcNow() function for that. Hope this helps! Take a look at this YT Tutorial for additional help when building your flow: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows - ruclips.net/video/8i7-IEKJhzU/видео.html.
Hi! Excellent video! I'm having trouble creating the Select User action, next the Condition. When I select the "Assign To DisplayName" the program add a For Each loop automatically. This loop results in multiple emails to the task responsible. How can I add the parameters without the loop? This doesn't happens when use other Dynamic Content like Created By DisplayName.
Thanks for watching! Is your Assign To column a multi-choice person column? If so, you'll want to check out my latest YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate: ruclips.net/video/0D2YcmdOuL8/видео.html You'll need to build the flow a little differently when you have more than one user assigned to an item.
Thanks @acreativeopinion very helpful the video, question, in the Create HTML table, how can I handle multiple-choice field column, to show only the value? thanks 👋
Thank you for this demo! This works great when the multiple-choice selection in SharePoint is turned off. How can I do this exact thing when there are multiple users in the "Assigned To" column? I would greatly appreciate your help!
Thanks for watching! I recently uploaded a new YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate: ruclips.net/video/0D2YcmdOuL8/видео.html Hope this helps!
Have Followed step by step the video and watching it multiple times, Thank you very much for sharing! However, I am not sure why user get multiple emails for each task. My impression was that in one email there will be listed all the tasks assigned to the individual. Any clarification/help is highly appreciated. Thank you again!
Thanks for watching! You will need to check the logic of your flow and ensure your actions are in the correct spot. The video tutorial covers how to pull the list of users at 6:56. At 7:56 I cover how to create a unique list of users. Ensure you are testing after adding a new action before you try to build out the entire flow. The Apply to Each action will then loop through each unique user. Hope this helps!
Thank you for the heads up! Still not working, I think because I have used a SP Document Library for this project. That's the only feasible explanation. Have tried to look at it again and everything seams okay. @@acreativeopinion
Hello, thank you for much for this video. At 5.05 when entering Filter Query field under Get Items, what if it needs to be not equal to 2 different choices, i.e. needs to not be equal to 'Approve' or 'Reject'. Would I enter "[column name] ne 'Approve' and 'Reject'" Many thanks
or would I keep this flow for any items that are not on 'Approve' stage and I would need to create a separate parallel flow that works for any items that are not on 'Reject' stage either
Thank you for your video. There is one problem with the get item filter query where the item is null it will also pick up that to send the email which is wrong.
This is an absolutely wonderful video! Thanks so much for the use case. I did notice that there are some definite bugs when replicating your flow with the New Designer 😵(it took me a while to figure THAT out)
Thanks for watching. You can refer to this section of my the Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate Tutorial: ruclips.net/video/d99dwBeTFvo/видео.htmlsi=h1HosSR8a5SdsxAl&t=719 Hope this helps!
Thanks for watching! You might be interested in my most recent YT Tutorial: 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️- ruclips.net/video/QeBL32w2ClM/видео.html
Hello. This tutorial has been extremely helpful. I am running into a snag though. Part of the result I want in my table for the email is a multiple line text field. When the flow runs the result has a bunch of HTML code in the table due to the multiple line text field. I understand that I can add the HTML to text action but am having trouble with where to place it in this flow. Can you please help or point me in the right direction? Thank you so much!
Great demo! If the records to be sent in a single email to the user include different URLs, how to extract the hyperlink display text from each URL and include them in the HTML table?
Thanks for watching. I would recommend posting in the Power Automate community: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity The comment section in YT doesn't allow for screenshots which makes it hard to provide any additional support.
Hello, I found a way you can do it. So in the select step, where you map the fields: You can use: item()?['Title'] So the link is the link to the item. The "item()?['Title']" part is for the name of the link, in my case the title of the item in SharePoint. I hope this will work for you! Regards, Jorne
Amazing video!!! But can I ask a silly question? I tried to cc the user's manager in the email (I tried to add a "get manager", but in the dynamic content, it doesn't show, can you please advise? Thank you!
Thanks for watching! It's a little challenging to troubleshoot a flow without seeing the details-I would recommend posting in the Microsoft Power Automate Community: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
This has been helpful. However, I am running into the issue where my sharepoint field is returning as UTC. If I add a convert the sharepoint time to MM-dd-YYYY format I cant seem to set it up any advice?
Thanks for watching! Use the Convert Time Zone action. If you want to use the converted time in SharePoint you need to use the following format: yyyy-MM-DD. For more tips and tricks on how to work with dates in Power Automate-check out this YT Tutorial: ruclips.net/video/ODobGcpgGlk/видео.html
I have followed this and it works great when I do a test but the flow will not show up when I want to manually trigger it. What am I missing? Thank you!
This tutorial is awesome! Im getting stuck when try to format the html using the string variable. Every time I test, its been failing with the error Action 'Compose_-_User_Item_Details' failed. Not sure where i messed up here. Please help!
Thanks for watching! It's hard to say without actually seeing your flow. You can check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows - ruclips.net/video/8i7-IEKJhzU/видео.html If that doesn't help, I would recommend posting in the Microsoft Power Automate Community: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Hi Team, Nice Vedio, I have an requirement like , I have sent Initial mail and after needs to send update on top of it initial mail, how can we achieve this? My source data is Share point excel sheet where I have values like Initial ,Update, Skip, Resolution where ever I changed the status I need to send an email on top of it Initial mail only.
Hi , I've been trying to add files to SharePoint site with " when an email arrives" . The flow is working. The problem I'm facing is that the Excel file which arrives to SharePoint site has to be manually moved editable, which creates another Excel in editable format. This is annoying . Any suggestions? Thanks
@acreativeoponion Very Nice vedio, I have a task like as per SharePoint list I have couple of solutions and I need to send the out 5 , need to send 3 solutions and their names in to initial communications to end users. After Job completed I need to send Update mail on top of initial mail and once all jobs are completed then need to send Resolution on top of Update mail. Please help on this.
I can't create the HTML table, keep on getting an error message about the body/value not existing but that's the only thing I can see to select. What am I doing wrong? Keep on getting an InvalidTemplate error message
Works great however for some reason the filtering function doesn't seem to work for me. It reports I have say 6 overdue items, but it sends an email to everyone in my list with future items saying they're are overdue.
You might have adjust your filter query to ensure it's written correctly. You might find my latest tutorial helpful - How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks: ruclips.net/video/ODobGcpgGlk/видео.html
@acreativeopinion the issue was I was using a document library. I made a work around by having a list which is essentially a copy of the document library minus the attachments. Then it worked perfectly.
It's hard to troubleshoot a flow in the comment section. Anytime something is repeated unintentionally-it's usually the logic of the flow that needs to be adjusted. It sounds like you have your email action nested inside an Apply to Each action. You might be interested in this YT Tutorial: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow - ruclips.net/video/44Bk4JVMrD4/видео.html For additional troubleshooting tips-check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows - ruclips.net/video/8i7-IEKJhzU/видео.html
I am looking to set date range Due in next 30 days , if I add 30 instead of 4 I get odd value (set output to dd-MM-yyyy: input 1-12-2023 output "11-02-2023"!
In my tutorial I've used a couple compose actions to return a dynamic date range. At 3:11 of the tutorial I've used a Compose action to store today's date. At 3:29 of the tutorial I've used an expression to compose the date 4 days from today's date. If you use the same expression and replace the 4 with a 30 it will give you the date 30 days from today. Hope this helps!
@@acreativeopinion Fixed it I had a different date format from you in my flow! Can you advise how you would manage this is AssignedTo contained mutiple people?
Thank you for the effort I must said your video helped but there are problems at the select action there I suggest to add compose before select action reason because the value from the apply to each were object not item so select action unable to select the object from dynamic value. I've added a compose action before select to manipulate the object data to item so then select action is able to select the item.
Instead of the Get Items action, you'll need to use the List Rows Present in a Table action. However, keep in mind that the Filter Query field in the List Rows Present in a Table action can only accept a single condition. If you need to filter your Excel table with more than one condition. You'll need to use a Filter Array action. Check out this YT Tutorial for more info on how to use the Filter Array action: ruclips.net/video/HVAf1aTEQNg/видео.html
too many unnecessary steps, this guide was exhaustive but doesn't cater to the general structure if you want to create something like this. i was able to create a similar flow using way less steps to execute the same result
When using create table, you said that for the values, we use item()?['item name'] where 'item name' is the red text on the filter array output. But many of my fields have the red text and then several other red texts such as "@odata.type", "Id" or "Value". I need to get the value, what should I do?
Hi Team, Nice Vedio, I have an requirement like , I have sent Initial mail and after needs to send update on top of it initial mail, how can we achieve this? My source data is Share point excel sheet where I have values like Initial ,Update, Skip, Resolution where ever I changed the status I need to send an email on top of it Initial mail only.
How would you use this logic in other flows? Let me know down below!👇👇👇
Also, the line break at 17:49 isn't necessary. Outlook actually ignores it anyway 🫠. If you want to insert a line break-use a tag instead!
If your SharePoint list has multiple assigned to users, check out this YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate:
ruclips.net/video/0D2YcmdOuL8/видео.html
I have a scenario here where three engineers and designers have told me it would be too complex to use SP list and manage by the powerautomate flow. However I am convinced especially after watching your video!
What I’d like is to combine multiple items on the SP list and send to different assigned email recipients.
Each item can be assigned to up to 6 recipients. And I want to send a consolidated list of multiple items to individual recipient who are listed for those items. Will this flow work in that scenario?
I discovered a flaw in this video and hope you could improve it, as well as clarify that this video only applies to SharePoint List columns that contain a single email for each item. There will be a problem at 7.33min "Select" action the way you are doing it. Map Email with item[]?['AssignedTo]['0'].['Email']. If the people columns contain more than two emails within the same items and ID, only the first one will be selected, and the remaining emails will be missed. Anyway, I really appreciate your video. You have been extremely helpful to me! Thank you for being present!
This has been a very in depth tutorial for this type of automation and it's been exactly what I was looking for.
The suggestion of getting the outputs have been really useful as well.
Thank you for watching. I'm glad you found it helpful.
This was perfect. I had a list of items I needed to notify owners needed to be addressed. My trigger is biweekly, and I just filtered the get items with the item date field, so it only gets items that are 180 days older than today. Then I followed the rest of your steps, and it worked like a charm. You made my week with this demo. Thank you!
Thanks for watching and I'm glad I made your week! ☺️
Can't tell you how much I love this. I love how you've detailed the process. Sooooo goooood!
Thank you for watching and for the feedback.
This is what I was exactly looking for. Thank you so much for uploading. It's really helpful. 👍
THANK YOU!!!! This was super helpful. You've set your videos up in a way that makes them very clear and easy to follow.
Even the little dropdown that shows when you say what code we should type in.
In addition, just you saying "question mark, square bracket snd single quotes" out loud helped me to remember it.
Your voice is perfect and the additions at the end were very helpful.
Thanks for sharing!
Thanks for watching! Appreciate the feedback as well.
Thanks a lot for the excellent video, truly appreciated. I was struggling with this requirement for some time
Great demo !!
You are an exceptionally good teacher
Thank you for your kind words. 🥰
This video along with many of your other videos has been very helpful! I am 100% new to Power Automate and no nothing about code. I have used Chat GPT to help flow ideas but the execution is difficult. Your examples, cadence, and pace are excellent and have improved from your earlier videos. You are Da Boom! I would love to see more videos on summing, averaging, or anything with math through List or approval responses. Anyways, you are freaking awesome "A Creative Opinion" and have made learning Power Automate easier 🙂
Awesome explanation - dont have a use case for this yet, but there will be some def. :) Thanks a lot.
Thanks for watching!
Thank you thank you thank you thank you! I've been working on my flow for 3 weeks and couldn't get it to work. thanks to your video I was able to identify the issue with my date formatting and solve it. THANK YOU!
Thanks so much for watching! Glad it was helpful.
Your Video is so straight forward, I learn a lot, Thank you
Thanks for watching!
Nice tutorial. Just a problem that I'm facing now, how to achieve this with SharePoint list with people column that allows multiple values? Thanks a lot.
Thanks for this video. This is exactly what I want to build. However my list has multiple users in the "assigned to" column how would I set this up to send one email to each user that lists the tasks assigned to that user?
Thanks for watching! Check out my latest YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate:
ruclips.net/video/0D2YcmdOuL8/видео.html
It would be awesome if you created a small video that covers the nuances of inline HTML/CSS styling with some good to knows. Love your style of videos and know you'd knock it out of the park!
This is AWESOME! Thanks. Can we have a link for each item in the email?
What would be the best way to tackle providing email recipients an option to unsubscribe from an automated email message? My current plan is to have a list of subscribed users and then have a column with a button to remove or add themselves to the list. I'd like them to be able to do that directly from the email.
Love the content. High quality, no nonsense. Keep it coming! Appreciate any help you can provide.
Thanks for watching!
To clarify-you say that your current plan is to have users remove or add themselves to a list, would that be a SharePoint list? How do you plan to manage permissions on that? If you'd like them to directly add themselves to a list you'd need allow users to create new items in a SP list (which I wouldn't recommend).
Allowing users to unsubscribe directly from an email isn't really possible (in a sense that it won't be a button they can click in an email to remove themselves). Instead, your button would need to link to a form which you can then use to collect the information of the user who wants to be unsubscribed. This process can be automated-but the user would be required to submit a form to trigger the removal.
Hope this helps!
This is a great tutorial, clear explanation.
Can you please make a tutorial on integrating Adobe Sign with SharePoint using Power Automate? Please.
This is so very helpful. Thank you! I would like to take this idea one step further but I don't know how to achieve it. What I'd would like to do is include data from another sharepoint list that is connected to the first sharepoint list via a lookup column. For example, the second list is sub tasks associated to the "parent" task list, and in the email to list each task in a row and the sub tasks directly below each unique task. What are your thoughts?
I created a request in the Power Automate forum with more info of what I'm trying to achieve.
Thank you for this, it has helped us out a lot. Is there a way to set the flow to branch off with an email that sends the user a message that all there task are complete?
Use a Filter Array action to filter out items that you'd like to email. For more details on how to use the Filter Array action-check out this YT Tutorial: ruclips.net/video/HVAf1aTEQNg/видео.html
Great video! It is helping me work out an longstanding need in my team. I have one problem, my get items property does not seem to be returning my people column email addresses. It only shows the created by and modified by email as dynamic content. Any ideas why? I am at the step of the first condition to count open items and in the select map section i do not get the dynamic content email for my AssignedTo column (Mine is called Responsible). I'm stuck and am so looking forward to using this flow. Help is appreciated.
same here!, in order to get AssignedTo Display Name and Email properties, it is necessary to have an apply to each loop i guess but i do not know how to handle the rest of the steps, if anyone helps, it'd be appreciated a lot! :)
Thanks for this helpful video! I would love to see another one that covers the scenario where you want to send a SINGLE email to ALL unique users, rather than one email to each user. I have tried to edit the flow described in this video, but it keeps sending multiple emails 😅
Thanks for watching! You can reference this YT Tutorial: How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate - ruclips.net/video/0D2YcmdOuL8/видео.html
Hope that helps!
Thank you so much!!! this video is so helpful... thanks from Brazil!
Hi thank you for this video 😊 What changes do I need to make to send one email to a team. And in the email to list the Task Owner's name one time with all the details listed below? If you have a video that explains please share. Again thank you!
Ah wow this is soooo amazing and easy to follow with your clear explanation, I am going to change quite a few of the flows using your method for 7 day reminders of documents due for review and audit actions. How would I set this to run for any dates that are overdue e.g. older than Today(), so I can send a monthly reminder to owners for any actions that are Open and overdue?
Thanks for watching! You'll just need to change the conditions of your Filter Query to check for items that are older than today's date. You can use the utcNow() function for that. Hope this helps! Take a look at this YT Tutorial for additional help when building your flow: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows - ruclips.net/video/8i7-IEKJhzU/видео.html.
Very good and rich content. Helped me a lot!! Thank you so much.
Thanks for watching!
That is so awesome, thanks for your work! It helped me a lot
Hi! Excellent video! I'm having trouble creating the Select User action, next the Condition. When I select the "Assign To DisplayName" the program add a For Each loop automatically. This loop results in multiple emails to the task responsible. How can I add the parameters without the loop? This doesn't happens when use other Dynamic Content like Created By DisplayName.
Thanks for watching! Is your Assign To column a multi-choice person column? If so, you'll want to check out my latest YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate:
ruclips.net/video/0D2YcmdOuL8/видео.html
You'll need to build the flow a little differently when you have more than one user assigned to an item.
Thank you so much for posting there. Helped me a lot.
Thank you for the flow! I've inserted hyperlinks in the table but with the new version of Outlook hyperlinks don't work. Any suggestion? Thanks
Thanks @acreativeopinion very helpful the video, question, in the Create HTML table, how can I handle multiple-choice field column, to show only the value? thanks 👋
this is exactly what i needed, thank you very much!!
Thank you for this demo!
This works great when the multiple-choice selection in SharePoint is turned off.
How can I do this exact thing when there are multiple users in the "Assigned To" column?
I would greatly appreciate your help!
Thanks for watching! I recently uploaded a new YT Tutorial 👉How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate:
ruclips.net/video/0D2YcmdOuL8/видео.html
Hope this helps!
Have Followed step by step the video and watching it multiple times, Thank you very much for sharing! However, I am not sure why user get multiple emails for each task. My impression was that in one email there will be listed all the tasks assigned to the individual. Any clarification/help is highly appreciated. Thank you again!
Thanks for watching!
You will need to check the logic of your flow and ensure your actions are in the correct spot. The video tutorial covers how to pull the list of users at 6:56. At 7:56 I cover how to create a unique list of users. Ensure you are testing after adding a new action before you try to build out the entire flow. The Apply to Each action will then loop through each unique user. Hope this helps!
Thank you for the heads up! Still not working, I think because I have used a SP Document Library for this project. That's the only feasible explanation. Have tried to look at it again and everything seams okay. @@acreativeopinion
Have followed your tutorial and it is now working Perfectly! Thank you !! Can't Thank you Enough! @acreativeopinion
Hi thank you for sharing. May i know if it is possible to add in specific attachment in this flow?
Thanks for watching. Yes, you can add attachments in the Send an Email action.
Hello, thank you for much for this video.
At 5.05 when entering Filter Query field under Get Items, what if it needs to be not equal to 2 different choices, i.e. needs to not be equal to 'Approve' or 'Reject'. Would I enter "[column name] ne 'Approve' and 'Reject'"
Many thanks
or would I keep this flow for any items that are not on 'Approve' stage and I would need to create a separate parallel flow that works for any items that are not on 'Reject' stage either
Thank you for your video. There is one problem with the get item filter query where the item is null it will also pick up that to send the email which is wrong.
This is an absolutely wonderful video! Thanks so much for the use case. I did notice that there are some definite bugs when replicating your flow with the New Designer 😵(it took me a while to figure THAT out)
It's a great and we'll organized tutorial
Thank you for this video. How would I add this to a 90 day before reminder email flow?
Thanks for watching. You can refer to this section of my the Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate Tutorial: ruclips.net/video/d99dwBeTFvo/видео.htmlsi=h1HosSR8a5SdsxAl&t=719
Hope this helps!
Excellent thank you for the video, it solved my issue
Thanks for watching! You might be interested in my most recent YT Tutorial: 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️- ruclips.net/video/QeBL32w2ClM/видео.html
Hello. This tutorial has been extremely helpful. I am running into a snag though. Part of the result I want in my table for the email is a multiple line text field. When the flow runs the result has a bunch of HTML code in the table due to the multiple line text field. I understand that I can add the HTML to text action but am having trouble with where to place it in this flow. Can you please help or point me in the right direction? Thank you so much!
Great demo! If the records to be sent in a single email to the user include different URLs, how to extract the hyperlink display text from each URL and include them in the HTML table?
Thanks for watching. I would recommend posting in the Power Automate community: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
The comment section in YT doesn't allow for screenshots which makes it hard to provide any additional support.
Hello,
I found a way you can do it.
So in the select step, where you map the fields:
You can use: item()?['Title']
So the link is the link to the item.
The "item()?['Title']" part is for the name of the link, in my case the title of the item in SharePoint.
I hope this will work for you!
Regards,
Jorne
@@MrJornee i'm having trouble as to where i insert the comand line. Can you clarify pls.
Thank you so much!!!
Amazing video!!! But can I ask a silly question? I tried to cc the user's manager in the email (I tried to add a "get manager", but in the dynamic content, it doesn't show, can you please advise? Thank you!
Thanks for watching! It's a little challenging to troubleshoot a flow without seeing the details-I would recommend posting in the Microsoft Power Automate Community: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
This has been helpful. However, I am running into the issue where my sharepoint field is returning as UTC. If I add a convert the sharepoint time to MM-dd-YYYY format I cant seem to set it up any advice?
Thanks for watching! Use the Convert Time Zone action. If you want to use the converted time in SharePoint you need to use the following format: yyyy-MM-DD.
For more tips and tricks on how to work with dates in Power Automate-check out this YT Tutorial: ruclips.net/video/ODobGcpgGlk/видео.html
Thanks!
Thanks Very much 😊
You're welcome. Thanks for watching!
I have followed this and it works great when I do a test but the flow will not show up when I want to manually trigger it. What am I missing? Thank you!
This tutorial is awesome! Im getting stuck when try to format the html using the string variable. Every time I test, its been failing with the error Action 'Compose_-_User_Item_Details' failed. Not sure where i messed up here. Please help!
Thanks for watching! It's hard to say without actually seeing your flow. You can check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows - ruclips.net/video/8i7-IEKJhzU/видео.html
If that doesn't help, I would recommend posting in the Microsoft Power Automate Community: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks. I figured out what the issue was with that problem. Now I'm having the issue of my User Items output not showing up.
Hi Team, Nice Vedio, I have an requirement like , I have sent Initial mail and after needs to send update on top of it initial mail, how can we achieve this? My source data is Share point excel sheet where I have values like Initial ,Update, Skip, Resolution where ever I changed the status I need to send an email on top of it Initial mail only.
Just wowwwww❤️❤️
Didn't follow the entire thing but it had something for everyone I guess to take up from.
Hi , I've been trying to add files to SharePoint site with " when an email arrives" . The flow is working. The problem I'm facing is that the Excel file which arrives to SharePoint site has to be manually moved editable, which creates another Excel in editable format. This is annoying . Any suggestions? Thanks
@acreativeoponion Very Nice vedio, I have a task like as per SharePoint list I have couple of solutions and I need to send the out 5 , need to send 3 solutions and their names in to initial communications to end users. After Job completed I need to send Update mail on top of initial mail and once all jobs are completed then need to send Resolution on top of Update mail. Please help on this.
This is exactly I was looking for. Many thanks...
Can you share same type of summary mail with Multiple task list of Planner.
Please Thanks in Advance
Can you show how to add two html tables (made from the same list) into one email?
I can't create the HTML table, keep on getting an error message about the body/value not existing but that's the only thing I can see to select. What am I doing wrong? Keep on getting an InvalidTemplate error message
GODLIKE
Hey is is possible to share the flow?
Works great however for some reason the filtering function doesn't seem to work for me. It reports I have say 6 overdue items, but it sends an email to everyone in my list with future items saying they're are overdue.
You might have adjust your filter query to ensure it's written correctly. You might find my latest tutorial helpful - How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks: ruclips.net/video/ODobGcpgGlk/видео.html
@acreativeopinion the issue was I was using a document library. I made a work around by having a list which is essentially a copy of the document library minus the attachments. Then it worked perfectly.
Great video, i made this but the emails gets repeated 3 times in a row, how to fix it?
It's hard to troubleshoot a flow in the comment section. Anytime something is repeated unintentionally-it's usually the logic of the flow that needs to be adjusted.
It sounds like you have your email action nested inside an Apply to Each action. You might be interested in this YT Tutorial: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow - ruclips.net/video/44Bk4JVMrD4/видео.html
For additional troubleshooting tips-check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows - ruclips.net/video/8i7-IEKJhzU/видео.html
@@acreativeopinion thank you so much, i cannot thank you enough, there was a problem in my flow and i fixed it, great video 👍🏻👌🏻
I am looking to set date range Due in next 30 days , if I add 30 instead of 4 I get odd value (set output to dd-MM-yyyy: input 1-12-2023 output "11-02-2023"!
In my tutorial I've used a couple compose actions to return a dynamic date range. At 3:11 of the tutorial I've used a Compose action to store today's date. At 3:29 of the tutorial I've used an expression to compose the date 4 days from today's date. If you use the same expression and replace the 4 with a 30 it will give you the date 30 days from today.
Hope this helps!
@@acreativeopinion Fixed it I had a different date format from you in my flow! Can you advise how you would manage this is AssignedTo contained mutiple people?
Thank you for the effort I must said your video helped but there are problems at the select action there I suggest to add compose before select action reason because the value from the apply to each were object not item so select action unable to select the object from dynamic value. I've added a compose action before select to manipulate the object data to item so then select action is able to select the item.
How I can achieve the same functionality if I am using Excel online instead of SharePoint list ?
Instead of the Get Items action, you'll need to use the List Rows Present in a Table action. However, keep in mind that the Filter Query field in the List Rows Present in a Table action can only accept a single condition. If you need to filter your Excel table with more than one condition.
You'll need to use a Filter Array action. Check out this YT Tutorial for more info on how to use the Filter Array action: ruclips.net/video/HVAf1aTEQNg/видео.html
how to send a single email daily for any new files added or modified in SharePoint documents?
I am trying to have the email number the items numericly. 1. Task. 2. Task 3. Task etc.
Access to CSS file path is denied
Sorry about that. Try it now: bit.ly/46wbFgb
You are changing the screens very fast. While the steps are very detailed, it is difficult to follow them
too many unnecessary steps, this guide was exhaustive but doesn't cater to the general structure if you want to create something like this. i was able to create a similar flow using way less steps to execute the same result
When using create table, you said that for the values, we use item()?['item name'] where 'item name' is the red text on the filter array output. But many of my fields have the red text and then several other red texts such as "@odata.type", "Id" or "Value". I need to get the value, what should I do?
Thanks for watching! If you need to get the value use ['item name/value']. Remember the text is case sensitive. Hope this helps!
Hi Team, Nice Vedio, I have an requirement like , I have sent Initial mail and after needs to send update on top of it initial mail, how can we achieve this? My source data is Share point excel sheet where I have values like Initial ,Update, Skip, Resolution where ever I changed the status I need to send an email on top of it Initial mail only.