Answered

Add to SharePoint List from multiple forms

(0) Share

Report

Posted on by MoragB1495

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:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
MoragB1495 30 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Alastair 62 on at

Like (1)

Report
Copy link

Link copied!

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']

Was this reply helpful? Yes No
Turtle1 2 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No