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.
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)
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
It was great, but not what i was looking for. Thanks anyway
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.