Set Variable Assigned in Loop - Iterating Over Filtered Array & Outputting Identical Values

(0) Share

Report

Posted on by CGood1

Hello,

I am trying to create a workflow that will work in tandem with a Planner schedule I have created.

Planner Schedule in Sharepoint

The goal is to send an e-mail twice a day that contains an HTML table with each job's Title, Due Date, and Production Phase (Bucket Name). I have the entire flow set up & working except for pulling the bucket names into the HTML table.

Whole Flow

I currently have a Filter Array looping through and comparing the Bucket ID of the task to the Bucket IDs from List Buckets in order to access the Bucket Name. After this I am attempting to Set Variable to the Bucket Name directly from the Filter Array loop. At this point in the flow the variables are outputting correctly for each Job ID.

Screenshot 2024-05-16 151547.png

Screenshot 2024-05-16 151834.png Screenshot 2024-05-16 151903.png

My issue is that the Select action my table is based on is receiving identical values for each job because the variable is being assigned inside a loop that iterates over the filtered array. How can I arrange my actions to have the correct bucket names output for each job?

Screenshot 2024-05-16 153254.png

Screenshot 2024-05-16 153038.png

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @CGood1 ,

Please check this test:

My Planner:

The Result:

My Flow Parameters Configuration:

length(body('Filter_array')) { "Title": @{items('Apply_to_each')?['title']}, "Due Date":@{formatDateTime(items('Apply_to_each')?['dueDateTime'],'MM/dd/yyyy')} , "Production Pharse": @{items('Apply_to_each_2')?['name']} }

Note that the html table is created outside the Apply to each and Apply to each2 loops.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
CGood1 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you!!! I followed your example and it worked perfectly.

Maybe you could help me with one last thing... If I wanted to sort the table by Due Date where should I put that action in my flow?

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @CGood1 ，

You can start a new post and I can help you solve this problem.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No