Good morning I'm trying to automatize a weekly report.
The automation of the flow take the informations from dynamics 365 source inside an excel file.
Everything works well if you need to insert raw data inside the excel file.
The big problem starts when you need to use functions in the excel.
Indeed every time the flow has run I can see that all the calculted columns (=FUNCTION(...)) gets autocorrected.
The ending situation is a list with all the different datas but with the same hyperlink.
I know that the problem is excel related because checking the flow I can see that they hyperlinks gets populated correctly with different values.
Can you help me figuring out the solution to this problem? did you ever encountered something like this?
Go to Solution.
Could you please share your Flow configuration and the function in the Excel table?
Best Regards,Community Support Team _ Lin TuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
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!