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 / Add AND update row in ...
Power Automate
Unanswered

Add AND update row in Excel from Jotform

(0) ShareShare
ReportReport
Posted on by

Hi, I have a flow that adds a row to an Excel table from a jotform submission. But that form then can be edited with additional information added. How can I then update the row in Excel? The closest I've gotten just adds a new row with the complete information but then I have 2 rows for the same submission, one complete, one half complete. Is there a way of replacing the half completed row or deleting it, thereby just leaving the complete one? They have a unique ID.

Categories:
I have the same question (0)
  • Srini007 Profile Picture
    3,323 Super User 2025 Season 2 on at
    Re: Add AND update row in Excel from Jotform

    Hi @DEBS1644 

     

    Once the response is submitted, then you can use Get Row action where you need to pass the unique ID

    So, you need to place a condition that if that finds a row in the excel go to update a row or else go to Add a row in table

     

    For reference, check below post

    https://powerusers.microsoft.com/t5/General-Power-Automate/Updating-a-row-in-Excel-using-Forms-and-Power-Automate/td-p/802975

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Thanks,

    Srini

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