I have a sharepoint list that I have created a flow button i powerapps to export a filtered csv. It works, except some of my multiple choice drop downs are giving me the @OData string instead of the value. When I look for the value field there is no such option for the perticular item. This is how the exported table looks like (example of some of the columns):
| IntrasisId | Subklasse jf nettbrett | Fyllmateriale jf nettbrett | Observasjon jf nettbrett | Dato beskrevet |
| 300 | Røys | [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":8,"Value":"stein"}] | [] | 23.08.2022 |
| 688 | Annet | [] | [] | 01.09.2022 |
I have seen some solutions that suggests parsing to JSON, but all those solutions are very complex and break at some point as they are very specific to the examples they are from.
Could there be a problem with my dataset, or is there something with my settings in sharepoint? The only difference is that the "Fyllmateriale" and "Observasjoner" is multiple choice check box, while Subclass/Strukturtype is drop down menu. Is this the cause of the problem?
