If Condition formula on 2 fields

(2) Share

Report

Posted on by Prem4253

650

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)

All responses (4)

Answers (1)

realwillwright 772 Moderator on at

Like (2)

Report
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 &&

Was this reply helpful? Yes No
Prem4253 650 on at

Like (1)

Report

If Condition formula on 2 fields

Hi,

Though the Date field is blank, it still returns Completed.

Was this reply helpful? Yes No
WarrenBelz 152,843 Most Valuable Professional on at

Like (2)

Report
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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,843 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No