Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

Like (2) ShareShare
ReportReport
Posted on 10 Sep 2024 09:03:45 by 13
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.
 
  • Verified answer
    Patricia11 Profile Picture
    Patricia11 13 on 13 Sep 2024 at 04:33:15
    How to update an excel row if a condition is met and add an excel row if a condition is not met
    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.
  • Suggested answer
    FLMike Profile Picture
    FLMike 29,371 on 10 Sep 2024 at 23:15:27
    How to update an excel row if a condition is met and add an excel row if a condition is not met
    Hi,
     
    I am not sure I know what the question is or the problem spot to help.

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,411

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,328

Leaderboard
Loading started