Unanswered

Adding conditions and variables to flow

(1) Share

Report

Posted on by M3vswrld

I'm sure this question has been asked but I'm having trouble locating an answer applicable to my situation. My team and I are using Forms to generate data into Excel tracking case updates. I'm attempting to add a condition/variable to my flow to update existing rows for Reg numbers that are already in the table, while still allowing new rows to be added if a new Reg number is added. If someone can share a step-by-step that would be very much appreciated.

All responses (2)

Answers (0)

M3vswrld 4 on at

Like (0)

Report

Re: Adding conditions and variables to flow

I only used one condition and added variables. Reg num is not equal to null- if yes, update row, if no, add row. Then I went further to add more variables to say, if the form field is blank keep input in table. It was definitely a brain tease, but I had help from a very smart co-worker.
trice602 13,817 Super User 2025 Season 1 on at

Like (0)

Report

Re: Adding conditions and variables to flow

Hi @M3vswrld ,

I found a solution I wrote awhile back that is really close to your scope of work. Here's the flow.

My first condition (which may not be applicable to yours, is to check if one of the form answers was Supplier. I'm going to describe all the steps even if they don't specifically match yours so you understand the entire flow. But I do cover update a row or add a row...

Let's assume that the form response was Supplier, so on this side of the conditional block, I have this group of actions. Here I want to check if the company name is already in my excel sheet. So the first action is to list rows present in a table (I want all rows).

Next in my Condition 2 action, if the form response question Enter your company name = the excel column "Company Name" ...

I will update a row or if not found, add a row.

Now, on the Update a row action, you need to specify a Key column. I used Company name. From here, it's just populating both actions with the dynamic content from your Get responses action, shown below.

To summarize, you don't need the first conditional action that has the "Supplier", you would not need that one. Your conditional action to check Regs numbers would go where I check the company name (Condition 2).