cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Herculas
Regular Visitor

Microsoft Forms

Good day.

 

I want to know if it is possible to complete different Forms and add the info to the same list?

 

I have a process where different users must enter different details.

I do not really want users to edit the list. SO I was hoping to use different forms for each section of the list that must be completed.

2 ACCEPTED SOLUTIONS

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @Herculas ,

 

Thanks, the screenshot clarifies what you are trying to do.

 

You will need to have a field which will exist in both forms that will act as a lookup.  Without this, your 2nd flow wont be able to identify the response of the first flow to update.

 

As you cannot create lookups in Forms, this will need to be free text and imo, not recommended as a typo will result in a mismstch and data issues.

 

Is PowerApps an option?

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

Thanks for that.

Power Apps I know nothing about YET.
I will have to look into using PA then.

View solution in original post

4 REPLIES 4
eric-cheng
Solution Sage
Solution Sage

Hi @Herculas ,

 

Sure, you can have multiple forms which triggers its own separate flow and writes to the same list in SharePoint.  

 

You simply need to configure the SharePoint Add Item action to reference the same list. 

 

You may run into challenges if you have mandatory fields in different sections of the list though.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Thank you for this information.

I'm very new to PA.


I know how to point it to the list.

BUT I need the different forms to complete the data of the first list. This does not make sense.

 

This is what I got: 

  1. A list with different columns.
    2022_07_11_15_22_38_Accounts_TECI_BT_Refunds_All_Items.jpg
  2. First part get completed by user 1.
  3. Green part by different user and different form.
eric-cheng
Solution Sage
Solution Sage

Hi @Herculas ,

 

Thanks, the screenshot clarifies what you are trying to do.

 

You will need to have a field which will exist in both forms that will act as a lookup.  Without this, your 2nd flow wont be able to identify the response of the first flow to update.

 

As you cannot create lookups in Forms, this will need to be free text and imo, not recommended as a typo will result in a mismstch and data issues.

 

Is PowerApps an option?

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Thanks for that.

Power Apps I know nothing about YET.
I will have to look into using PA then.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,528)