Announcements
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
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,
Hi @v-jefferni ,
I try to use your formula and I still have a Network error.
Please share the whole error message. You can try and refresh the table connection first.
BR,
Hi, @v-jefferni ,
Sure there is ths error I get :
Translation : "Error when trying to retrieve data from the network"
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é)
Thanks for your help, it work nicely !
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
