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 / Add to SharePoint List...
Power Automate
Unanswered

Add to SharePoint List from multiple forms

(0) ShareShare
ReportReport
Posted on by 30

Hello! I am am struggling to figure out how to update a SharePoint list via multiple forms.

 

I have 3 forms, which a user has to submit depending where they are within a training course. All forms will have a "User ID" in them that are unique to each user and is used to identify them on our systems. The User will insert this number into the forms.

 

I have assumed that you need separate flows for each form, but I want the SharePoint list to be added to with each form submission - so other Columns are completed, and none overwritten.

 

  • Flow 1 > make SharePoint row and populate with form 1 details into columns
  • Flow 2 > add Form 2 into SharePoint row that matches same user ID in row and form - how do i find the row then add details
  • Flow 3 > same as Flow 2 but with form 3 details
Categories:
I have the same question (0)
  • PrasadAthalye Profile Picture
    on at
    Re: Add to SharePoint List from multiple forms

    Instead of 3 different forms, can you design single form using branching logic? You can design questions and branch next questions such that they only show in the correct order for a form. Then you will be able to create SharePoint List Item easily.

  • MoragB1495 Profile Picture
    30 on at
    Re: Add to SharePoint List from multiple forms

    Unfortunately its part of a training course, so the user will need to fill out a form at different time of the year the forms will be filled out. So must be different forms. Unless you can advise of another way?

  • Verified answer
    Alastair Profile Picture
    62 on at
    Re: Add to SharePoint List from multiple forms

    You are correct in that you need 3 different flows for the 3 different Forms.

     

    For forms 2 & 3 you can use the Get Items Sharepoint action to find the item in list with the same UserID from Form1.   The filter Query field should look something like UserID eq 'UserID'.  I like to reference this for Filter Query Syntax OData Filter query in SharePoint Get items in Flow (sharepains.com)

     

    Once you have found the matching item you can either do a loop from get items (which should iterate only once) to update the item it has found, or use the first expression as you know there should only be one result.  The first expression would look something like below which would go into the ID field for an update item SharePoint action.

     

    First(body('GetItems')?['value'])?['ID']

  • Turtle1 Profile Picture
    2 on at
    Re: Add to SharePoint List from multiple forms

    How would I solve issue like that if user can show multiple time on a list e.g. one user can do more than 1 course and I want to send a evaluation form every time course status change to completed. How would I link form response to actual user and course name. Can it be picked somehow to not repeat questions for user name and course name in questionare?

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
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard