List rows present in table dynamic content not appearing

[Anonymous]

Hello ,

Building the following flow where when a sharepoint file is created, an excel table is created in it, 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. Even though when testing the flow the action does rettrieve a successful output with all the items of the table. So i don't know why does this values does not appear dynamically in further action.

I want this for populating a sharepoint list with this data. 

Any help or ideas would be so much more than welcome. 

[Anonymous]

Might it be a way in which I can kind-of encapsulate the 'create table function', so that when doing the 'List Rows present in a table', I could just say here is the table that have just been created, instead of giving it a path for seaching for it again... Maybe somethng like this could help to solve the problem.. 

[v-alzhan-msft]

Hi @Anonymous ,

Do you mean the column dynamic content in the table doesn't appear after the "List rows present in a table" action?

Since the excel table in created when the flow has run, so the flow couldn't parse out the column dynamiccontent after the "List rows present in a table" action, if you would like to create the rows in sharepoint list, you need the expression for get each column value and insert it in the sharepoint list.

The expression for each column should be :

items('Apply_to_each')?['ColumnName']

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yashag2255]

Hi @Anonymous 

I see that you are providing Dynamic content for the File attribute in the excel online actions. And in the List Rows action, you again have provided the file identifier as dynamic content and I am sure you must have provided the Table 1 as a custom value. 

Please note that a current limitation with the excel connectors is that the File attribute of teh actions need to be provided by clicking the folder icon and then navigating to the excel file location and select the excel file from the document library. This means that the excel file you want to access should already be present on the document library. And then for the List rows action, you need to choose from the tables that come in the drop down. 

Therefore, you cannot add or get nything from an excel file that you are creating within the flow itself as a direct action. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous · Accepted solution]

Hi, 

Not sure if this is the correct way but somehow I figure how to make the magic happen.

This only can happen if you always upload an excel file with the same format, same number of columns for example.

1. Fill the column names for your table when you create it. 

2. Then I used the get tables action and called the same file I called when creating the table

3. I set an apply to each to the value of the get tables action developed before.

(Here's the tricky part)

4. I gave some chance for a file uploaded and converted to table in my document library to be recognized by my flow (You could restart the application maybe), when recognized I found it in the 'File' slot of the list rows action and as well as the table in it in the 'Table' slot.

5. Using this non dynamical parameter I designed My flow as how I need it, and I was able to call the dynamic variables contained in the table, (all the column headers of the table). 

6. After this once my flow was working, so I changed the inputs for the 'List rows present in Table function' for the File slot. I once called again the file identifier dynamic variable from sharepoint and used the name dynamic variable of the get table function in the Table Slot. 

7. Deleted the excel document from my sharepoint, test it, uploaded another file an voila, it worked. 

I think the solution is tricking flows like kind of giving him a static value of file and table, once recognized develop the flow, once everything is working chamge the static values for dynamic values. 

As I said at the start, I think this just work for documents that are always the same (the column names and  number of columns always the same), very standardized format. 

[jslsmithyx]

Just wanted to say a quick thanks for this solution & confirming it still works as of posting this message. 

[lguzmanc433]

@jslsmithyx  Nice!! Yeah, its still a nice, good working trick! Regards from Costa Rica!

[majorfriend]

Thanks Alister,

I was also able to use your method to get this working, but I bypassed the Compose step.

So mine goes like this
SharePoint - Get file properties

SharePoint - Get file metadata (pass the file identifier from Get file properties)

Excel - List Rows (pass ID from get file metadata)

Then I was able to Apply to Each and go on with the rest of my flow.

[daisy88]

Hi Also have an issue where the list of rows present in my excel table is present in excel but not appearing under data operation - select option. Please help

[Doddy1986]

Would this also be the same formula when updating a record that matches the same unique identifier from excel to sp list ?