web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Join Sharepoint lists ...
Power Automate
Unanswered

Join Sharepoint lists to Update

(0) ShareShare
ReportReport
Posted on by 795

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

Categories:
I have the same question (0)
  • Verified answer
    v-micsh-msft Profile Picture
    on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard