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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rob4681 ,

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

Rimmon

Was this reply helpful? Yes No
rob4681 on at

Like (0)

Report
Copy link

Link copied!

Hi Rimmon,

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

Thanks.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No