Adding a column to a Microsoft Form, so that it adds automatically in Sharepoint and then Power Apps.

[ColaborativoPR]

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,

[BCLS776]

There are two ways I read your question:

1. Can I add a column dynamically to my Sharepoint List using a form control within a Power App? The answer to that one is "No" - no such capability currently exists in Power Apps.
2. Can I use Microsoft Forms to automatically add data to a Sharepoint List? The answer is, "yes" - you can use a Power Automate flow triggered off a new response to a Microsoft Form to add an item to a Sharepoint List.

Note, Microsoft Forms and a form control within a Power App are two very different things.

Hope that helps,

Bryan

[ColaborativoPR]

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?

[BCLS776 · Accepted 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