I'm rather new to Flow and this community. I was wondering if anyone could help me with this issue.
I have around 76 workbooks located in a personal OneDrive. Here are the steps i need to perform
I tried using Power Query initially, but i keep getting an error saying that my credentials do not allow that type of URL. I can't use PowerBi as my credentials won't let me do it (i'm a contractor btw).
ANy help will be gretly appreciated! I've been racking my brain for the past 3 days with this. Also if you can provide a step by step guide that would be awesome, I'm a total newbie when it comes to this (this is my first time ever being exposed to Flow). Thank you!
Could you please share a bit more about your Excel files?
I have created some Excel files on my side and the data structure of it as below:
The folder structure of my OneDrive folder as below:
I have made a test on my side and please take a try with the follwoing workaround:
Start Time field set to following formula:
End Time field set to following formula:
Executor field set to following formula:
Note: The PerojectName, Start Time, End Time and Executor are all columns in the Excel table of my Excel files. On your side, you should type the following formula to reference the column values within your Excel table:
If there is a space within the column name, please replace the space with '_x0020_'.
The flow works successfully as below:
More details about using expression in flow actions, please check the following formula:
Hi Kris (@v-xida-msft)
I tried your flow but once i got it to finish running i got these results:
This is what i put in the action
ALso i just got new requirements and i was hoping you can help me again.
THank you so much for the help @v-xida-msft!
Thank you for posting to the Microsoft Flow Community forums! I see that in one of the above replies you were offered a solution to your issue! If you feel that the reply offered an applicable and satisfactory solution, please click "Accept as Solution" so that other users can find this information and utilize it easily!
Flow Community Manager
Join us for the first ever Power Platform Online Conference!
Keep your eyes open for our upcoming T-shirt design contest!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!