Hello,
I have a very large Sp List, that contains many kinds of data, especially single line and multiple choices. Single line works fine for my thing, but multiple choice is giving me a headache.
Currently my flow extracts all columns that have changed since the last time it was modified and puts everything into a dedicated column so that I can keep track of what was changed through the record's lifetime.
It looks something like this:
[Date of the change]
Name of the column that was changed: new value,
name of the column that was changed: new value
The problem here is that if a multiple choice field changes I have a whole JSON to deal with.
My flow get the item that corresponds to the specific column that was changed, so for a single line works great, for multiple choice fields I get this:
[Date of the change]
Name of the column that was changed: {"Whole JSON":"With data that I don't need", "Value that I need":"at the end"}
How could I extract that "Value" at the end of the JSON in a simple way?
Sorry if the question isn't clear, I'd be happy to clear things up for you, just ask
Thank you
