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

Re: Compose Expressions rendering as plain text on import

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

Re: Compose Expressions rendering as plain text on import

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


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!


Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (8,206)