Power Platform Community Forum Thread Details

Excel files from many locations I want contact them to power Bi

Hey guys I work with company as data analysis

I want make my work automate by the power automate I love it I hope it will help me .

basically My every day I do as follow:

1-every single day site 1 & site 2 & site 3 etc.

they send me an excel worksheet which contains 30 -31 sheet (monthly)

2- i take this fils and I open a new worksheet and use vlookup function to extract important row and use it in thais worksheet as summary to my managers

so can I make it automate it by power automate

I saw many videos in YouTube the logic come in my mind as follow :

first I want make all the sites in oneshareepoint to upload the excel files which means sense the make a new sheet with table that records automatically at the share point

second I want save it in my one drive day by day after that I would clean it by some expression or script and extract what I want from this table and contact them to power BI streaming

is that possible please help me as u can and leave any idea and if you can explain that to me step-by-step or if you have any script or video that would help me I’ll be much appreciated

Quick Links

Leaderboard > Power Automate