Unanswered

Patch a form with datepicker and checkbox

(0) Share

Report

Posted on by bjensen1

Hey All,

I have a form. In the individual datacards I have a Date Picker and a checkbox. If the record(data source 'Renewals', excel sheet) says "MTM" it is supposed to click the checkbox, if it has a date I want it to input the Date Picker, if its blank, remain blank(unless changed). I am having issues linking it together because I am getting the incompatible records: DateTime,Text warning on each of them.

Checkbox:

Default: If(ThisItem.'i-Communicate'="MTM", true, false)

OnSelect: Patch(Renewals,BrowseGallery1.Selected,{'i-Communicate':Checkbox1})

DatePicker:

DefaultDate: ThisItem.'i-Communicate'

OnSelect: Patch(Renewals,BrowseGallery1.Selected,{'i-Communicate':DatePicker1.SelectedDate})

Here is a screenshot of one of the datacards as well, for reference:

Is there a solution out there to make it read both? If I try updating it on a test user, it gives me a runtime error for the patch.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
Hi @bjensen1 ,

What type of field is 'i-Communicate' - it cannot be both a Date and Boolean (yes/no) and you are trying to patch one of each value. If a Boolean

Checkbox - Default

ThisItem.'i-Communicate'="MTM"

OnSelect

Patch( Renewals, {ID: BrowseGallery1.Selected.ID}, {'i-Communicate': Self.Value} )

but I am not sure where you want to put your date value.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
bjensen1 21 on at

Like (0)

Report

Hi @WarrenBelz ,

So this is for a contract section and these are for expirations. Either their contract ends on a date, or they are month to month(MTM). i-Communicate is one of the services provided, but I don't think the history behind that is overly necessary.

My thought process is:
It reads the excel sheet, and if it has a date, input it in the datepicker, if it says MTM it clicks the checkbox. I am not intentionally trying to do both a boolean and a date in the same box, as in clicking the box and inputting the datepicker at the same time. 1 of each, just in different controls. Not sure if that makes sense.

Thanks,

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
@bjensen1 ,

OK - I was assuming you were using SharePoint - you did not specify Excel (which is a bad choice unless you do not have access to SharePoint Lists) - so write them both as Text
Checkbox - Default

ThisItem.'i-Communicate'="MTM" = "Yes"

OnSelect

Patch( Renewals, BrowseGallery1.Selected, {'i-Communicate': If(Self.Value, "Yes", "No")} )

Date Picker - Default

DateValue(ThisItem.'i-Communicate')

OnSelect

Patch( Renewals, BrowseGallery1.Selected, { 'i-Communicate': Text(DatePicker1.SelectedDate, "dd/mm/yyyy") } )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
bjensen1 21 on at

Like (0)

Report

@WarrenBelz

Sorry for the confusion. I am using excel at the moment due to some ideas I have down the line(regarding the sheet updating).

I gave your more recent formulas a try. Getting a few errors.

On Checkbox1:
Name isn't valid. 'ID' isn't recognized.
Patch function has some invalid arguments.
Argument does not match expected 'DateTime'. Found 'Text'.

DatePicker1:
Patch function has some invalid arguments.
Argument does not match expected 'DateTime'. Found 'Text'.

Also getting an error that 'ID' column does not exist. Am I supposed to be replacing ID with something?

I appreciate your help.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

@bjensen1 ,

You can drop the ID (still thinking SharePoint and did not change - just make it BrowseGallery1.Selected, (fixed in post) however if that is a date field, you cannot patch the yes/no value to it, so we are back where we started.

Was this reply helpful? Yes No
Shaheer Ahmad 2,194 Moderator on at

Like (0)

Report

Please try Text(ThisItem.'i-Communicate')="MTM"

Was this reply helpful? Yes No
bjensen1 21 on at

Like (0)

Report

@WarrenBelz this is for both default and onselect of the checkbox.

Was this reply helpful? Yes No
bjensen1 21 on at

Like (1)

Report

@ShaheerAhmad

The OnSelect: Patch(
Renewals,
BrowseGallery1.Selected,
{'i-Communicate': "MTM"})

Default:
Text(ThisItem.'i-Communicate')="MTM"

Seems to get the error that "MTM" cannot be converted to a DateTime.

Was this reply helpful? Yes No
Shaheer Ahmad 2,194 Moderator on at

Like (0)

Report

Confirm the datatype of the 'i-communicate' column. I think its datatype is Date/Time....

Was this reply helpful? Yes No
Shaheer Ahmad 2,194 Moderator on at

Like (0)

Report

First of all in ur gallery add a text label and on its text property please add ThisItem.'i-Communicate' and check what output is shown in the gallery.

Was this reply helpful? Yes No