How to Disable DELETE button on an Edit Form when adding new record ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have the following:

Gallery with Add button (+)

Edit Form with the following buttons:

Cancel (X),

Delete (name is IconDelete1_1 on EditScreen1)

Save

On the Gallery, when I click the Add button to add a new record, how can I disable the Delete button on the Edit Form ?

This is of course to prevent the user from attempting to Delete a non-existent record (SQL Server back end). From what I can tell, you need to use UpdateContext() and so on.

I've tried multiple different syntax's and so on, but to no avail.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Venxir 125 on at

Like
a
(0)

Report
Copy link

Link copied!

I assume that your Add button will invoke a NewForm(<FormName>)?

Then you should use the formmode of your Edit Form.

Just disable the delete button when Form.Mode = FormMode.New, If you edit an existing record the mode will be Edit and when vieweing a record the mode will be View.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

"I assume that your Add button will invoke a NewForm()?"
Correct.
Then you should use the formmode of your Edit Form."
"Just disable the delete button when Form.Mode = FormMode.New,"

Sooo ... how do I do that ? What is the code/syntax to actuallyDisable the DELETE button ... and where would I put it?
Is there an event when the Edit Form opens ? thx
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous

Select your Delete button and change its Display Mode property to:

If( Form1.Mode = FormMode.Edit, DisplayMode.Edit, DisplayMode.Disabled )
Form1 is the name of your form
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Martynas
OK ... that works. Thank you.
Note:
This is what was in the Delete button DisplayMode property:

If(!IsBlank(BrowseGallery1.Selected) && DataSourceInfo('[NEM].[ztblNEM2Enh]', DataSourceInfo.DeletePermission), DisplayMode.Edit, DisplayMode.Disabled)

where [NEM].[ztblNEM2Enh] is a table in my SQL Server back end.

It would seem that code (generated when I let PA create the app) should Disable the button, but it's not. I think that is because there is always an item 'selected' in the BrowseGallery1.

I tried just If(!IsBlank(BrowseGallery1.Selected), DisplayMode.Edit, DisplayMode.Disabled) ... that does not work either.
Why do you suppose that is ?

Nonetheless ... I'm using the code you provided. I'm not really concerned with 'DeletePermission' in this app.
Appreciate the help.

Funny ... I've been working 24x7x365 with Microsoft Access / VBA for 25 years. Things like this are second nature. BUT ... the syntax in PA is quite different. BOOM !