cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmb470
Regular Visitor

Updating Excel Sheet from forums based on two characteristics

Hi, 

I am new to Power Automate and I am having some trouble.

 

I have made a survey and I would like to be able to update the responses based on "feeder id" number and the "date of failure", however my flow currently just adds a new row for each response despite there being duplicates. So for instance, if someone fills out the form and puts the id number as 4567 and the date of failure as 01/02/03 (the issue is that the feeder id numbers are not unique, so I also need the date in order to confirm that the person wants to update an entry rather than add a new entry with the same "feeder id" number).

I have tried to use some of the other posts on forums to help but nothing seems to work. I was focusing on just trying to get the sheet to update based on "feeder id" at the moment and I have attached pictures of what I have so far, but ideally I would also like to add the "date of failure" constraint as well.

Thanks so much pic 1.png

 

pic2.png

 

0 REPLIES 0

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,182)