I have create a flow to update a specific row inside of excel when a new form response is submitted and the flow is working. However, I am still getting these errors in the flow, see below:
Could someone please assist?
The Apply to each 2 action shows that you have two items which you are updating.
Can you click either Next Failed or Next to see if the Update a row for the second item failed and with which error?
I just finished testing this flow again after I redesigned it and it appears to be working now:
Here is the issue that I am seeing now, when a user fills out the MS form and does not select any content in a certain section of the form, the excel sheet updates those specific rows to be blank instead of leaving the old content. Is there any way around this? I found the if() formula, but I do not know how to use it.
Thank you for any assistance!
Thank you for a quick response! I have 2 questions: where inside of the flow would this go? I have never used this function before. Also, do you have an example of how the formula would look in this case?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.