Answered

New variable that combines Date and Time variables

(1) Share

Report

Posted on by Community Power Pla...

I want to create a new variable that will be the date picked from a date picker and the time from a dropdown.

The datepicker.SelectedDate is already in Date format, but the time from the dropdown is a text string

["9:00 AM","9:30 AM","10:00 AM..."4:30 PM","5:00 PM"]

I want to set a new variable on the press of a button to combine the two, preferably in Date/Time format.

I've tried setting the date to text and concatenating that string with the time string then converting that back to date/time, I've also tried

Set(NewDateTimeVariable, Datepicker.SelectedDate + TimeValue(Dropdown.Selected.Value))

but I get the error "Incompatible type. We can't evaluate your formula because the context variable types are incompatible with the types of values in other places in your app."

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

wyotim 2,545 on at

Like (5)

Report
I would suggest the following:

Set( NewDateTimeVariable, DateTimeValue( Datepicker.SelectedDate & " " & TimeValue(Dropdown.Selected.Value) ) )
I think the "+" in your original formula is causing PowerApps to try and add, rather than concatenate, the two values. By using & " " & instead, it creates a text string which the DateTimeValue function is able to use. Let me know how that works for you.

*edit* Premature submission! Testing the above code worked for me as far as creating a DateTime value. If that doesn't work, you may need to look at the NewDateTimeVariable to see if it is expecting something else using View -> Variables and selecting NewDateTimeVariable from the list and looking at the Definitions and Uses tabs.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks wyotim,

It's strange because I set the dropdown.selected.value to be a variable and the datepicker.SelectedDate to be another variable and when I use the variable names in the exact same place it fails, but when I directly reference the selected values instead of their equivalent set variables it works.

Oh well, that solves my problem. Thanks again!

Was this reply helpful? Yes No
wyotim 2,545 on at

Like (0)

Report

@AnonymousThat is a bit strange. Glad the direct references worked though!

Was this reply helpful? Yes No
muralikrishna00 21 on at

Like (0)

Report

Hi @Anonymous

Screen shots please ...?

Was this reply helpful? Yes No