Parse JSON of a SharePoint Choice field, Problem If empty

[BClouded]

Hi Community

I'm trying to parse some values from PowerApps to an Excel Table.
Most of it works, but when a choice field is empty it gives an error that it cannot find the value.
I tried the change the code in the Add a row into a table action like this:
If Secteur is empty -> " None Selected", else give me the value.

if(empty(items('Apply_to_each_2')?['Secteur']),"None Selected",items('Apply_to_each_2')?['Secteur']['Value'])

but it's not working. Any idea what i'm doing wrong here? 

Thanks a lot!
Bart

[Expiscornovus · Accepted solution]

Hi @BClouded,

I think you are using the Secteur field instead of the Secteur Value field.

Can you try and use the expression below:

if(empty(items('Apply_to_each_2')?['Secteur/Value']), 'None Selected', items('Apply_to_each_2')?['Secteur/Value'])

[BClouded]

Thanks a lot, it's working now!
i didn't knew you could also reference to the value with /Value

[Expiscornovus]

To be clear, that's only the syntax for a choice field 🙂

Normally a choice field value would be something like below. So, basically you are retrieving the value property of the choice field value 😉

"Secteur": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      "Id": 0,
      "Value": "A"
}