web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps IF STATEMENT IN POWERAPPS

Power Apps

Unanswered

IF STATEMENT IN POWERAPPS

(1) Share

Report

Report

Posted on by kritika26

25

If(

!IsEmpty(

Filter(

'WFH Form Info',

Title = ThisItem.Title &&

DateValue(_dateSelected) >= DateValue(WFrom) &&

DateValue(_dateSelected) <= DateValue(WTo) &&

WStatus.Value = "Approved"

)

),

"Work From Home",

!IsEmpty(

Filter(

'Leave Form Info',

Title = ThisItem.Title &&

DateValue(_dateSelected) >= DateValue(StartDate) &&

DateValue(_dateSelected) <= DateValue(EndDate) &&

Status.Value="Approved"

)

),

"On Leave",

"In Office"

)

ON LEAVE IS NOT COMING IN GALLERY

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

AndrewR1 1,572 Moderator on at

Like (1)

Report
Hi @kritika26 try this:

If( !IsEmpty( Filter( 'WFH Form Info', Title = ThisItem.Title && DateValue(_dateSelected) >= DateValue(WFrom) && DateValue(_dateSelected) <= DateValue(WTo) && WStatus.Value = "Approved" ) ), "Work From Home", If( !IsEmpty( Filter( 'Leave Form Info', Title = ThisItem.Title && DateValue(_dateSelected) >= DateValue(StartDate) && DateValue(_dateSelected) <= DateValue(EndDate) && Status.Value = "Approved" ) ), "On Leave", "In Office" ) )

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No
kritika26 25 on at

Like (1)

Report

still its not working

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

can u tell us what the exact issue is that you are facing?

Was this reply helpful? Yes No

Join the conversation