Power Automate- Parse JSON- Power Apps- SharePoint Choice Column Value - Clean up Parse JSON output

Submitted by leader on Tue, 10/21/2025 - 21:08

My Parse JSON action was giving me this:
"{""Value"":""Allentown""}" as my text Value for my CSV

I needed only > Allentown

AFTER, the Parse JSON action, I added a Compose action and added this expression to get what I needed from the JSON.
Here is the expression:

body('Parse_JSON')?[0]?['Columns Name Here']?['Value']

The results:

 

Blog Type: