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?
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.