Answered

Filter a gallery by list value

(0) Share

Report

Posted on by ademboski

Hello, I have an app connected to a sharepoint list. The data source is called 'Call Log'. My goal was to filter off any records where the status <> Completed, but my existing filter statement is only hiding the values, not preventing the entire record from appearing, which is where my request comes in.

In this example, the Items formula is clearing the Title field and the progress field only. Is there a way to have this entire record removed from a filter?

SortByColumns(Filter([@'Call Log'],'Progress'.Value<> "Completed" && StartsWith('Company Name', TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Without filter applied:

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ademboski ,

Silly question but have you tried your formula in Preview? Normally, if you are in edit mode, your custom text will be displayed anyway. Once "Play" button is pressed it should disappear.
Can't see any issue with your code.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
ademboski 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh my goodness.... insert feeling of shame I hadn't tried that... lol. It worked as expected in play mode. Thank you for your suggestion!