Use the Lookup function in powerapps

Like (0) Share

Report

Posted on 18 Jul 2023 06:36:50 by Edward00

122

I use this Lookup function to display the quantity in the Sharepoint List CurrentProductsStock if there is an ID equal to the ID of the sharepoint list Product. But I'm still faulty.

Product List:

CurrentProductStock List:

Column Product in CurrentProductStock List use type Lookup:

Please help me. Thank you very much.

Categories:

General Questions

All responses (8)

Answers (1)

Verified answer

EddieE 4,641 Super User 2025 Season 1 on 19 Jul 2023 at 05:26:00

Like (0)

Report

Re: Use the Lookup function in powerapps

@Edward00

Change

Gallery9.Selected.ID

to

Text(Gallery9.Selected.ID)
gvls 2 on 19 Jul 2023 at 05:03:57

Like (0)

Report
Re: Use the Lookup function in powerapps

I assume that its varAddCart your selected Product.

Lookup(CurrentProductsStock, Product= varAddCart.ID, Quantity)

your lookup should be Comparing the columns of Identity Column key and foreign key column.
Let me know if still face issues.
Edward00 122 on 19 Jul 2023 at 04:49:57

Like (0)

Report

Re: Use the Lookup function in powerapps

It's faulty like this and it's faulty where the equal sign,sir.
EddieE 4,641 Super User 2025 Season 1 on 19 Jul 2023 at 04:04:55

Like (0)

Report
Re: Use the Lookup function in powerapps

@Edward00

I didn't spot that before - but the error is telling you what is wrong, ie Lookup should be LookUp. This is my bad from the code above - sorry.

Try this, then see if you are still getting errors

LookUp(CurrentProductsStock, Product.Value = varAddCart.ID, Quantity)
Edward00 122 on 19 Jul 2023 at 03:38:38

Like (0)

Report

Re: Use the Lookup function in powerapps

I'm guilty like this. So where am I wrong, sir. And varAddCart is what I assign to the gallery item when OnSelect.
1.
2.
3.

4.
EddieE 4,641 Super User 2025 Season 1 on 18 Jul 2023 at 23:38:10

Like (0)

Report

Re: Use the Lookup function in powerapps

@Edward00

A few things

1. What is varAddCart? I assumed this is a variable which contains a full record?

2. Can you hover of the .Value part where the Red line is heavier and capture the error text

3. Also, do the same as 2 for 'Quantity'

4. Can you double check the name of the 'Product' column; use

List settings --> Click the column --> the actual column name is the last part of the URL, eg

Also - just for reference - the 'Id' which you where trying to reference in your first formula is simply an internal ID used by the LookUp column and not related to the ID coming from the associated list.
Edward00 122 on 18 Jul 2023 at 09:46:25

Like (0)

Report

Re: Use the Lookup function in powerapps

it's still faulty.
EddieE 4,641 Super User 2025 Season 1 on 18 Jul 2023 at 06:47:57

Like (0)

Report
Re: Use the Lookup function in powerapps

@Edward00

Try this

Lookup(CurrentProductsStock, Product.Value = varAddCart.ID, Quantity)