Collect lookup collumn in dataverse

(0) Share

Report

Posted on by CU22100725-0

129

Hi,

I've tried to collect some data in a editable grid, I have 2 lookup column in my dataverse that I use in my grid. My problem is that I can't collect the data modified in the grid.

I use that as a formula:

If(
 ThisItem.'CRM - Commande' in colTaskUpdatesCommande.'CRM - Commande';
 Update(
 colTaskUpdatesCommande; 
 LookUp(
 colTaskUpdatesCommande;
 'CRM - Commande' = ThisItem.'CRM - Commande');
 {
 
 }
 );
Collect(
 colTaskUpdatesCommande;
 {
 Client: DropdownCanvas1.Selected;
 Commande: TextInputCanvas1.Value;
 'Date de commande': DatePickerCanvas1.Value;
 'Description commande': TextInputCanvas1_1.Value;
 'Condition de facturation': DropdownCanvas1_1.Selected;
 'CRM - Commande': ThisItem.'CRM - Commande'
 }
)

If someone can help me it would be appreciated.

Thanks,

Tom Victor

Categories:

Connectors

All responses (6)

Answers (1)

CU22100725-0 129 on at

Like (0)

Report

Re: Collect lookup collumn in dataverse

Hi @Ethan_R ,

Thanks for the help, it now works nicely !
Ethan_009 4,838 Super User 2025 Season 1 on at

Like (1)

Report
Re: Collect lookup collumn in dataverse

Hi @TomVictor ,

Your Lookup code will is showing error because you are comparing Text and Record datatype

//Code will be LookUp( 'CRM - Client'; Client = combobox7.Selected.Client; ThisRecord)

Please ensure brackets and datatypes are proper for this to work
CU22100725-0 129 on at

Like (0)

Report

Re: Collect lookup collumn in dataverse

Hi @Ethan_R ,

Sure I can make some screenshot
Ethan_009 4,838 Super User 2025 Season 1 on at

Like (0)

Report

Re: Collect lookup collumn in dataverse

Hi @TomVictor ,
Can you share a screenshot of the error and the part where it is highlight?

Just to make the format clear, here's what I implemented long ago which works without issue:
CU22100725-0 129 on at

Like (0)

Report

Re: Collect lookup collumn in dataverse

Hi @Ethan_R

Thanks for your reply, it doesn't seems to work for me, I cannot compare the first part of your formula. It says that I can't compare a Text with a Record
Verified answer

Ethan_009 4,838 Super User 2025 Season 1 on at

Like (1)

Report
Re: Collect lookup collumn in dataverse

Hi @TomVictor ,

Just check if you have ',' commas as separator or ';' semi-colon.
I use commas so I wrote the code:
If( ThisItem.'CRM - Commande' in colTaskUpdatesCommande.'CRM - Commande', Update( colTaskUpdatesCommande, LookUp( colTaskUpdatesCommande; 'CRM - Commande' = ThisItem.'CRM - Commande' ), { Client: LookUp( Clients, ClientID = DropdownCanvas1.Selected.ID, ThisRecord ), Commande: TextInputCanvas1.Value, 'Date de commande': DatePickerCanvas1.Value, 'Description commande': TextInputCanvas1_1.Value, 'Condition de facturation': DropdownCanvas1_1.Selected } ), Collect ( colTaskUpdatesCommande; { Client: LookUp( Clients, ClientID = DropdownCanvas1.Selected.ID, ThisRecord ), Commande: TextInputCanvas1.Value, 'Date de commande': DatePickerCanvas1.Value, 'Description commande': TextInputCanvas1_1.Value, 'Condition de facturation': DropdownCanvas1_1.Selected, 'CRM - Commande': ThisItem.'CRM - Commande' } ) )

Considering that Client is lookup value, you need to capture the record completely instead of just dropdown.selected. As it sometimes doesn't update values properly when working on large datasets.

Hope this helps