cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ColaborativoPR
Regular Visitor

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

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,

1 ACCEPTED SOLUTION

Accepted Solutions


@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

 

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
BCLS776
Super User
Super User

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

 

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

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

 

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,614)