An Issue With Double Quotes In String Values

This thread has been locked for new comments by a moderator, if you have a new similar issue then please start a new thread.
Copper Contributor

I am a software engineer that is going to be tasked with debugging a power app.


The app currently acquires a CSV file from an email account and parses it into a JSON file and then uses that file to load a power point list. And from there, the data is loaded into another file. The bug seems to be that character strings are altered by having double quotes at the beginning and end of the strings. This causes a logical flaw since strings are used in comparison and so we can get a false negative when we are comparing two strings which should be identical.


Is there a simple command which strips double quotes from strings that can be incorporated in a power BI set of steps?


5 Replies

@wm-thompson You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions.


Unfortunately we don't really have an area I can direct you to for this question, as Power Apps content is typically posted in a different community.


Feel free to check out the Power Apps community to ask your question: Power Apps Community - Power Platform Community (

Mich stört das ich jedes Mal auf Microsoft auf Deutsch Umstellen muss Seite für Seite



Thank you for your feedback, the Microsoft Tech Community is an English only website I am afraid, Microsoft does have localized support channels via

Hello wm-thompson,

What language is the app written in. I have yet to come across a programming language that did not have some sort of string manipulation (object, process, etc...). For instance, in VB (any version), you could remove the double quotes with something akin to this:
'in your parse routine
Dim myStr As String
myStr = Replace(stringWithQuotes,"""","")

Full transparency here; I know next to nothing about Power BI