how to update sharepoint list when Form is updated

(0) Share

Report

Posted on by gwenda

I created a Form....asking simple questions like name, school, and yes/no questions.

I then created a list in SharePoint so users could see a live update.

Later, I was asked to add a question to the Form.

Now, I can't get the data in that added question to show up on the List.

I did add the item in the flow. I can see the correct columns and data in the OneDrive/excel sheet.

What am I missing? Please help. I am very new to all of this.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gwenda,

Could you please tell me that what kind of form you fill, is it a Power Apps Edit Form or a MS form?

Do you mean that SP list does not reflect the updates corresponding to the new field that you add to?

Actually, SP list is a database displaying all the fields it owns, the new added question is added to the Form not the SharePoint list. The excel sheet could be synchronized with the form updates including all the field you add to the form but SharePoint could not, that's why you could view it on Excel sheet.
gwenda 13 on at

Like
a
(0)

Report
Copy link

Link copied!

It a MS Form. and yes....the SP list does not reflect the added field.
I added the question to the Form. The info is showing on the Excel sheet correctly.
Is it true that SharePoint list cannot accept the updated Form/Excel sheet data?
RobElliott 10,539 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@gwenda Power Automate doesn't dynamically update the columns in the SharePoint action. So if you add a column to a SharePoint list and have your flow open in Edit mode, you need to close Power Automate and go back into it and open the flow again. It will re-query the SharePointlist and show the new column.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
gwenda 13 on at

Like
a
(0)

Report
Copy link

Link copied!

@RobElliott I was able to add the last dynamic (does your child...) in the flow.
It shows on the Excel sheet.
Does not show on the SP List.
gwenda 13 on at

Like
a
(0)

Report
Copy link

Link copied!

I have also tried the suggestions above...I am still hung up.
Verified answer

gwenda 13 on at

Like
a
(0)

Report
Copy link

Link copied!

figured it out!!! I had to edit column settings -- checked the box for it to show. I was also able to edit the display for the column headings. Thanks for your help guys.