web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Math for Time Values

Power Apps

Answered

Math for Time Values

(0) Share

Report

Report

Posted on by slhangen

356

Need to write end time, duration of services to SharePoint list.

Dropdown Default start time set to current hour and minute to current minute

StartTime Card:

ddStartTimeHour.Selected.Value

ddStartTimeMinute.Selected.Value

&ddStartTimeAMPM.Selected.Value

EndTime Card:

ddEndTimeHour

ddEndTimeMinute

ddEndTimeAMPM

Want end time default value to be based on ddContactType_1.Selected.Value

ddContactType_1 items:

["CICO", "Student Conference", "Guardian Conference", "Phone", "Home Visit", "Text Message", "Letter", "Email"]

"CICO" End time = start time +15 minutes

"Student Conference" End time = start time + 30 minutes

"Guardian Conference" End time + 30 minutes

"Phone" End time = start time + 5 minutes

"Home Visit" End time = start time + 30 minutes

"Text Message" End time = start time+ 5 minutes

"Letter" End time + 10 minutes

"Email" End time + 5 minutes

Know it should be a SWITCH statement but I have not done this with times yet.

So for this one: End Time should default to 2:02 PM since Start Time is 1:30 PM and Student Conference lasts 30 minutes

Thanks for any assistance!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

slhangen 356 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried this but doesn't work:

Switch(
ddContactType_1.Selected.Value = "CICO",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+5,
ddContactType_1.Selected.Value = "Student Conference",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+30,
ddContactType_1.Selected.Value = "Guardian Conference",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+30,
ddContactType_1.Selected.Value = "Phone",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+5,
ddContactType_1.Selected.Value = "Home Visit",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+30,
ddContactType_1.Selected.Value = "Text Message",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+5,
ddContactType_1.Selected.Value = "Text Message",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+10,

ddContactType_1.Selected.Value = "Email",
TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value)+5 )
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @slhangen ,

Please try:

Switch( ddContactType_1.Selected.Value, "CICO", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),5,TimeUnit.Minutes), "Student Conference", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),30,TimeUnit.Minutes), "Guardian Conference", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),30,TimeUnit.Minutes), "Phone", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),5,TimeUnit.Minutes), "Home Visit", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),30,TimeUnit.Minutes), "Text Message", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),5,TimeUnit.Minutes), "Text Message", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),10,TimeUnit.Minutes), "Email", DateAdd(TimeValue(ddStartTimeHour.Selected.Value&":"& ddStartTimeMinute.Selected.Value&" "&ddStartTimeAMPM.Selected.Value),5,TimeUnit.Minutes) )

Best Regards,

Bof

Join the conversation