Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Flow for searching excel column, update row or add row

(0) ShareShare
ReportReport
Posted on by 2
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.
  • narayan225 Profile Picture
    narayan225 2,390 on at
    Flow for searching excel column, update row or add row
    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
  • LB-13011934-0 Profile Picture
    LB-13011934-0 2 on at
    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. 
  • narayan225 Profile Picture
    narayan225 2,390 on at
    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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard