Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lrORXLUXQh82URUyySWou6
Power Apps - Power Query
Unanswered

I need to delegate a filter query with a simple in operator. It don't work.

Like (0) ShareShare
ReportReport
Posted on 16 Sep 2024 07:18:21 by 4
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..
Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Query

#1
ronaldwalcott Profile Picture

ronaldwalcott 2

Overall leaderboard

Featured topics

Loading started
Loading complete