Filter for Approval Status

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Masters,

I have some difficulty to do filter for approval status.

I want to show only approved item in the screen.

this is the code that im use now but its not working :

Filter('hardware list', 'Procedure Approved' = 'Approved')

image as attached for more detail of my status approved.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is the screenshot of the sharepoint list

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous
Hello there. I do not see any image attached to this post.

Is your Status a Choices type field in SharePoint? If yes, then please try this code instead 🙂

Filter('hardware list', 'Procedure Approved'.Value = "Approved")

Or maybe you just forgot the double quotes around Approved if it is a text field in SharePoint.

Filter('hardware list', 'Procedure Approved' = "Approved")

--
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(2)

Report
Copy link

Link copied!

Try:
Filter('hardware list', 'Procedure Approved'.Value = "Approved")
or
Filter('hardware list', 'Procedure Approved'= "Approved")
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Yes it a choice.

I already tried with .value and without.

unfortunately issue still there.

let me share you the code from the PowerApps so perhaps you can have some better understanding.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Do you want to combine both of those conditions? Here's how to do it.

Filter('hardware list', analyst.Email=User().Email, 'Procedure Approved'.Value = "Approved")

And please, change 'Approved' to "Approved" with double-quotes

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sir!

Yesss it's working now!

im forgot to put "Approved" instead just using 'Approved'

thanks a lot for this.

Next, I already have a filter for user.

I tried to combine it in one place as showing in the code.

but it's not working.

Any idea on this sir?

Really appreciate your help on this!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It's working now with the combination!

you all are the best.

Thanks a lot!!! 😄

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous
Please combine it like this instead. You can only have 1 Filter function in the Items property.

Filter('hardware list', analyst.Email=User().Email, 'Procedure Approved'.Value = "Approved")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No