Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Get rid of junk data in Textbox

Hi Power Apps community,


I am using Flow to return data in Power Apps. I have a Textbox were the returned data will be displayed in Power Apps. However, the data is returned with a lot of junk data. This is my current Text in the Textbox:

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"Cost Of Goods Sold"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"Bank Statement"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"Cash Flow"}]

I only need to display Cost Of Goods Sold, Bank Statement, Cash Flow.

My logic was to set the: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":" as a string in order to use the Replace function to clean the junk. But I cannot even start the put the above data as a string due to the multiple double quotes. 


Can someone at least help me this data ( [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":") as a string?




You can leverage Parse JSON action to fetch only the value part from the response and pass the output to PowerApps.


Please refer to the article below:





Hi @rohsh354 thanks for the reply and your help,


I have used the steps in the article that you have shared with me, and the junk data have cleared perfectly. But I am using two text boxes, and one of the text boxes return data from a column which is a CheckBox in SharePoint. I have use the Parse JSON according to the steps in the article but when I tried to select the value of the Parse JSON from Dynamic, it won't add the value in the Return to Power Apps column. Further, I also get this error:

The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach.

 I think due the fact that the SharePoint column is a checkbox and it can contains more than one answer, is causing this problem. Because the other text box have worked perfectly and has returned the data clean.


Do you know any further information that can help me solve this error? 

Thanks in advance.


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (58,973)