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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - AI Builder / If Condition formula o...
Power Apps - AI Builder
Answered

If Condition formula on 2 fields

(2) ShareShare
ReportReport
Posted on by Prem4253 549
Hello,
 
I've a SharePoint list connected to Power Apps. There are 2 fields (EHS No. and Received Date), on which I need to apply If formula in a field called Status.
 
If in EHS field, if we have a No. return text as Completed and if blank return In Progress.
 
Similarly if we have a Date in Received Date, return text as Completed else return In Progress.
 
Thanks!
Categories:
AI Builder
I have the same question (0)
  • realwillwright Profile Picture
    realwillwright 772 Moderator on at
    If Condition formula on 2 fields
    Hi,
     
    Assuming I've understood correctly you should be able to do it like this. It first checks for values in the EHS field and Received Date for blank. If they are both blank it sets the value to 'In Progress' else it sets it to completed.
     
    If(
  IsBlank(EHSField) && IsBlank(ReceivedDate),
  "In Progress",
  "Completed"
)
    If I have it wrong and you need them separate, you can just take out one of the IsBlank() functions with &&
  • Prem4253 Profile Picture
    Prem4253 549 on at
    If Condition formula on 2 fields
    Hi,
     
    Though the Date field is blank, it still returns Completed.
     
  • WarrenBelz Profile Picture
    WarrenBelz 151,881 Most Valuable Professional on at
    If Condition formula on 2 fields
    Hi Prem4253 
    Assuming DataCardValue21 is a Text Input, try this 
    If(
   Len(DataCardValue21.Text) = 0,
   "In Progress",
   "Completed"
)
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee
     
  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 151,881 Most Valuable Professional on at
    If Condition formula on 2 fields
    Just following up to see if you received the answer you needed, or if you require further assistance.

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 663 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 398 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 235

Last 30 days Overall leaderboard

Featured topics

Question for everyone : How are you using Create Text GPT in AI Builder?

Product updates

Microsoft Power Platform Community release plans