From MS Forms to Sharepoint

[Ellingsen01]

Hello,

I am looking into the possibility of getting responses from a form to a sharepoint list, but I've ran into an issue. If the responders select let's say Team A, they will skip a section of the form which has a three choice selection that determines their function status in the sharepoint list. My idea is that Team A has a self assigned function status. So my problem here is that I can't make it so that if Team A is chosen in the forms they don't get assigned the function status that is made for them. 

PS. I know I could just add that section to the form with only their function status, but I would like to try and avoid that. 

Thanks

[#2 · Accepted solution]

@Ellingsen01 we always save each Forms response to a SharePoint list via flow in Power Automate. So you could do the same and have a condition that looks at what team the user has selected. If it's Team A then in the If Yes channel have a create item action that sets the function to whatever you want. In the If No channel have another Create Item action and just save the function they selected from the branch in your form.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)