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:

Connectors

General Questions

All responses (6)

Answers (2)

CU22100725-0 129 on at

Like (0)

Report

Re: filter lookup column in form with value on another table

Hi @v-jefferni ,

Thanks for your help, it work nicely !

Regards,
Tom Victor
Verified answer

v-jefferni on at

Like (0)

Report
Re: filter lookup column in form with value on another table

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,
CU22100725-0 129 on at

Like (0)

Report

Re: filter lookup column in form with value on another table

Hi, @v-jefferni ,

Sure there is ths error I get :

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

Regards,
Tom Victor
v-jefferni on at

Like (0)

Report

Re: filter lookup column in form with value on another table

Hi @TomVictor ,

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

BR,
CU22100725-0 129 on at

Like (0)

Report

Re: filter lookup column in form with value on another table

Hi @v-jefferni ,

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

v-jefferni on at

Like (0)

Report
Re: filter lookup column in form with value on another table

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,