Answered

Issues on filtering values from a table

(0) Share

Report

Posted on by Jmnavi

Hello All,

I'm strugling to get the values from one variable and use them to return a list filtered according to these values.
I'm trying the following:

Set(VarRevSel;DataTable1_3.Selected);;
Set(FKVAR;LookUp('B1 - Documentação de Saída';'DOCUMENT CODE'.Value = Label5.Text && REVISION=VarRevSel.REVISION ;'FK CODE'));;
Set(FKVar1;FKVAR.Value);;
ForAll(FKVar1;Collect(FKttl;Filter('A3 - FULL KIT';'FK CODE')))

As per the variable, it should filter the following 2 values (of six of the list):

However, it returns the entire list and not the only ones I'm trying to filter.

Any guess how to solve.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jmnavi ,

Please try below formula:

Set(VarRevSel;DataTable1_3.Selected);; Set(FKVAR;LookUp('B1 - Documentação de Saída';'DOCUMENT CODE'.Value = Label5.Text && REVISION=VarRevSel.REVISION ;'FK CODE'));; Collect(FKttl;UnGroup(ForAll(FKVAR;Filter('A3 - FULL KIT';'FK CODE' = ThisRecord.Value));"Value"))

If FK CODE in A3 - FULL KIT table is unique, use below formula:

Set(VarRevSel;DataTable1_3.Selected);; Set(FKVAR;LookUp('B1 - Documentação de Saída';'DOCUMENT CODE'.Value = Label5.Text && REVISION=VarRevSel.REVISION ;'FK CODE'));; Collect(FKttl;ForAll(FKVAR;LookUp('A3 - FULL KIT';'FK CODE' = ThisRecord.Value)))

Best regards,

Was this reply helpful? Yes No
Jmnavi 51 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @v-jefferni

Thank you!!
It works.
Alternativelly I found out another sollution which is apparently working without ForAll. I'd like to share with you. Please see below:
Collect(FKttl1;Filter(FKttl;'FK CODE' in FKVar1))

Was this reply helpful? Yes No