News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps IF STATEMENT IN POWERAPPS

Power Apps - Building 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

All responses Img

All responses (3)

Answers Img

Answers (0)

mmbr1606 12,121 Super User 2025 Season 1 on at

Like (1)

Report

Re: IF STATEMENT IN POWERAPPS

can u tell us what the exact issue is that you are facing?
kritika26 25 on at

Like (1)

Report

Re: IF STATEMENT IN POWERAPPS

still its not working
AndrewR1 1,572 Super User 2025 Season 1 on at

Like (1)

Report
Re: IF STATEMENT IN POWERAPPS

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