
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
I need to do a comparison so that if Reports.ID matches TemporaryReports.OldID, Update Reports
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:
Post back if you have any further questions.
Regards,
Michael