cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
WebTechPlus
Level: Power Up

Link a Sharepoint Database to a Microsoft Form, to a Shared

Basically what i want to do is link data from a SharePoint DB to a Microsoft form and then add in some additional options update the database and create a repeating calendar event and sent to the attached parties. 

 

Flow is linked to the DB, the client enters in their email address, this triggers a lookup of the database and populates the missing fields and or options.

 

Once the client has completed the form it updates the database and creates a repeating event from the additional data that was requested. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Link a Sharepoint Database to a Microsoft Form, to a Shared

Hi @WebTechPlus, just 1 point here: auto-populating data in a form is not possible. The client will enter their email address in the first question but the rest of the form can't pause while data is fetched from SharePoint. The form has to be completed and submitted before the flow triggers to get the response and add it to SharePoint together with data from other lists.  So before I or someone else shows you what you can do you might need to re-think it slightly.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Link a Sharepoint Database to a Microsoft Form, to a Shared

Hi @WebTechPlus, just 1 point here: auto-populating data in a form is not possible. The client will enter their email address in the first question but the rest of the form can't pause while data is fetched from SharePoint. The form has to be completed and submitted before the flow triggers to get the response and add it to SharePoint together with data from other lists.  So before I or someone else shows you what you can do you might need to re-think it slightly.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

 

View solution in original post

Super User
Super User

Re: Link a Sharepoint Database to a Microsoft Form, to a Shared

@WebTechPlus 

I agree with the comments made by @RobElliott but would like to add that you can likely create a solution using Power Apps rather than Forms that meets your requirements.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
WebTechPlus
Level: Power Up

Re: Link a Sharepoint Database to a Microsoft Form, to a Shared

Scott and Rob,

Thanks for your feedback, i had already started last night looking into the PowerApps.

I will continue down that path and see how we go but i should be able to get something together, and a solution in place hopefully.

 

Thanks for your assistance and getting back to me so quickly.

Super User
Super User

Re: Link a Sharepoint Database to a Microsoft Form, to a Shared

@WebTechPlus no problem. If you need any assistance with the Power Apps side of things just shout and we'll try to help.

Rob
Los Gallardos

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (10,414)