cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Excel Formula is autocorrecting

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Excel Formula is autocorrecting

Hi @Luigi_certo,

 

Could you please share your Flow configuration and the function in the Excel table?

 

Best Regards,
Community Support Team _ Lin Tu
If 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

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Excel Formula is autocorrecting

Hi @Luigi_certo,

 

Could you please share your Flow configuration and the function in the Excel table?

 

Best Regards,
Community Support Team _ Lin Tu
If 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

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (9,656)