Unanswered

How do you disable button when data is present in a column either a in gallery or SharePoint List

(0) Share

Report

Posted on by powerclark

Hi all,

I am in the process of creating a mileage submission app where users can add there business trips. Without going into to much detail, what I'm trying to achieve is that the user can only update a field within a form and submit it once. Once that field contains data then the submit button is disabled indefinitely . When the user updates the field with the mileage they also need to tick a checkbox which then write true back to the List under a Declaration column so I figured this would be a useful field to use for a lookup.

Screenshot 2024-01-16 142334.png

I already have the submit button disable if this checkbox hasn't been ticked using the code:

If(DataCardValue18.Value=true,DisplayMode.Edit,DisplayMode.Disabled)

I've been trying to either lookup a field within either the List or an embedded Gallery that contains the true value (Declaration field) and then disable the button if the value is true.

List Name: mileagesubmissions

GalleryName: CalculateMileageGallery

Field user update: 'End Odometer Reading'

Possible field to use for lookup: Declaration (checkbox, true/false)

I've been struggling to write this in the correct way for a while and just can't quite get it to work so any help would be so greatly appreciated.

Many thanks in advance

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

KaiE 39 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

Maybe something like this:

If(ThisItem.Declaration; DisplayMode.Edit;DisplayMode.Disabled) OR If(ThisItem.Declaration, DisplayMode.Edit,DisplayMode.Disabled) OR If(ThisItem.Declaration = true; DisplayMode.Edit;DisplayMode.Disabled) OR If(ThisItem.Declaration = true, DisplayMode.Edit,DisplayMode.Disabled)

If the button is not a child of the form ->
//Set SelectedRecord at OnSelect in the gallery Set(SelectedRecord; CalculateMileageGallery.Selected) //Code for button DisplayMode If(SelectedRecord.Declaration;DisplayMode.Edit;DisplayMode.Disabled) OR //Set SelectedRecord at OnSelect in the gallery Set(SelectedRecord, CalculateMileageGallery.Selected) //Code for button DisplayMode If(SelectedRecord.Declaration,DisplayMode.Edit,DisplayMode.Disabled)
powerclark 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this. Unfortunately it doesn't work as expected.

I'm guessing it's because the declaration checkbox is part of a form and the submit button sits outside of both form and gallery.