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 Automate - Building Flows
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.

I have the same question (0)
  • Srini007 Profile Picture
    3,283 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard