cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Super User III
Super User III

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

6 REPLIES 6
Highlighted
Super User III
Super User III

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

Highlighted
Super User III
Super User III

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
Highlighted
New Member

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.

Highlighted
Super User III
Super User III

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

Highlighted
New Member

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

Hi Everyone!

 

I am new to all these Microsoft suites apps and really looking into learning more about how I can best utilized these apps for our processes. 

 

I would like to follow up on the comment @RobElliott  made! I just look up what PowerApps is and want to make sure I'm understanding it correctly. 

 

I have an vba coded excel form which will pull data from database when people enter the ID #.(it's kind of like when you enter ID and all other info will be auto-filled in) Can I do the same thing with PowerApps? I see that I can pull data into PowerApps but can I set it up to look up matched information based on the input?

 

Thanks in advance,

Jessie

Highlighted
New Member

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

sorry the powerapps comment was added by @ScottShearer ...! apologized!

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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!

Top Solution Authors
Users online (7,847)