Removing spaces from SharePoint list

[garethaw]

Hi,

I have built a flow to export SharePoint list to csv, I would like to remove the spaces within the property name values.

The function needs to convert 19 Longworth Road to 19LongworthRoad.

Please can you assist? Here is my flow: 

 

[abm]

Hi @garethaw 

Use the expression replace(variables('yourvariablename'),' ','')

Thanks

[garethaw]

Where do I put the expression in my flow?

[abm]

Hi @garethaw 

Please see below

[garethaw]

My input is not a variable it's an array value of PropertyID?

[abm]

Hi @garethaw 

If its an array you may need an Apply to each action step to iterate the values. Inside the loop you can use the expression which I shown earlier.

Thanks

[garethaw]

don't understand?

[abm · Accepted solution]

Hi @garethaw 

Not quite right. Couple of ways you could do this.

Here under the mapping you could try the expression OR under the apply to each loop use the item() expression for each value.

[garethaw]

Thank you very much,

This Worked: