I am attempting to make a flow that will take Microsoft form responses and check an excel sheet to see if a phone number is already present. If so, update the corresponding row with the current form responses. If not then add a row.
Very new to Automate so this may be a simple fix but I am not knowledgeable enough to know how to fix this. Any help would be appreciated.
This is the flow as I have it setup.
This is the error I get when testing the flow, and the addition of an Apply to each.
Flow for searching excel column, update row or add row
This is where I am at now. I have tried reconnecting with a new action for getting the responses but each time I test the flow it gives the BadRequest error.
Flow for searching excel column, update row or add row
Based on your flow, it seems like you want to get all the responses submitted in a form and then search for the phone number for each submission.
If you are trying to do that, you will need to put the rest of the actions inside the Apply to each condition. The error says that you are trying to compare the phone number value for all responses at once and that won't work.
If you are supposed to do it one by one, you will need to Trigger it by form submission and get response for that submission instead of all submissions.
Like this:
After that you can search your excel file based on the user response without any issues.
Hope this helps.
Cheers!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.