Use "in" or "exactin" with numbers

(0) Share

Report

Posted on by ThD7

Hi,

Here is my code :

SortByColumns(
 Search(
 Filter(
 'Liste membres';
 ID in LookUp('Liste d''inscrits par sorties';
 DateValue(Date) > DateValue(Today())
 ).Title
 );
 TextSearchBox1.Text;
 "{Name}";"Pr_x00e9_nom"
 );
 "{Name}";
 If(SortDescending1;Ascending;Descending
 )
 )

With 'Liste membre' = {ID;Nom;Prenom,Title...} and 'Liste d'inscrits par sortie'={ID membre, Date}.

In liste membre, ID = 0 for row 1; 1 for row 2...

In liste d'inscrits par sortie; ID membre = 0;1;3;15... for row 1, 0;37;18... for row 2 etc.

I want to search every row where ID appears in ID membre, the issue is that for powerapps 1 in 13 is true for example, so 1 in 0;13;16 is true too, unlike with text data.
What could I do to make 1 in 0;13;18 false ? (With 1 in 0;1;16 true obviously)

I think I should use "=" instead of "in" but I cant figure out how (I tried splitting and then ForAll but Filter doesn't appreciate).

Thanks

Categories:

Building Power Apps

I have the same question (0)