Change Display mode if category exits alread in collection

(0) Share

Report

Posted on by Frankie70

384

Hi all!

I have several items in my collection, each has a category.

My goal is to disable the "Buy" button (DisplayMode) in my gallery if an item of a specific category is already in my collection.

Can someone advise how to do that?

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

this is the small data i took in my collection
Collect(IceCream, { Flavor: "Chocolate", Quantity: 1100 }, { Flavor: "Vanilla", Quantity: 200 } )

and basis on that search i have set my buy button display mode.
If(LookUp(IceCream, Flavor = "Chocolate", Quantity )=100,Disabled,Edit)

Hope it will help to resolve your problem.

Was this reply helpful? Yes No
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

@VDS_Mantra
Thanks for your reply.
I am not sure, what goes wrong.
If (LookUp(basket, itemcat = 'Laptop',DisplayMode.Disabled, DisplayMode.Edit))
Maybe you can give me a hint?

Was this reply helpful? Yes No
VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Use below one it will resolve your problem.
"If (LookUp(basket, itemcat = 'Laptop',itemcat) = "Laptop",Disabled, DisplayMode.Edit)"

Here Basket is the name of Collection Variable, and Itemcat is one of the header, So you need to lookup the items basis on some field. so here we are searching Itemcat based on Itemcat = Laptop. As i have lookup Icecream Quantity based on Flavor in my example.

Hope you got my point. see the below lookup function Syntax.
LookUp( Table, Formula [, ReductionFormula ] )

Was this reply helpful? Yes No
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

@VDS_Mantra
Hi,
thanks, the formula throws no error anymore, but the DisplayMode is not set to disabled in my case although in my collection (basket) there is an item with the category "Laptop".
Something is still wrong...any idea?

Was this reply helpful? Yes No
VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can you please share your collection variable snapshot.

Was this reply helpful? Yes No
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

@VDS_Mantra
Hi,
here it is:
Collect(basket, {itemname: Gallery4.Selected.Title, itemcat: Gallery4.Selected.Category})

Was this reply helpful? Yes No
VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Use this one..

"If (LookUp(basket, itemcat = "Laptop",itemcat) = "Laptop",Disabled, DisplayMode.Edit)"

I am sure it will surely work for you.

Was this reply helpful? Yes No
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

@VDS_Mantra
Ok grat, that worked. It was only the double quotas...
But I forgot something: Now the button for the items with Category= "Peripherie" or "Mobile" are also disabled...
How can I include theses cases into the formula?

Was this reply helpful? Yes No
VDS_Mantra 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

the best way of doing this that you set a variable value of your selected items and then use like below function.

If(LookUp(basket,itemcat=VItemcat,itemcat) = VItemcat, Disabled,DisplayMode.Edit)

i have set this variable from dropdown selection so it will work for each items whichever you will select from dropdown.
Set(VItemcat,Dropdown1.Selected.Value)

or you may use this

If(LookUp(basket,itemcat="Mobile",itemcat) = "Mobile" ||LookUp(basket,itemcat="Laptop",itemcat) = "Laptop",Disabled,DisplayMode.Edit)

As per me first option is best.

If this post helps, then please consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

@VDS_Mantra
Thanks for you replies!!
If (LookUp(basket, itemcat = "Mobile",itemcat) = "Mobile" || LookUp(basket,itemcat="Laptop",itemcat) = "Laptop",Disabled,DisplayMode.Edit) does not work.
When I choose a Laptop, then the shopping options for more laptops are disabled, which is correct.
But when I go to Mobile section, these are already disabled as well. My aim is that users can only choose 1 laptop and 1 mobile device, nbut multiple devices as peripherie.

Was this reply helpful? Yes No