Hello
I'm actually working with a SharePoint List used as the "library"of spare parts for my work.
Actually more than 3000 rows.
I need to filter this table to get only the parts wich are used for a specific machine.
So, in the list, i have a first column with multiple choice to select wich machine are concerned by the part.
As filtering is not working with this kind of column, i create a hidden column where a power automate is concatenate all selectionned fied in a single line of text as "Engine 1; Pump 2; Saw 4" etc...
In powerapps i'm trying to get a table with the good machine selected.
I do this filter in the string column.
ClearCollect(TEMP_TEST_CATALOGUE; Filter(Catalogue_U29; Tete_liste_IO = "CPR Principaux;"));;
> This function is working but will only work with parts with just the good machine selected. For exemple if a parts is used my "Engine 1" and "Saw 4". It will not works because the ' = ' Operator is looking for "Engine 1" and dont match with "Engine 1; Saw 4"
ClearCollect(TEMP_TEST2_CATALOGUE; Filter(Catalogue_U29; TEST_CHOIX_IO in Tete_liste_IO))
> This function is not working.
in looks not working
I can read this operator should be delegate
If someone can help me ?
I don't understand why it's not.
Kind regards..
4
Share
Report
All responses (
Answers (
