cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CM72
New Member

Obtain excel online field using power automate

Hello I'm trying to extract only one field from an excel file using power automate. 

Let me explain: When an file is created in a sharepoint library (excel file), i need to extract a field (email ) from that file and then start an approval process.

If i use the connector between Sharepoint and Excel, i can go to the folder but how can i set a variable to obtain the name of the file an the table name? 

The flow only accepts tables in the file, but i just need one field, is this possible to obtain?

So every time a file is added  this can go and obtain the field.

Thanks!!

2 REPLIES 2
abm
Super User
Super User

Hi @CM72 

 

Flow need a table for reading the excel sheet. 

Have a look at this.

 

Power Automate: Access an Excel with a dynamic path - Manuel T. Gomes (manueltgomes.com)

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
CM72
New Member

It was great, but not what i was looking for. Thanks anyway

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,037)