I have date time field named "FirstDate" bound with CDS Entity record as displayed below:
I am able to patch date value with following formula:
However, I am unable to patch hour and minute value - I have already tried following formula as mentioned here - https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-function-to-write-date-time-field-back...
DateValue5.SelectedDate+Time(Value(HourValue5.Selected.Value);0;0) - This doesn't work.
Can you please share right formula to patch time values?
DateValue5.SelectedDate + Time(Hour(Now()), Minute(Now()), Second(Now()))
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Thank you for the response, however this patches, current minute,hour and seconds, while I need to patch selected hour and minute - How can I do that?
I was able to resolve it with following formula:
DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), Value("00"))
Thanks and Regards,
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.