web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need to change variabl...
Power Automate
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.
Categories:
I have the same question (0)
  • Artur Stepniak Profile Picture
    1,539 Moderator on at
    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!
  • AP-23120700-0 Profile Picture
    2 on at
    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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 307 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 269 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 115 Super User 2026 Season 1

Last 30 days Overall leaderboard