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

Use multiple forms to create/update a single excel spreadsheet row

(0) ShareShare
ReportReport
Posted on by 1

Hi all

Currently we have four project related actions with associated forms.

  1. Proposal/setup
  2. Win
  3. Loss
  4. Closure
  5. Amend/Add

I would like data for every project to be stored on a single worksheet.

Data for each project to be contained in a single row.

Form 1 would create a row for each new project and input data to the relavent sections specified in the form [that correspond to column headings]

Forms 2, 3, 4 & 5 would update the data in the row that corresponds to the project number with data that matchess column headings specified.

Each time an action is completed on the spreadsheet using one of the four forms an alert is sent to the owner of the spreadsheet.

 

I am can create a basic forms to excel flow, its the next steps that I'm struggling with.

 

Many thanks 

I have the same question (0)
  • Unknown geen idee Profile Picture
    1,757 on at
    Re: Use multiple forms to create/update a single excel spreadsheet row

    Dear W,

     

    Looks like a fun process flow.

     

    I hope I could make a few suggestions ... if I were to create this, I would not try to 'update' the same file with all kind of input. I would record all the updates as they come in. Likely I would create 2 tables:

    • Table 1 would include all the updates from all the different forms. As such you will have a complete history of all the input your have received. See it as a transaction record.
    • Table 2 would hold the most updated project details as destilled from Table 1. Based on some logic, likely based on latest date or something like that. Table 2 does not really need to exists, you could create this dynamically at any time.

    BTW, I suspect your problem lies at identifying which row you should update and when. If you really want to update just 1 row you would have to do this by creating a unique identifyer for the row. In your case this would likely be a project ID or something like that. In your form output you include this ID such that you know which row to update.

    In addition, you will likely have to include some date field per data element in the row such that you can track when the update was ... one of the main reasons why I do not recommend trying to do all of this in 1 and the same table.

     

    Hope the suggestions help,

    Happy flowing,

    Koen

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 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard