Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Compiling SharePoint Lists

(0) ShareShare
ReportReport
Posted on by 108

I have a SharePoint list which acts as a user list for individuals on my project across two softwares. 

I've mimiced this in an excel spreadsheet as seen below.

 

d3ZZ6Rk.png

 

We receive account applications through MS Forms.

 

If I recieve a ProjectWise account for Donald Moor, as an example, I want it to add the form information to his row (i.e add his email address to the pw acc? column).

If we recieve an account application for someone who doesn't have either account yet however, I want a new line to be created for this previously unrecorded user.

 

I had this working and accidentaly deleted the Flow!

Help to restore this would be much appreciated.

 

Any questions, ask away.

  • CameronTCD Profile Picture
    108 on at
    Re: Compiling SharePoint Lists

    Yes, unfortunately this has not worked.

    I am using SharePoint lists.

     

    Apologies,

     

  • gamoraes Profile Picture
    1,040 on at
    Re: Compiling SharePoint Lists

    Hi @CameronTCD 

     

    Did you tried the solution that I posted?

     

    I think is the more easy way to achieve your issue

  • CameronTCD Profile Picture
    108 on at
    Re: Compiling SharePoint Lists

     Next you need to use the 'SharePoint - Get items' for finding this user exists in SharePoint list item or not.


    How is this done? I've tried conditions, filters and nothing really seems to work..

     

    Regards,

    Cameron

  • abm abm Profile Picture
    32,492 Most Valuable Professional on at
    Re: Compiling SharePoint Lists

    Hi @CameronTCD 

     

    My suggestion is based on if you are storing the forms response in SharePoint list. If not then look at the suggestion from @gamoraes .

     

    I got a little bit mixed up here whether you are using SharePoint list or Excel.

     

    Thanks

  • abm abm Profile Picture
    32,492 Most Valuable Professional on at
    Re: Compiling SharePoint Lists

    Hi @CameronTCD 

     

    You need to use the trigger as 'Microsoft forms - When a new response is submitted'. Next you need to use the 'SharePoint - Get items' for finding this user exists in SharePoint list item or not. If not then create a new SharePoint -  list item. If it is an existing one then you need to check with form reponse to identify Projectwise or Projectmapper account then update the details using SharePoint update list item.

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

     

    Thanks

     

     

  • gamoraes Profile Picture
    1,040 on at
    Re: Compiling SharePoint Lists

    Hi @CameronTCD 

     

    You'll need to use 3 excel actions and a parallel brach:

    image.png

     

    The trick is that you need to configure run after in  'Add a row into a table' action, by clicking in '...' and changing like below

    image.png

    And finally to grant that your flow end with success you need to use a 'Terminate' action after add row.

     

    Your end result should be:

    image.png

     

    I have a video doind this, but is in pt-br: https://www.facebook.com/bernardes.rafael/videos/433868234003174/ look to 30:00.

     

    Sorry for the audio, i changed the config and this cut my audio.

     

    Best Regards,

  • CameronTCD Profile Picture
    108 on at
    Re: Compiling SharePoint Lists

    Hi @abm 

     

    Apologies, I should've clarified...

    I'm aware of this.

     

    What I meant to say is how do I re-create this?

  • abm abm Profile Picture
    32,492 Most Valuable Professional on at
    Re: Compiling SharePoint Lists

    Hi @CameronTCD 

     

    If you deleted your flow you can't restore it.

     

    If you want to vote for this please see the below link.

     

    https://powerusers.microsoft.com/t5/Flow-Ideas/Recycle-bin-for-deleted-flows/idi-p/111788

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

     

    Thanks

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492