Expression giving me trouble

[Ashfords]

In order to format some bullet pointed data in a way that it flows nicely from power apps into a word document, the data needs to be edited in power automate.

I wrote a simple (ish) expression to replace the html line breaks which come out of power apps to a uri format that word will know and use in its content controls

replace(outputs('supportingDocs'),'<br/>',uriComponentToString('%0A'))

This expression works like a charm and does exactly what i need it to do... apart from when data comes through blank and my flow breaks..

if(empty(outputs('supportingDocs')), "Not Supplied", replace(outputs('supportingDocs'),'<br/>',uriComponentToString('%0A')))

I looked at an if statement but this expression is apparently invalid and I can't quite put my finger on why.

Any help would be much appreciated!!

[v-chengfen-msft · Accepted solution]

Hi @Ashfords ,

The reason for this problem is:
1. You are using double quotes around Not Supplied

Please try :

if(empty(outputs('supportingDocs')), 'Not Supplied', replace(outputs('supportingDocs'),'<br/>',uriComponentToString('%0A')))

Best Regards

Cheng Feng

[Ashfords]

Wow. Knew it would be something simple like that. I had a long day alright!