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 these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!