Answered

LookUp sharepoint choice to text column

(0) Share

Report

Posted on by rob4681

Hello all,

I have code which compiles but my variable does not get a value. Code below:

Set(ProdDir, LookUp(BatchTrack, 'Batch ID'= BatchID1.Text && 'Wafer ID'= WaferID1.Text, Product.Value));

ProdDir does not have any data assigned to it after execution of the command. Is it an issue with the value from SharePoint list BatchTrack product column which is choice type.

Thanks for your help.

Rob

All responses (3)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (1)

Report
Re: LookUp sharepoint choice to text column

Hi @rob4681 ,

If BatchID1 and WaferID1 are controls in your gallery, and I'm guessing you want to set this variable to the value of the Product column of the currently selected item, then you can try this:
Set(ProdDir,ThisItem.Product.Value)

Best regards,
Rimmon
rob4681 on at

Like (0)

Report

Re: LookUp sharepoint choice to text column

Hi Rimmon,

It's part of the onselect from a gallery. It's a choice column... only one value can be selected.

Thanks.
v-mengmli-msft on at

Like (0)

Report

Re: LookUp sharepoint choice to text column

Hi @rob4681 ,

Could you tell me where you put this code and whether Product is a multi-select column?

Rimmon