Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Building Flows / How to update an excel...
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

(2) ShareShare
ReportReport
Posted on by Patricia11 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.
 
Categories:
Business Process Flows
  • Verified answer
    Patricia11 Profile Picture
    Patricia11 13 on at
    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 26,301 on at
    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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 141,122

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,414

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans