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 - Building Flows / Join Sharepoint lists ...
Power Automate - Building Flows
Answered

Join Sharepoint lists to Update

(0) ShareShare
ReportReport
Posted on by Delid4ve 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

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans