Filter Gallery

Like (0) Share

Report

Posted on 18 Nov 2021 11:13:08 by Robertjde

390

Hello everyone

I have a gallery with SP List database.

I would like to filter these according to several factors.

In terms of status, my SP list contains "open, in progress, done".
The gallery should only show the "open, in progress".

My formula:

Filter(
 'Mangelkarten App Data';
 StartsWith(
 Abteilung;
 "XYZ_Abteilung"
 );
 StartsWith(
 Linie;
 LabelLinie.Text
 );
 StartsWith(
 Status;
 "in Bearbeitung";"offen"
 )
)

Where is the mistake???

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

WarrenBelz 149,147 Most Valuable Professional on 18 Nov 2021 at 11:23:27

Like (1)

Report
Re: Filter Gallery

Hi @Robertjde ,

I assume I have the translation correct here

Filter( 'Mangelkarten App Data'; StartsWith( Abteilung; "XYZ_Abteilung" ) && StartsWith( Linie; LabelLinie.Text ) && ( Status = "in Bearbeitung" || Status = "offen" ) )

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.

Visit my blog Practical Power Apps