filter lookup column in form with value on another table

(0) Share

Report

Posted on by CU22100725-0

129

Hi,

I'm using form to save value in my dataverse table and I use a lookup column in the form to select a value. This value must be filtered by a choice in the main table. I try to use this formula and I get a network error:

Filter('CRM - Commande'; 'Condition Facturation'.Activé = 'Activé (CRM - Paramètre Conditions)'.Activé)

How can I fix this ?

Regards,

Tom Victor

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

v-jefferni on at

Like (0)

Report
Hi @TomVictor ,

Please use below formula in Items property:

Filter('CRM - Paramètre Conditions'; 'Condition Facturation' = 'Activé (CRM - Paramètre Conditions)'.Activé)

In this formula, 'CRM - Paramètre Conditions' is the main table, 'Condition Facturation' is the choices column within main table.

Best regards,

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report

Hi @v-jefferni ,

I try to use your formula and I still have a Network error.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @TomVictor ,

Please share the whole error message. You can try and refresh the table connection first.

BR,

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report

Hi, @v-jefferni ,

Sure there is ths error I get :

Translation : "Error when trying to retrieve data from the network"

Regards,
Tom Victor

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @TomVictor ,

Please check the choices column name in main table. It seems the formula could be as below because Activé is the choices column name:

Filter('CRM - Paramètre Conditions'; Activé = 'Activé (CRM - Paramètre Conditions)'.Activé)

BR,

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report

Hi @v-jefferni ,

Thanks for your help, it work nicely !

Regards,
Tom Victor

Was this reply helpful? Yes No