Hi,
I am facing a problem while exporting a collection data to csv.
There is a column having 0 as a first index value,. i.e., 08700010. While exporting to csv the zero are getting vanished from the column.
I tried this formula
string(<Dynamic Content>)
It is working but i don't want the column to have <> symbols as prefix and suffix.
Is there any alternative way?
Thanks
Solved! Go to Solution.
Please go back to my very first post - Excel is interpreting it as a number when it opens the file. You need to put the number in Quotes "" in Power Apps before you send it to Excel.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @Sravani_Balla ,
You did not say how you were exporting to CSV, but I suspect the issue is Excel interpreting the column as a number. If you open the CSV in Notepad, is the zero still there ?
Hi Warren,
I am sending collection as an to the flow and converting that to csv and provided it to the create csv table and creating file using the output.
In the SharePoint the column is a single line text as the column can have alphabet and number combination.
While I tried to open the csv file in the notepad I am able to see the 0 as prefix while I couldn't see the 0 as prefix in the csv.
Can we do something the power automate itself ?
Thanks
Hi @Sravani_Balla ,
I am a little confused - when you say open the csv file in the notepad I am able to see the 0 as prefix if I am reading correctly, the CSV has worked (which I suspected it would). What are you opening it in where you cannot see the leading zero ?
Hi Warren,
open the csv file in the notepad I am able to see the 0 as prefix- This mean we can right click on any csv file and got to open with and select notepad and check the data inside right. I am able to see the 0as prefix over there.
You can see the difference here.
Notepad
CSV
Please go back to my very first post - Excel is interpreting it as a number when it opens the file. You need to put the number in Quotes "" in Power Apps before you send it to Excel.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
User | Count |
---|---|
261 | |
130 | |
99 | |
48 | |
47 |