Unanswered

'Content approval status' eq Pending

(0) Share

Report

Posted on by Shariq_h

Filter('<DataSource>', ('Created By'.Email=User().Email) && ('Content approval status' = Pending))
The above Filter is not working when trying to filter in Power aap. Gallary Item Filter.
Can any one help.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

SebS 4,582 Moderator on at

Like (1)

Report
Hi @Shariq_h

If the 'Content approval status' column is a choice column

Filter( '<DataSource>', 'Created By'.Email=User().Email, 'Content approval status'.Value = "Pending" )

But if it's not

Filter( '<DataSource>', 'Created By'.Email=User().Email, 'Content approval status' = "Pending" )

Was this reply helpful? Yes No
Shariq_h 8 on at

Like (0)

Report

Thanks for your response.
When I am trying to get the information in the text field it is proving the information without any filter.

In the data source, I am using a share point list: "Require content approval for submitted items? = Yes"
In the Power app I want to list the SharePoint Item where approval is pending.

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
@Shariq_h

So for Your scenario it should work the only issue You will have 'Content approval status' is classed as complex Type column and You will have Delegation warning what means You need increase Delegations from 500 to 2000 in Your app settings and if Your list will grow above 2000 records You will not be able to see records above 2000

Filter( DataSource, 'Created By'.Email = User().Email, 'Content approval status' = "Pending" )

Was this reply helpful? Yes No
Shariq_h 8 on at

Like (0)

Report
When trying with the below Filter it is showing data in Gallery.
Filter( DataSource, 'Created By'.Email = User().Email )

But with the below noting showing in the Gallery.

Filter( DataSource, 'Created By'.Email = User().Email, 'Content approval status' = "Pending" )

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
@Shariq_h

Can You check if you change Pending for Approved anything show up maybe You do not have any Pending records for that user

'Content approval status' = "Approved"

Do You have any errors showing up when You use the code ?

Was this reply helpful? Yes No
Verified answer

SebS 4,582 Moderator on at

Like (1)

Report

@Shariq_h

I run it on my Test App and it's filtering

Here with Approved

Was this reply helpful? Yes No