Power Platform Community Forum Thread Details

I am trying to extract the string text "Complete" from a format like this => {"Status":"Complete"}.

My formula below is extracting the string like so => :"Complete"}

How can i improve my formula to only get a clean text such as Complete?

Thanks !

subString(variables('DataVar'),indexOf(variables('DataVar'),':'),sub(length(variables('DataVar')),indexOf(variables('DataVar'),':')))

Categories:

parsing key value pair object to string