Add a row to Excel and add prefix only if dynamic content has value

[Silje85]

Hello. I'm building a flow and it works fine, but I want to add a prefix to the coloumn in Excel ONLY if there is value in the dynamic content from dataverse. How do I do this? 

For this coloumn, if there is content in dataverse for Care of, then I want to add the prefix CO : 

[ManishSolanki]

Hi @Silje85 

You may use expression to add prefix to the dynamic value if it is not empty:

if(empty(<dynamic care of value>),'',concat('CO',<dynamic care of value>))

pls replace dynamic value with value of 'care of' column from dataverse.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[Silje85]

Hello and thanks for the suggestion. However, I strugge a bit, because when I use the expression, my dynamic values from Dataverse are not there anymore as you can see in the screenshots below. 

When I just insert the row it's fine and there. As soon as I start typing an expression it's not there. 

I'm probably doing something wrong, but not sure what? 

[ManishSolanki · Accepted solution]

Hi @Silje85 

Pls use 'Expression' window to add an expression. Here is an example of 'Contact' table:

if(empty(item()?['address1_postalcode']),'',concat('CO',item()?['address1_postalcode']))

pls replace the column name with actual column name in the above expression. You need to replace with logical name of the column.

To get the logical name, navigate to Tables->Contact->Columns. Click the column name. You can see the logical name in the right panel window:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[Silje85]

Thank you very much. I now got the expected result. So how do I write the code if I want the row to be empty if the country equals Norway, but I want it spelled out if it's an other country? Can you help me finish this sentence? 

if(equals(item()?['pp_countrycode']

[ManishSolanki · Accepted solution]

Pls try the below expression. This expression will return empty string if input is 'Norway' else returns the actual value of input:

if(equals(item()?['pp_countrycode'],'Norway'),'',item()?['pp_countrycode'])

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.