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:
Solved! Go to 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.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @garethaw
Use the expression replace(variables('yourvariablename'),' ','')
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogWhere do I put the expression in my flow?
Hi @garethaw
Please see below
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogMy input is not a variable it's an array value of PropertyID?
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogdon't understand?
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.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThank you very much,
This Worked:
User | Count |
---|---|
100 | |
37 | |
26 | |
23 | |
16 |
User | Count |
---|---|
132 | |
52 | |
48 | |
36 | |
24 |