Unanswered

How is my Excel file getting data from Sharepoint?

(1) Share

Report

Posted on by RebWilson272

We have a Power Automate process which, amongst other things, takes information from a Sharepoint list (taken from responses from a Microsoft form), and updates an existing Excel file with data.

The 'Update a row' steps do not include and of the dynamic fields for the data that is being pulled through, where is the Excel file finding this information from?

The headers on the Excel file table match exactly with questions from the Microsoft form, is this how it is pulling through?

Any help would be appreciated!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

TYL 1,091 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @RebWilson272 ! Did you make sure that the Excel file (or sheet) has a table? If not, try to make a table out of the data you have by formatting it as a table. This is important for the 'Update a Row' action to perform it's action!

Was this reply helpful? Yes No
nbieberdorf 3 on at

Like (0)

Report
Copy link

Link copied!

I'm here for the same exact question! My data is formatted into a table w/ headers.

Was this reply helpful? Yes No
RebWilson272 4 on at

Like (0)

Report
Copy link

Link copied!

Hi,
It is formatted as a table, the issue is not that 'update a row' isn't working, it's that I can't figure out how data is being put into my Excel table (as there is no dynamic fields in my power automate flow instructing it to)

Was this reply helpful? Yes No