Skip to main content

Notifications

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,238

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard

Featured topics