cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhinesh28R
Post Prodigy
Post Prodigy

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @Dhinesh28R ,

 

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

vjefferni_0-1642498863056.png

 

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
DamoBird365
Microsoft
Microsoft

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
Community Support
Community Support

Hi @Dhinesh28R ,

 

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

vjefferni_0-1642498863056.png

 

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,594)