How to get dynamically excel table names from PowerApps to SharePoint document library using flow?

[Dhinesh28R]

Hi all,

What i need is need to do a bulk updates from Excel to SharePoint Document Library. At that same time i need to validate a SharePoint List for an already list having a same data or not. If it is empty i need to create a new row or else i need to do an update on a existing SharePoint list row.

But i couldn't get a Table name from excel file through update from a PowerApps.

Is it possible to get table name from excel file while we dynamically upload an excel file? This is what i need to know.

Thanks,

Dhinesh

[DamoBird365]

Hi @Dhinesh28R 

There is an action to get table names, returns an array of all table names, you can use first() to rerun the only table name if you are confident with expressions, otherwise it will insert you into an apply to each.

Damien

[v-jefferni · Accepted solution]

Hi @Dhinesh28R ,

Have you solved this problem? As @DamoBird365  mentioned there is an action for your scenario. I made a simple flow for demonstration:

But the question is, will you update multiple tables from your Power App? If you have only one table that update from Power App, you should directly use this table to validate with your SP list or update/create items in it, trigger the flow from the Power App, which means you will need to combine the flow you are designing with the old one.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[amulhearn0207]

Hi @v-jefferni  - I think what you are modeling here will support me as well.
I need to update a SharePoint list against an Excel Spreadsheet with a single table, but that spreadsheet deletes and replaces itself daily, so it seems the GUID is changing.

I'm not following the syntax needed in the expressions here, or what the variable is. I had it working perfectly until the file replacement occurred. Could you kindly advise?

[epicsmokey]

Any update on this or get it working? I am in the same boat of the file deleting and replacing itself daily.