SharePoint Power Hour: Power Automate loop through tasks

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -



Let's connect:

IW Mentor (Information Worker Mentor)

[lisawork]

This was EXACTLY what I needed! Thank you

[johnpeterson]

There's a simpler way to do this.
In Get Iems > Filter your Query > Sort by the email address.
Apply to each
Condition If - current email address contains set variable Previous Contact
If Yes run an append which will build a string of information for the current users (HTML)
If No send the email - reset the HTML Append.
Set Variable - current email set variable Previous Contact
---
This process won't sent the email to the final recipient. so run a seperate send email which well send the email to the last person.
---
Really easy and timewise quicker to process.
---
This was good to learn new concepts though.

[aaronroth]

Thanks. That helped me get a better understanding 'apply to each' in Flow.

[yehunlavolontededieu]

Laura, Please could you do some simple and straight video about How? when? and why? we use variables in MS flow? Just general scenarios why I need a variable, I just wanted to understand the whole idea of using all the variables(increment, decrement, initialize, set, append to array variables) I like your vlogs b/s you go through each every step and most importantly you explain WHY you used the stuff and the reasons....So, that helps to implement the solution in different business requirements. I haven't found any vlog/blog that explains these things, they just post the steps, with no explanation for why and when to use.
Long-time fan, Thanks for your involvements

[lancesmith]

Thank you Laura! this helped me understand variables a better.

[achyutpsd]

HI Laura, Your training videos are fantastic. I need your advise on how to include a people picker in PowerApps forms for multiple users

[henrycheung]

Great video!!! I am looking for a Flow steps to do something exactly like this. THANK YOU!!!

[EddieThomas]

Awesome vid as usual, great job Laura,

[JonathanMoss]

Around the 38 min mark there is a section where Laura uses a 'replace' function to build the html link string. I thought a 'concat' function would have been a more efficient way to build that instead of the nested replace functions? Or have I missed something

[ganchome]

Hi Laura, and community. With the way Power Automate continues to update connectors can folks comment if a video is no longer valid?? I don't know if its me or what, but I can't get past the filter array. No one explains it like Laura though. Thank you LR!

[sappraku]

Great Job thank you. I would like to ask for help, how do i create task to remind me of only schedule task for the current month and overdue task ?

[heatherfeather]

Any improvements to this workflow 3yrs later? I noticed that you can skip the complex hyperlink step. In outlook it converted my links to hyperlinks automatically. I was also unable to get it running using the people picker field at all...filter array and/or parsing wouldn't return anything in body. I had to make a flow that filled out a new column with just the flat email address and use a filtered view of my list to get it going.

[slbwr]

Hi .. I have a question relate to this due date .. I have created a custom list and I have a receiving items date where I need to have a notification after 15 days if receiving the the items . Can you help on having a session on that subject

[marryvond]

Hi Laura,
I wanted to make this workflow but i used Task list. For some reason in my workflow when i pick Get Items, i am not able to find Task list under List Name. Do you have any advice how to bypass this but still using the Task list ( list is enabled for all content types)

[aldrichin]

When I try to filter array i get this Error "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Filter_array' at line '1 and column '2963' is invalid. Action 'Assigned_to_Array' must be a parent 'foreach' scope of action 'Filter_array' to be referenced by 'repeatItems' or 'items' functions.'.'." -

Not sure what is wrong

[daniloortiz]

I want use equal in filter query, when Is his use

[mukeshs]

Its 2024 May and this does not work as expected. Still troubleshooting!!
Getting error ""Flow save failed with code 'InvalidTemplate' and message...."

[mrwhammer]

for schedule it says you cannot use this trigger as an action

[cbtjoe]

Wasn't there a blog post on this with printed steps?

[pokhren]

My link comes back as ^[ID]* replace didnt take place. Also no error was reported. How can i troubleshoot?