web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Forms to Excel to Add ...
Power Automate
Unanswered

Forms to Excel to Add or Update row based on duplicate value

(0) ShareShare
ReportReport
Posted on by 6

Hi, I am trying to create a flow to update a registry where if a serial number entered on the Form already exist in Excel it will update the row and if serial number doesn't exist in Excel it will add a new row. My problem at the moment is I can't add Control without Flow automatically adding "Apply to each" so when I run the flow, it will keep adding a new row as many time as the total number of serial number that already exist in Excel.

Categories:
I have the same question (0)
  • Verified answer
    v-mingkz-msft Profile Picture
    Microsoft Employee on at
    Re: Forms to Excel to Add or Update row based on duplicate value

    Hi @AndreJo,

    Do you want to add a new row to Excel table if serial number doesn't exist in Excel, and update a row if serial number exists?


    I did some tests according to your requirements.
    Please try:

     

    vmingkzmsft_0-1686806167076.png

     

    vmingkzmsft_1-1686806208442.png

    vmingkzmsft_2-1686806283521.png

     

    vmingkzmsft_3-1686806352994.png

     

     

    Best Regards,

    Kyrie

     

     

  • AndreJo Profile Picture
    6 on at
    Re: Forms to Excel to Add or Update row based on duplicate value

    Hi @v-mingkz-msft,

     

    Thanks for the quick response.

     

    I am getting this error below. Not sure if there is a step that I miss?

     

    AndreJo_0-1686864957180.png

     

    What is the output selection for "Apply to each"?

     

    Regards,

    Andre

  • v-mingkz-msft Profile Picture
    Microsoft Employee on at
    Re: Forms to Excel to Add or Update row based on duplicate value

    Hi @AndreJo,

    Please select the List of responses to the input of Apply to each.

    vmingkzmsft_0-1686884770823.png

    Best Regards,

    Kyrie

     

  • AndreJo Profile Picture
    6 on at
    Re: Forms to Excel to Add or Update row based on duplicate value

    Thanks @v-mingkz-msft!

     

    Flow is working perfectly now.

     

    Regards,

    Andre

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard