Filtering PowerApps Data Source

(0) Share

Report

Posted on by RUSH123

Hi,

I am trying to create an app for when our pool car is booked out.

I am trying to get the app to show only Approved and Awaiting Approval items as we have a Status column on the list we are using however the app is currently showing all data.

SortByColumns(Filter([@'Pool Car Booking'], StartsWith(Title,TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

What is the best way to set the app so it only shows approved and awaiting approval.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

LRVinNC 2,297 on at

Like
a
(1)

Report
Copy link

Link copied!

You need a compound condition in your filter. It should look something like:

SortByColumns(Filter([@'Pool Car Booking'], StartsWith(Title,TextSearchBox1.Text) && (Status = "Approved" || Status = "Awaiting Approval")), "Title", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No
RUSH123 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for getting back to me! When I enter that text it returns no data but I do get errors regarding invalid argument type browsegallery1.items

Thanks

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

What data type are you using for your Status field?

Was this reply helpful? Yes No
RUSH123 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Complex - it is a drop down menu on the SharePoint list and PowerApp.

Cheers

Was this reply helpful? Yes No
Verified answer

LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

Try:

SortByColumns(Filter([@'Pool Car Booking'], StartsWith(Title,TextSearchBox1.Text) && (Status.Value = "Approved" || Status.Value = "Awaiting Approval")), "Title", If(SortDescending1, Descending, Ascending))

If that doesn't work, please include a screen shot of your column definition in Sharepoint.

Was this reply helpful? Yes No
RUSH123 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect - Thank you very much!

Was this reply helpful? Yes No