Answered

Sort and filter a Gallery

(0) Share

Report

Posted on by Waterblikje

Hi, Im building an app for my company. For this app i want to buid a search function for a gallery. This gallery needs to be sorted on the date with sortorder decending. The filter part for searching contains an Or function to let me search in 4 different columns. I tried some formulas but can't get it to work. Anyone who can help?

Sort(
 Filter(
 Goodcatch;
 Or(
 Searchbar_excel.Text in 'Oorzaak afwijking';
 Searchbar_excel.Text in 'Genomen actie';
 Searchbar_excel.Text in 'Naam melder';
 Searchbar_excel.Text in Datum
 )
 );
 Datum;
 SortOrder.Descending
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Waterblikje

That's not a delegable query (assuming Goodcatch is a table and not a collection).
What isn't working?
Is there an error?

Was this reply helpful? Yes No
Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Waterblikje (fellow Dutch memeber) 😉

In your case the Search function is more useable.

The Search function finds records in a table that contain a string in one of their columns.

Search(Table*, SearchString, Column1 [, *Column2*, ... ] )

The code would look like:

Sort( Search( Goodcatch; Searchbar_excel.Text; "Oorzaak afwijking"; "Genomen actie"; "Naam melder"; "Datum" ); Datum; SortOrder.Descending )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

HI @Waterblikje,

If you want to search in 4 different columns, you must make sure that all of the 4 columns are Single-line-of-text column.

Was this reply helpful? Yes No