1 form filled out by 3 people

Copper Contributor

Hello,

 

I hope you can help? I have a form which i need filled out by three separate people. There are certain sections that each person needs to fill out before it can be submitted. Is this possible? I am hoping to use Power Query then to pull out some of the data from this.

5 Replies

@Lisa567 with Forms this isn't possible, it is a single-pass submission. You could build a flow in Power Automate to save the first response to a SharePoint list and send an email to the 2nd and 3rd people with a link to edit the item in SharePoint. But with Forms on its own it can't be done.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thank you so much, this is a great help.

Hi Ron, i have access to Power automate, Power BI, all the Microsoft apps including access. Which software do you think is best to have a form that needs to be filled out by three people and merge certain data from that form?

@Lisa567 A SharePoint list as the backend data source then a Power Apps front end.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thanks Rob, i will give this a try, thanks very much.