Power Automate: Use Excel connector with dynamic paths or files

[@PowerGI]

Intro & Errors when trying to building dynamic names: 0:00​ - 1:10​ Use ID to dynamically select files and function for table Name 1:10​ - 4:20​ Use the output of the dynamic file action in other cards 4:21​ - 7:56​ Test all the flow and transfer rows from Dynamic file to a General Log 7:56​ - End

[@basavrajmygeri971]

O

[@basavrajmygeri971]

L

[@shugatlarge]

Brilliant! Many thanks, your work around with the second List Rows Present in Table was exactly what I was struggling with!

[@ON-pv2mn]

Thank you so much! I subscribed straight away! Disregard those Dislikes, you are a life saver! Please record more content like this for Power Automate (and Power Apps maybe?!). Thanks again, you rock!

[@PowerGI]

Hi there! You are amazing, thanks SO much for your comment, really made the day! I really appreciate you leaving such a kind comment, can't thank enough! Will try to keep creating content!!! (and improving quality too!). Thanks a lot again, and thank you for subscribing!!

[@NYXthetherian11]

my goodness!!! i have been looking for this solution for so long!!! Thank you so much Madam!!!!

[@PowerGI]

Thanks so much for your comment!

[@c.mdsalih]

Very useful! Thanks for the tips :)

[@vc5940]

you are a life saver! Thank you so much

[@eduardoperez6345]

Thanks so much for this, I love the (list rows present in table 2) trick!

[@PowerGI]

Hi Eduardo, thanks so much!

[@PuellaMagiHomuraAkemi]

@@PowerGI I dont know if you saw my previous comment but I figured it out myself. Your video really helped me at work

[@moadbouzida6693]

I love you :) , you solved a 2 days issue I had . Thanks a lot

[@fernitudeladev]

thanks for the Video!! you helped me a lot

[@Trindade1988]

Amazing, thank you so much !!!

[@MarkGuercio-f7z]

Hi! Thank you for sharing this awesome video. Is it possible to apply a Filter Array on the List Rows Present in a Table results prior to writing out to a different able name? How would I refer to the field names for a dynamic file name in a Filter Array card?

[@lakshitjain225]

That is so helpful, your a life savior, thank you so much :-)

[@fabiofilho7660]

Very useful! Thanks!

[@andresaguilar9979]

Subscribed too. Thanks

[@pandoratokar7731]

Is the video available? I need to update dynamic excel file

[@AvdhutVaidya]

I need to use "Update a Row" and should provide file name at run time. I know I need to use "Provide the item properties" box with Json format to update this. The problem is I am not able to pass the name of my file in a variable. It fails with error "The parameter 'file' has an invalid value >>fileName

[@PowerGI]

Hi there! Try using a similar work around as shown in the vid. Before the Excel Update a row card, Use a card to get the file properties by passing the dynamic path of the file that you have and that card will have the file ID as part of the output. Use this id in the excel card. Hope this helps!

[@AvdhutVaidya]

@@PowerGI you are right, this seems to wrk.. what i used is "List files in folder" component of One Drive group and i'm now looping over the files and using the id now.. i think the ice is breaking - just need to refine it for my exact purpose.. will keep posted here.. Thank you for your inputs :-)

[@PowerGI]

@@AvdhutVaidya awesome!! Glad it helped! Let me know if you are able to make it Work!

[@AvdhutVaidya]

@@PowerGI Thank you for your close follow up - a quick update - it is failing to list the files if i give folder path using some string variable or even a typed folder path; same works if i CHOOSE this same folder path using Power Automate's folder selection box.. i'm searching fix for this now and will keep posted here

[@PowerGI]

Hi there! Were you able to make it work?

[@jpwilliams2795]

LOVE IT!!! THANK YOU!!!

[@PowerGI]

Thanks so much for your comment!

[@nicholsodes3621]

Hi! A great tutorial video as it helped me get closer to my needed logic, however there is still a scenario that I didn't quite see in your video that I was hoping you could help me with as I haven't been able to find anyone with advice or tutorials anywhere for it. When you need to use the Update a Row action for a dynamic file name, and then use the concat feature described in your video for the Table, it expects a schema to be provided in the "Provide the item properties", however nothing i have entered in that has led to the table in my excel file getting updated with the required updated value. How should i structure those properties for the purpose of updating 1 specific field in a table of the dynamically named file? Obviously if i choose a specific .xlsx file as shown in your example, then I am able to choose the table and corresponding field, but once i change the file to a dynamic value, my only option is the properties schema. I am desperate for help on this!! Thank you!

[@PowerGI]

Hello! You can have a look at this post: powerusers.microsoft.com/t5/Building-Flows/Updating-an-excel-sheet-which-is-a-subject-of-my-Flow/m-p/528349#M67975 You need to pass { "columnName": value, "columnName2":value} etc Hope thsi helps!

[@PowerGI]

Hello! You can also have at this new video I have just uploaded kzbin.info/www/bejne/h3m8XnanisqniJo

[@nattanan9568]

Hi :) If i need to input data into excel dynamic (Using add row) add row into a different file. Do you have any idea how to do this? Thank you so much

[@PowerGI]

Hi! A bit late but here is a vid how to do this: kzbin.info/www/bejne/h3m8XnanisqniJo

[@marioscarabelli9380]

Hello Power GI, thank you for this video which helped me... maybe. :) My flow gets triggered when a file is created on sharepoint. As the data is not yet in a table format I create a table first. I can retrieve all the data later with "list rows present in table". so far the flow is working as in the video but then I have issues with reusing the tables' content or these rows to update/transfer it into an existing sharepoint list. any advice?

[@PuellaMagiHomuraAkemi]

I have the same issue, I need to use the tables content to update/transfer it into an existing sharepoint list

[@fernandosantello3803]

Amazing work! Thank you so much! Can we write into a Dynamic file? Like the other way around. Always get data from the same table, but write into different ones.

[@PowerGI]

hi there Fernando! and thanks so much for dropping a comment :). That is actually the next video we're building for now, but it may take sometime to be available, if you have an specific use case or example you can email me to see if I can help. My email is [e-mail]. Happy automating!

[@fernandosantello3803]

@@PowerGI I'll send one now! Thanks for the support and keep up the awesome work!

[@herrmann5384]

Thanks so much :)

[@MohammadAli-ts2ev]

Hi, Thank you for the informative video, Can you plz help creating a path of the excel online (for business) filtered table? Scenario - I have a table on excel online file and I want to send that path of the file to different people having their tasks in the table. What I want is - When they click the link they can have their records filtered (auto application of filter using path) In other terms...I want the table to be filtered with the email id of every individual when they click the link. If it's possible, plz guide me through the steps