Power Automate - How to read the contents of a new Excel file created under OneDrive?

In this tutorial, I will show you how to read the contents of a new Excel file created under OneDrive.

[@user-zo4cc3nh3k]

You are a genius! Thank you so much!

[@abm4975]

Thanks for the support

[@jonathanlau356]

this video is great! Thank you

[@abm4975]

Thanks a lot

[@e.dnorth]

Thanks, this video is very helpful! I do wonder though, is it possible to use the Create a Table action without extra actions if you have filtered ranges in the Excel sheet, or is that something that can only be addressed by a Run Script action?

[@abm4975]

May be an option but I haven't tried that yet.

[@saurav.vlogger]

Hi @abm Thanks for this video, just one question which I am looking can we something like power automate get to know any new filed uploaded in sharepoint folder or subfolder and read the complete data and send back data in excel table format to email

[@abm4975]

Hi What is the data format? Is this a word doc or PDF or XML?

[@saurav.vlogger]

@@abm4975 Excel file will be uploaded in SharePoint and power automate has to pick the newly uploaded file read the data from it along with color used in each cell and sent the data to email body in same format exactly whatever it is in Excel file uploaded in SharePoint

[@abm4975]

Hi Thanks for your reply. Could you explained the colour you mentioned the above? Do you want to read the newly created Excel file and send details via Email?

[@kanishkaroychowdhury4050]

hi thanks for the awesome video... i m new to flow... kindly explain the create table part... offset property why it is 103? and meaning of A,0,0... plz explain

[@abm4975]

Hi Thanks and thats the formula you need to use. There other formulas too. Thanks

[@srinivasmanohar4872]

Hi bro can you let me know how to copy file from SharePoint to NetApp in power automate

[@abm4975]

Hi Srini What is NetApp? Is this a third party cloud service? Thanks

[@alextyler1776]

Hi could you let me know how to extract contents from a email that has an excel file and upload to a list?

[@abm4975]

Hi Apologies for the late reply as I was away for few weeks. So first store the email attachment in OneDrive. Then follow the below video. kzbin.info/www/bejne/h2W0kIKNesZggNk Thanks

[@manunair700]

Sir may I have your phone nmber, I would like to talk to you further regarding Power Automate

[@abm4975]

Hi Please have a look at my channel about section and connect me via teams. Thanks