Answered

Form Time Fields Error in DataCard Update

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have customized SharePoint Form1.

I created fields that allow the user to enter time on a twelve-hour (AM/PM) clock basis.

I am catching an error on the semi-colon in the time formula (see below).

How do I correct this issue? Can I simply leave the semi-colon out?

DataCard Update Property -
DateValue1.SelectedDate + TimeValue(HourValue1.Selected.Value & ":" & MinuteValue1_1.Selected.Value)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Phineas - I am sure you have already followed some of these steps, but writing them all out for completeness:

1. Insert a Dropdown control into the DataCard for the DateTime field

2. In the Items property of the Dropdown control, enter:

["AM", "PM"]

3. Set the Default property of the above to:

If( Hour(Parent.Default) < 12, "AM", "PM" )

4. Modify the Items in the Hour Dropdown control to:

["12","01","02","03","04","05","06","07","08","09","10","11"]

5. Set the Default property of the Hour control to:

Text( If( Mod( Hour(Parent.Default), 12 ) = 0, 12, Mod( Hour(Parent.Default), 12 ) ), "0" )

6. Set the DataCard Update property to:

If( Not IsBlank(DateValue1.SelectedDate), DateValue1.SelectedDate + Time( If( 'Your AM-PM Dropdown'.Selected.Value = "PM", 12, 0 ) + Mod( Value(HourValue1.Selected.Value), 12 ), Value(MinuteValue1.Selected.Value), 0 ) )

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Edited Reply -
I made the changes suggested.

I am still getting one error, regarding the semi-colon " : ".

I can't tell if the error is referencing one of them or all of them.

How do I determine/correct this issue?

*************************************************************************************************************************
Further troubleshooting leads me to believe the issue may be the incoming 'existing' data.

Below is an excerpt from the SharePoint list. The circled field shows some existing data. This data has the date and time (with the include time toggle set to true).

Could this be the issue? If yes, how do I correct so that I can retrieve the existing data while being able to retain the changes in the app?

Meanwhile the data in the 'Edit' form is as follows and doesn't show the same time as the SharePoint list.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Phineas - could you create a new screen and insert a new EditForm control with the DataCard for the Date field included, and then try the solution again. I suspect there is some undetermined modification in your EditForm which is causing the problem.

Was this reply helpful? Yes No
Verified answer

Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I edited the formula in each DataCard 'Update' property to start with DateTimeValue.

This seems to have resolved the issue. I am still testing.

DateTimeValue(DateValue1.SelectedDate + HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value)

Was this reply helpful? Yes No