Usage of get table

[MikeWJS]

Hi,

I have a file that is recreated each night.

The file does not contain a table so I have used the create table in PA to create a table (table1) which works OK.

I am using Powerautomate to import the spreadsheet which when run manually works.

However, when scheduling, because the table is recreated each time, the flow fails and a hex string is in the import table name because the uid is different each time the tabel is createdl.

I think I need to use get tables function in PA to get the table ID and then pass it to the create sharepoint list step but the problem is, unless select the dropdown from the previous step, I am unable to map the fields from the excel spreadsheet to the sharepoint list.

Could anyone possibly help on how I can acheive this?

Thanks,

[jinivthakkar]

@MikeWJS create a variable, assign the value to table name when you create table, assign the same value to table when you list rows in a table, hope this helps

if you don't have the table name then you need to have a fixed format to generate a predict a table name dynamically e.g. Mar082022 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[MikeWJS]

Thanks, this is useful, but the issue lies with the step afterwards where I am trying to map the fields in sharepoint to the fields in the spreadsheet.

If I choose the dropdown the fields from the spreadsheet appear in the dynamic content windows but not if I use the variable so I am unable to map it.

Thank you very much for your response though 😞

[MikeWJS]

If anyone could help me out I would be extremely appreciative. I have spent 6 hours today trying to find a solution and have been pushed to the brink of insanity 😄

[jinivthakkar · Accepted solution]

@MikeWJS if the options dont come automatically, you can type in the name manually 

Go to field it will open menu for Dynamic content and expression, then paste this in expression content items('Apply_to_each')?['ColumnName']

and click OK.

Do a test run, and then repeat this for every column which is not appearing directly in Dynamic content.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[MikeWJS]

@jinivthakkar Thanks so much for your reply and help. I am currently on annual leave but will attempt this when I return and let you know how I get on!

Once again, many thanks!

[MikeWJS]

@jinivthakkar Thank you so much for your response, using the items method above this worked!

The flow is now working exactly as expected, here is what I ended up with, 

Although the flow works fine, it errors out.

This is because the number of rows in the spreadsheet is unknown. I therefore have to set the table to be created for 5000 rows but after the actual data is imported, it creates lots of blank entries so expects a number instead of a blank record. How can I possibly suppress this error please?

Once again, thanks for your help. I may mark this question as answered and open another question for the error above.

[jinivthakkar]

@MikeWJS yes please close this question and open a new thread for the issue

[MikeWJS]

Thanks again!