You could take a try with expression below:
I have made a test on my side to create a flow as below:
The expression in the Compose 2 as below:
The flow would run successfully as below:
Thanks for the response, but the solution you provided does not work when pulling values from a SharePoint list and then placing them into a CSV.
To restate the problem, I want the csv export to look like this (for example):
Smith,John,16 Main St.,Portland,ME,"04101",Anesthesiologist, etc.
(I need the zip code in quotes so preceeding zeros will not be stripped off when opened in excel. )
The solution you provided casues this result:
Smith,John,16 Main St.,Portland,ME,"""04101""",Anesthesiologist, etc. (this does not render right in excel)
I've pasted my test flow below to demonstrate. The value in the sharepoint list is simply 04106.
Would you please add a () to the value as below:
Or you could add a space before the value as below:
the Flow I'm trying to build gets data from SharePoint and uploads a CSV to SFTP where the file will be processed by one of our Finance systems. This systems expects every value in the CSV to be surrouned by double quotes so
I open the CSV in Notepad, rather than Excel to see the format.
My Flow looks like this, and in the Concat I've tried setting a value to:
This results in """1""","""Name""" rather than "1","Name"
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need
Find out where you can attend!
Watch & learn from the Flow Community Video Gallery!