Showing results for 
Search instead for 
Did you mean: 
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.


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 (



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
New Member

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

Helpful resources

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)