Forum Discussion

brainstewn's avatar
brainstewn
Copper Contributor
Nov 09, 2021

Form for multiple entries over weeks with multiple users

I want to create a form where each user completes the form and the data populates a particular column and/or row of the spreadsheet.   In an effort to minimize user error is it possible to send the...
  • RobElliott's avatar
    Nov 10, 2021

    brainstewn Forms certainly has no functionality to do anything like that. You would probably need to build a flow in Power Automate with a link to the form. You'd either have one flow per week or have a separate flow for each week. You could set it going automatically with a recurrence schedule trigger. But then you'd have to work out whether the flow was saving all the responses into the smae spreadsheet or have a separate spreadsheet for each week then merge them. Not simple.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources