Answered

I want to disable the SAVE button if it will found duplicate value into gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

in the above image Line 1 and 3 green field combination of two field ("Top Root Causes" & "Action Title" ) both line have same information in the green Color Field
I want disable save button If user will found duplicate value

If the green value same text value found I need disable Save button which is outside the gallery

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Ramole Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Use this code under display property where you need to be Disabled

If(IsBlank(LookUp(galMain_1.AllItems,TrackingNumber=TextInput7.Text)),DisplayMode.Edit,DisplayMode.Disabled)

Was this reply helpful? Yes No
WarrenBelz 154,941 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,
Assuming the data is written to the fields

If( CountRows( Filter( YourGalleryName.AllItems, 'Top Root Causes' = 'Action Title' ) ) > 0, DisplayMode.Disabled, DisplayMode.Edit )

If you are dealing with the content of the Combo Boxes before it is written to the data source

If( CountRows( Filter( YourGalleryName.AllItems, YourTopRootCausesComboBox.Selected.xxxx = YourActionTitleComboBox.Selected.xxxx ) ) > 0, DisplayMode.Disabled, DisplayMode.Edit )

where xxxx is the valid output (Value/Result/FieldName) of the combo box

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz @Ramole Thanks to replying me .

The above function is not working properly
I will allow user enter unique value in the Action Title Green Color Field and I need to disable the Save Button Also
How to notify the user user need to put unique value

Was this reply helpful? Yes No
WarrenBelz 154,941 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Please post (in text) the code that is not working for you now and where you are using it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
If(IsBlank(LookUp(galMain_1.AllItems,TrackingNumber=TextInput7.Text)),DisplayMode.Edit,DisplayMode.Disabled)
If(IsBlank(LookUp('New & emerging risks and actionsGallery_12'.AllItems,UniqueColumn=TextInput10.Text)),DisplayMode.Edit,DisplayMode.Disabled)
Gallery "Action Title" field all are different but Save button is disable

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If(CountRows('New & emerging risks and actionsGallery_12'.AllItems) > CountRows(Distinct('New & emerging risks and actionsGallery_12'.AllItems, UniqueColumn)), Notify("This combination of values already exists. Please chose a different set of values",Error), Notify("Success", Success))
That above function is working
Thanks for your support

Was this reply helpful? Yes No