Unanswered

Flow for searching excel column, update row or add row

(0) Share

Report

Posted on by LB-13011934-0

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
LB-13011934-0 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you show me what you have in the Response Id field in the get response details action?

Make sure you have selected the dynamic content (Response Id) from previous action.

Best regards

Was this reply helpful? Yes No