cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Impactful Individual
Impactful Individual

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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,654)