Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compose Expressions rendering as plain text on import

Hey Folks,

Bit of a random one but I'm seeing two compose expressions rendering as text if I edit another area of my Flow. I f I adjust them back and save all is good - but I need to remember to toggle these two fields everytime I do something new.


The Expressions arent too wild, one is looking for an empty result set and the other converting time to a local time zone date time and adding it to an html table within an email.


If I save and dont touch the Flow it all works, but if I edit the flow, this seems to trigger the expression to render as text in the editable flow - so if I save the flow without checking these fields, the flow will then fail.


Anyone else seeing this?


Expression syntax is :  (last updated being a column from sql)

convertTimeZone(item()?['LastUpdated'],'New Zealand Standard Time','New Zealand Standard Time','dd-MM-yyyy')
The other expression is just looking for an empty get rows action.


rendering as text.pngrender as expression.pngdateexpressionastext.pngexpressionworking.png

Community Support
Community Support

Hi @Anonymous,


I have made a test on my side and don't have the issue that you mentioned.


My expression language wouldn't be adjusted automatically and the flow would always works fine on my side.


Please recreate the flow to to check if the issue still exists and let me know the result.


Best regards,


Not applicable

Hi Alice - recreated the same flow. Issue persists.


I can save the flow and test it all great, then if I exit out of the edit screen and go back to the flow home page, then go back to the same flow and edit it, the expression renders as text in the edit screen.


I see the same issue on 5 other flows - so not just one random malformed flow - to me this is a bug within Flow - or the documentation needs to be updated to advise that using expression syntax to convert a date expression from sql into your local time is not supported.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,258)