Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Need to change variable according to conditions of cell

(0) ShareShare
ReportReport
Posted on by 2
I am building a flow in which, I want to send a schedule email to my supplier for purchase of good for my 3 factory located at different locations.
 
I am following logic as below. 
 
Logic 1:- Check Live inventory < Minimum inventory, [True- Send Email] , [False- Do Nothing]
Logic 2:- Use Or Logic for 3 location, as data lying in one row.
Logic 3:- Draft email body with respective Supplier Email, Supplier Name, Minimum Order Qty.
 
 
Problem statement 
 
 Minimum Order Qty  in email body will change according to logic as follow.
 
Live inventory < Minimum inventory, [True- Put vale of{Minimum Order Qty}] , [False- Put {0}] in email body.
  • AP-23120700-0 Profile Picture
    AP-23120700-0 2 on at
    Need to change variable according to conditions of cell
    Dear Mr. Artur Stepniak,
     
    Thank you for paying attention and replying on my issue.
     
    I am just stared with power automate, and not aware about the expression. 
     
    I want an expression like if condition is true, (Minimum Order Qty  * 1), False then (Minimum Order Qty  * 0) and result will be feed in to email body. 
     
    But I am not able write the code.
     
    Can you please help me for the same.
     
    It's grate if you can share related YouTube Video or blog.
     
    Have a productive day.
     
    Best Regards
    Akshay Pate
  • Artur Stepniak Profile Picture
    Artur Stepniak 1,238 on at
    Need to change variable according to conditions of cell
    Hello,
     
    what's your problem? You don't know how to write an expression for this condition?
     
    Best regards,
     
    Artur Stepniak
    Interested in GenAI? Visit my site!

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

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard