Answered

How to update an excel row if a condition is met and add an excel row if a condition is not met

(3) Share

Report

Posted on by Patricia11

Hello all,

I am trying to build a flow that updates an Excel row when the "quote number" field in an Excel spreadsheet on SharePoint is blank, and adds a row when it is not blank.

If I set the "Condition" as shown below, the row will be updated or added regardless of whether the quote number field is blank or not.

In the case of condition A: empty(triggerOutputs()?['Quote Request Number']
The row will be updated whether the quote number field is blank or not.

In the case of condition B: empty(outputs('Substring quote request number')?['body'])
The row will be added whether the quote number field is blank or not.

Could you please tell me if there is a solution?
Thank you in advance.

condition A: empty(triggerOutputs()?['Quote Request Number']

The row will be updated whether the quote number field is blank or not.

condition B: empty(outputs('Substring quote request number')?['body'])

The row will be added whether the quote number field is blank or not.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Michael E. Gernaey 53,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am not sure I know what the question is or the problem spot to help.

Was this reply helpful? Yes No
Verified answer

Patricia11 13 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for your reply. I apologize if my explanation was difficult to understand.

The problem was that even though I set conditions, the rows in Excel were updated or new rows were added regardless of the conditions.

I solved the above issue myself.

I added "Get Rows" above "Conditions" and re-set the "Conditions", and the following flow was successful.

-If the quote number is blank, update the row in Excel.
-If the quote number is not blank, add a new row to Excel.

Was this reply helpful? Yes No