Self-filling collection

(0) Share

Report

Posted on by CU22100725-0

129

Hi,

I have an application that uses an editable grid with different collections. I have a problem with 2 Collection in my apps, one is named colTaskUpdatesCommande, and the other one colTaskUpdatesPresta. When I go to a page with one of this 2 Collection, it fill itself value that I don't modify. And when I want to save my edit, it doesn't seems to clear my collection.

How can I fix it ?

Regards,

Tom Victor

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TomVictor ,

Would you please share formulas you used to generate and modify the collections for further check?

Search the collection name here will locates to all formulas related to it:

Best regards,
Community Support Team _ Wenjuan Zou

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

Like (0)

Report
Copy link

Link copied!
Hi @v-wenjuan-msft,

Here is an exemple of formula I used to generate and modify the collection:
If( ThisItem.'CRM - Commande' in colTaskUpdatesCommande.'CRM - Commande'; Update( colTaskUpdatesCommande; LookUp( colTaskUpdatesCommande; 'CRM - Commande' = ThisItem.'CRM - Commande'); { Client: LookUp('CRM - Client'; Client = ComboBox7.Selected.Client;ThisRecord); Commande: TextInputCanvas1.Value; 'Date de commande': DatePickerCanvas1.Value; 'Description commande': TextInputCanvas1_1.Value; 'Condition Facturation': LookUp('CRM - Paramètre Conditions'; 'Condition Facturation' = ComboBox7_1.Selected.'Condition Facturation'; ThisRecord); 'CRM - Commande': ThisItem.'CRM - Commande' } ); Collect( colTaskUpdatesCommande; { Client: LookUp('CRM - Client'; Client = ComboBox7.Selected.Client;ThisRecord); Commande: TextInputCanvas1.Value; 'Date de commande': DatePickerCanvas1.Value; 'Description commande': TextInputCanvas1_1.Value; 'Condition Facturation': LookUp('CRM - Paramètre Conditions'; 'Condition Facturation' = ComboBox7_1.Selected.'Condition Facturation'; ThisRecord); 'CRM - Commande': ThisItem.'CRM - Commande' } ))

Thanks,
Tom Victor

Was this reply helpful? Yes No