How to filter data table with SharePoint list as source

Like (0) Share

Report

Posted on 5 Apr 2024 22:34:22 by djurecicK2

Hello All,

I am new to Power Apps and am trying to filter a data table. Below are screenshots of the unfiltered table which works fine. The source is a SharePoint list called "Leave Request".

Here is how I am trying to filter the table, but this results in no records found. Note that the column "Status" comes from source column called "Request Status"

Filter('Leave Request',"Request Status"= "Submitted")

Thank you for any help you can provide.

-DJ

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

WarrenBelz 148,896 Most Valuable Professional on 05 Apr 2024 at 22:45:22

Like (1)

Report
Re: How to filter data table with SharePoint list as source

Hi @djurecicK2 ,

Single quotes around the field name

Filter( 'Leave Request', 'Request Status' = "Submitted" )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps