I pull in a Time field from SQL and then run through the conversion to make it readable in my app with code like this:
"OutTime", First(ForAll(MatchAll(SignoutTime,"PT(?:(?<hours>\d+)H)?(?:(?<minutes>\d+)M)?(?:(?<seconds>\d+)S)?"), Time(Value(hours),Value(minutes),Value(seconds)))).Value,
This is inside an AddColumns function so it creates a new column named OutTime with a clean version of SignoutTime retrieved from SQL.
Then if I run
IsBlank(OutTime) it returns false
IsEmpty(OutTime) it returns false
IsBlank(SignoutTime) it returns true
If I create a label that displays OutTime it shows nothing and appears to be blank. I don't understand what is happening? Can anyone help me understand?
Solved! Go to Solution.
Thanks but that doesn't really explain I think. I am not trying to patch a null. I don't know what the value is that comes out of that code because it isn't blank or empty but at the same time if displayed in a label shows nothing?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!