cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Join Sharepoint lists to Update

Really struggling here, but keep getting nested ForEach errors...

 

I have 2 lists, Reports and Temporary Reports.  I need to update Reports from Temporary reports, however, the ID in Reports is in OldID in temporary reports and i cant work out for the life of me how to join them.

 

Help me please Smiley Frustrated

 

I need to do a comparison so that if Reports.ID matches TemporaryReports.OldID, Update Reports

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Join Sharepoint lists to Update

Hi @Delid4ve,

 

Could you please share a screenshot of the current Flow configuration?

If here you are working with two Lists, then we need to do some steps to workaorund it.

For example, here we have two Get items Action, one for reports, another for TeporaryReport.

Both action would return an array, steps should be as below:

1. create an array type variable, set value to reports array, Use first() function to get first item from Reports array,

2. Add a do until , then Use filter array to check if the first(Report_Get items).[id] matches the [OldID] in TemporyReport array,

3. Add a conndition, check if the Array is empty, if not, update corresponding item with Update item action, 

4. Do until condition to check if Array variable is empty,

5. Within Do until, add a compose, with Skip () function to remove the first item, after the filter array action

Adding a thread for reference:

Working with two array

Post back if you have any further questions.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Join Sharepoint lists to Update

Hi @Delid4ve,

 

Could you please share a screenshot of the current Flow configuration?

If here you are working with two Lists, then we need to do some steps to workaorund it.

For example, here we have two Get items Action, one for reports, another for TeporaryReport.

Both action would return an array, steps should be as below:

1. create an array type variable, set value to reports array, Use first() function to get first item from Reports array,

2. Add a do until , then Use filter array to check if the first(Report_Get items).[id] matches the [OldID] in TemporyReport array,

3. Add a conndition, check if the Array is empty, if not, update corresponding item with Update item action, 

4. Do until condition to check if Array variable is empty,

5. Within Do until, add a compose, with Skip () function to remove the first item, after the filter array action

Adding a thread for reference:

Working with two array

Post back if you have any further questions.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,681)