Unanswered

CSV to New Excel Workbook / Table to Sharepoint List -- Stuck at "List rows present in table"

(0) Share

Report

Posted on by letsdothis

I've been scouring the internet and stubbornly trying to solve this problem without help for way too long. I've admitted defeat so I could really use some help.

I'm trying to build a flow takes data from a csv and adds it to a sharepoint list. The CSV file always has the same columns but the number of rows varies. Here's a quick summary of the flow as it stands right now:

1. Get CSV file stored in OneDrive for Business folder.

2. Perform a series of actions that create new Excel workbook and import CSV data.

3. Run Excel script that selects the data range in new workbook, creates a table named "MyTable", changes column names to match target Sharepoint List, and sets data types to match the target Sharepoint List.

4. List rows present in same Excel table (MyTable).

5. Create an item in Sharepoint List for each row in the table.

The problem:

I can't get the "List rows present in table" step and therefore the following "For each - Create item" steps to successfully complete. The error returned is "Not found" and "status: 404 - message: No table was found with the name 'MyTable'. I've confirmed that the previous steps did indeed create the workbook and table where and as expected.

I've tried a LOT of changes but nothing works.

Flow details attached. (I know I'll need to map the fields in the "Create item" action but I need to get the "list rows" action working first.)

Any help / suggestions will be GREATLY appreciated!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

LukeMcG 48 on at

Like (0)

Report

The first step I'd recommend is adding a "Get Tables" action before your "List rows present in table" to confirm that the table is creating correctly and that your Delay action is long enough to allow the script to complete before the Flow continues.

Using the output from "Get tables" you would also be able to create a Do Until loop with a condition to confirm that the table has been found before running your "List rows" action.

Was this reply helpful? Yes No
letsdothis 4 on at

Like (0)

Report

Thanks! I'll give that a shot.

Was this reply helpful? Yes No
letsdothis 4 on at

Like (0)

Report

I tried adding the "get tables" action. The result was the same...no data being passed from excel to the sharepoint list. -- I do know that the actions to create the excel workbook and table are successful though because the workbook is created in my folder. When I open the workbook, the table has indeed been created with the name I expect and populated with the data I expect. I just can't seem to pass the data from there to the sharepoint list.

Was this reply helpful? Yes No