Answered

Powerapps formula

(0) Share

Report

Posted on by vshah2

Hello,

I have a gallery and controls are groups. Now I want to disabled the save icon of the gallery when the status of the collection is submitted. I'm doing something like below.

If(LookUp(collection,Collection_Column1=Gallery.Selected.Column1,Collection_Column2) = "Submited",Disabled)

Issues is It's disabling all the save icon in the gallery. I just want to disable the where the Collection_Column2 = Submited. Can someone help please? Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

vshah2 24 on at

Like (0)

Report
Copy link

Link copied!

FYI, When I have SQL DB as source in gallery, I'm able to achieve the same thing with below formula

If(ThisItem.Collection_Column2="Submited",DisplayMode.Disabled)

I think thisitem is the trick in above formula. I'm looking for similar things when I use collection as a source to gallery

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please give a screenshot of the Gallery
Please try this:
At the beginning of the OnSelect of the Save: Button
Collect(DisaButton, ThisItem.ID)

Then on the Displymode of the button:
If(ThisItem.ID in DisaButton, DisplayMode.Disabled, DisplayMode.Edit)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,320 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @vshah2 ,
That formula should work if the value of Collection_Column2 in the gallery is Submited (note misspelling - should be Submitted).
What is the Items of your gallery and the code for Collection of the data?

Was this reply helpful? Yes No
vshah2 24 on at

Like (0)

Report
Copy link

Link copied!

Yes, That was the issue. I was using thisitem in the formula but I wasn't patching the source collection. I appreciate your quick help. Thank you.

Was this reply helpful? Yes No