Is there a way to use write a function in excel from flow? I try to use the function "=ROW()-1", but it does not automatically result in the row number. Instead, the excel sheet gives me the error "#NAME?". As you can see in the picture, the function is written correctly (In Norwegian), and when I go in manually, select one cell and press enter, all the error messages are fixed, as you can see in the second illustration.
When I manually activate the functions, I can use the integers for further calculations in Flow. This does hower not happen without me manually activating it.
This is a problem as I want to use the resulting value for further calculations in Flow. In Flow, I add the function using the "Add a row into a table" block illustrated below. The added value inside the red ring, is a string variable illustrated in the second picture below.
Can someone help me with this, making my functions run automatically in excel?
According to this post, one year ago the scenario you want to deploy was not supported
Let's hope somebody else can point us to the right direction, in case it is currently supported
Hope this helps
Thank you for the answer! Hopefully there is a way, or maybe they are working on it. Functions in Excel are superb.
I am also having the same problem, I need the flow to insert the function = TODAY (), however when triggering the flow, excel presents the error #NAME?
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.