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

(0) Share

Report

Posted on by Dhinesh28R

599

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
amulhearn0207 109 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
epicsmokey 48 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No