Answered

Patch combobox with lookup field column in SharePoint list

(0) Share

Report

Posted on by AB-18111337-0

Hi everyone,

We're using a combobox ('combobox_1') with values based on a lookupcolumn ('Category') in a SharePoint List ('VRT_WS_Artikels'). We want to patch the chosen values in the Sharepoint list, but it doesn't seem to work for us.

We have this:

Patch(
VRT_WS_Artikels;
Defaults(VRT_WS_Artikels);
{Title: Txt_Productnaam.Text;
Leverancier:Txt_Leverancier.Text;
'Link website':Txt_linkwebsite.Text;
Kleur:Txt_kleur.Text;
Foto:Med_artikelfoto.Image;
'Enkel voor ENG':If(Togg_ENG.Value=true;{Value: "Ja"};{Value:"Neen"});
Beschikbaar:If(Tog_kledijbeschikbaar.Value=true;{Value:"Ja"};{Value:"Neen"});
Categorie:{ID:LookUp(VRT_WS_Categorie; 'Naam categorie'=ComboBox1.Selected.ID);Value:ComboBox1.Selected.Value}
}
)

Everything works except for the 'Categorie', which is the lookupfield ofcourse.

Thanks in advance for the help!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AB_ ,

Firstly try this

Patch( VRT_WS_Artikels; Defaults(VRT_WS_Artikels); { Title: Txt_Productnaam.Text; Leverancier: Txt_Leverancier.Text; 'Link website': Txt_linkwebsite.Text; Kleur: Txt_kleur.Text; Foto: Med_artikelfoto.Image; 'Enkel voor ENG': { Value: If( Togg_ENG.Value; "Ja"; "Neen" ) }; Beschikbaar: { Value: If( Tog_kledijbeschikbaar.Value; "Ja"; "Neen" ) }; Categorie: { Id: LookUp( VRT_WS_Categorie; 'Naam categorie' = ComboBox1.Selected.Value ).ID; Value:ComboBox1.Selected.Value } } )

Also consider why you are using Lookup columns at all unless you need them directly in SharePoint Edit in Grid View - I have never found the need.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
AB-18111337-0 48 on at

Like
a
(0)

Report
Copy link

Link copied!

This seems to work, thank you!