Answered

Excel Get Rows and No Dynamic Content

(0) Share

Report

Posted on by dgwilson

I'm sort of new to Flow and I'm struggling with getting the Excel Dynamic Content from Get Rows. As a Neeewb... I don't know where to turn. Short story... I'm trying to read an excel spreadsheet (table) and update some attributes in a sharepint list).

The screenshot attached shows that I cannot see the columns in my excel table: Flow Excel Dynamic Content.png

When I can get the row/column values from the excel file... I then need to use one of those row/column values to look up a specific row in the sharepoint list... What's displayed in the screen snapshot is eq currentitem... HOP Number is invalid and simply a reminder to me that it needs to be fixed.

I do not understand why 'current item' is not showing me the column headers from the table in the excel file.

- David

Categories:

General topics

All responses (4)

Answers (1)

Sort by

v-zhos-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dgwilson ,

I have made test on side, it don't have the issue you mentioned.

Please take a reference to the flow I made below:

I suggest you rebuild the flow for a try.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Verified answer

dgwilson 12 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-zhos-msft

I ended up copying the table in the spreadsheet to a new Spareadsheet with only a single tab. In addition I also removed all spaces in the column headers. Redid the getrows in the flow and it worked.

I don't know what was messed up. The original getrows could definately see the table that was defined. Some diagnostics at this point would be nice to truely confirm what is available at this point.... it is like flying blind otherwise.

Thank you for the recommendation.

- David
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @dgwilson & @v-zhos-msft,

This same thing is happening to me, I realy don't know what to do by now.

Doing this flow that when a new file is added to a sharepoint folder, it should take the excel file, convert it to table, then list rows and theeen I should be able to populate a sharepoint list with this values I get from each rows of the recently created excel table.

This is my flow by now

Buut that is not happening, no outputs for this 'List rows present in table', even though in the outputs of the test the action does detect and list all the rows of the excel table. Very weird, i don't no what to do.

Best regards,
Luis G
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-zhos-msft & @dgwilson ,

This same error is happening to me. Building the following flow where when a sharepoint file is created, an excel table is created in the file, then this table should be listed. This works perfectly when testing the flow but the dynamic content of the list rows action is not appearing in further actions.

This is my actual flow:
As I just said, the dynamic content of list Rows present in a table doesn't appear. I want this for populating a sharepoint list with this data.