Answered

Power Automate Scheduled Flow to run on multiple lists in different subsites

(0) Share

Report

Posted on by kk13

I have a requirement of running a scheduled flow every month for multiple lists in 6 different subsides (2 lists in each subsite).
I have to check multiple date fields is they are bank or not.

If any of the date fields are blank then send email to the created By with blank date fields mentioned in notification.

This notification needs to be sent for all the items with blank date fields in the Lists in different subsite.

Any direction to create the flow will be highly appreciated.

I am trying o build the flow as the attached screen shot please help multilist flow.jpg

All responses (2)

Answers (1)

Verified answer

kk13 25 on at

Like (0)

Report

Re: Power Automate Scheduled Flow to run on multiple lists in different subsites

Thanks a lot for the suggestion. I figured it out.

Yes all List column names are same
Please refer the attachment for details of the flow.

Note: List name is “DISPLAY” name.
And Filter query takes “DEFAULT” name of the columns for checking conditions

I didn’t used array but used Data Operator-Compose for having the default text for the url of sites (we can use full url in Get items by pasting it as well its upto you)
Condition to check if any of the Date fields is blanks in Filter query section of Get Items:
(DateField1 eq null) or (DateField2 eq null)

After that I used apply to each for running the same action for all retrieved List items
(Idea from this answer)Then Get Item and identified the ID of the retrieved item using this formulae: item()?['ID']

I get all the items ID to retrieves the metadata (all column values) to send it in my notification email.

That’s it.
It looked like very complex flow but proved to be quite straight forward Thanks for your suggestion abm
abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Power Automate Scheduled Flow to run on multiple lists in different subsites

Hi @kk13

Believe all the sites have same columns then only your filter query will work. What you could do is declare an array which contains the sites and list names. Iterate the array and do the following as dynamic variables.

So for the above in your case replace the Dynamic mappings from the array which contains the site name and lists. You may need two arrays. One for the sites and other for lists. If you using single array collection then you need to declare the sitenames and list names as (sitename - listname). Later when you iterate each item split the item using split() expression to get the name and list so that you can pass this as dynamic values to Get Items.