Unanswered

Appending rows to a SharePoint list from Excel spreadsheet

(0) Share

Report

Posted on by LMDev

I have a system that I have no API inputs to. I have it dropping spreadsheets into a document library. I need it to take those reports and drop them into a list.

Screenshot 2023-11-26 225224.png

Screenshot 2023-11-26 224411.png

Since I do not know the Table dimensions of the reports as they drop, how do I make this dynamic?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @LMDev ,
Please insert all data into a table in the worksheet.
Delete the 'List rows present into a table' control and re-add this control to achieve synchronous updates of flow and data source. Flow can retrieve your newly inserted table.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
LMDev 4 on at

Like (0)

Report

Hi @v-yetonggu-msft, I already did that, and it still couldn't find it.

Is there a way I can automate turning the spreadsheet into a table and get all rows after the header without manually working on the spreadsheet?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @LMDev ,
Theoretically it's possible, but you don't know the dimensions of your table. That is to say, in the step of creating the table, you need to fill in the dimensions of the table, but you don't know it, so you can't use the create table and then traverse every row in the table.
My guess is that your flow and data source are not updated synchronously. You inserted a table, and the 'list rows present into a table' control cannot retrieve it. Delete the 'list rows present into a table' control and re-add this control to retrieve it. But I'm curious, you can put complete data into a table, why don't you know the dimensions of the table? If it's convenient, can you post a screenshot of your worksheet?
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
LMDev 4 on at

Like (0)

Report

Hi @v-yetonggu-msft ,
I can't give a screenshot of the worksheet because it is filled with people's info.

I know it couldn't find the file name because it was dynamic. I inserted a custom value into the Table field of Table1 and am hoping that will work.

I know the columns; they are the same every time. I just do not know the quantity of rows.

@AlexEncodian 's idea of selecting the first 5000 rows and skipping the empty records may be best. I am seeing anywhere from 5 - 3000 results coming through currently. I'm guessing Encodian's features are not free/included so not my first choice of solution in this case.

Was this reply helpful? Yes No