Unanswered

Office reservation / Time issue

(0) Share

Report

Posted on by ianallen13V2

Hello,

I'm hoping that someone can help me. I've created a canvas app for basic office reservation purposes, but the issue I am having is that the 'start time value' and 'end time value' that I have created that format the selected times into a time data type, I do not know how to write my submit formula so that I can 1. include both of them and 2. get those values to come over to SharePoint as actual time and not as text.

If anyone has any ideas / tips on how to assist - I'm all ears.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

Hi @ianallen13V2 ,
Please modify your formula to Text(Time(Value(Hour.Selected.Value), Value(Minute.Selected.Value), 0), DateTimeFormat.ShortTime)

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@ianallen13V2

if you go with AM/PM (not 24-hour format) there is a bit complex formula

'Time Start': DatePicker.SelectedDate + Time( Value( If( DropdownAmPm.Selected.Value = "AM" && DropdownHours.Selected.Value<>12, DropdownHours.Selected.Value, DropdownAmPm.Selected.Value = "AM" && DropdownHours.Selected.Value=12, 0, DropdownAmPm.Selected.Value = "PM" && DropdownHours.Selected.Value<>12, DropdownHours.Selected.Value + 12, DropdownAmPm.Selected.Value = "PM" && DropdownHours.Selected.Value=12, DropdownHours.Selected.Value ) ), Value(DropdownMinutes.Selected.Value), 00 )

Was this reply helpful? Yes No
ianallen13V2 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I'm sure I missed something, but I tried this and it does not work for me. Did you mean for this formula for the time selection tool or the overall submit formula? Just checking...

Was this reply helpful? Yes No
Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

In Your case, the formula will be
Text(Time(Value(DD_Hour.Selected.Value), Value(DD_Minute.Selected.Value), 0), DateTimeFormat.ShortTime)
You have Missed- "DateTimeFormat.ShortTime".

While submitting, please make sure your column of type text to accept the time format.

Was this reply helpful? Yes No