Hi,
I am struggling on how do I add a column in a Microsoft Form so that it automatically updates to the related Sharepoint through Power Automate, then automatically refreshing in Power Apps.
Thanks,
Solved! Go to Solution.
@ColaborativoPR wrote:
Ok good to know about point 1 (was thinking maybe I could do it). My question is geared more towards point 2. Do I have to go to Power Automate to link the Microsoft Forms response with the Sharepoint List column if I add a question?
To do this, you'll want to build the Microsoft Forms survey first, then go to Power Automate and build the flow. Power Automate will ask you to choose the Forms survey you want to work with, and then read its metadata to know what responses the survey will contain. From that, it will let you use dynamic content to plug survey responses into subsequent flow parameters, for example, values for specific Sharepoint list fields.
If you make an edit to your Forms survey, make sure to edit your flow afterwards so that any changes to the handling of edited fields is reflected in how the flow operates.
Bryan
There are two ways I read your question:
Note, Microsoft Forms and a form control within a Power App are two very different things.
Hope that helps,
Bryan
Ok good to know about point 1 (was thinking maybe I could do it). My question is geared more towards point 2. Do I have to go to Power Automate to link the Microsoft Forms response with the Sharepoint List column if I add a question?
@ColaborativoPR wrote:
Ok good to know about point 1 (was thinking maybe I could do it). My question is geared more towards point 2. Do I have to go to Power Automate to link the Microsoft Forms response with the Sharepoint List column if I add a question?
To do this, you'll want to build the Microsoft Forms survey first, then go to Power Automate and build the flow. Power Automate will ask you to choose the Forms survey you want to work with, and then read its metadata to know what responses the survey will contain. From that, it will let you use dynamic content to plug survey responses into subsequent flow parameters, for example, values for specific Sharepoint list fields.
If you make an edit to your Forms survey, make sure to edit your flow afterwards so that any changes to the handling of edited fields is reflected in how the flow operates.
Bryan