JSON to Collection for Choice/object column

(0) Share

Report

Posted on by Jedediah

183

Hello,

I have this app where I store a collection to JSON with this format to be used by PowerAutomate :

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "Categorie": {
 "type": "object",
 "properties": {
 "Value": {
 "type": "string"
 }
 }
 },
 "ID": {
 "type": "integer"
 },
 "PrixUnitaire": {
 "type": "integer"
 },
 "Quantite": {
 "type": "integer"
 },
 "Reference": {
 "type": "string"
 },
 "Titre": {
 "type": "string"
 }
 },
 "required": [
 "Categorie",
 "ID",
 "PrixUnitaire",
 "Quantite",
 "Reference",
 "Titre"
 ]
 }
}

"Categorie" is an object and specifically a Choice Column of a SharePoint List.

I then use this JSON in the same app to convert it back to the same collection for another usecase, but I can't figure out how to get the correct formula for the "Categorie" object.

Here is the code I use to collect the JSON, the other fields are collecting correctly, but I can't find the correct way to do it for "Categorie" :

 ClearCollect(
 colSpPanierCreationPoste;
 ForAll(
 Table(ParseJSON(ThisItem.PanierRaw));
 {
 ID: Value(Value.ID);
 Quantite: Value(Value.Quantite);
 Titre: Text(Value.Titre);
 OrdreTri: Value(Value.OrdreTri);
 Categorie: ???
 Reference: Text(Value.Reference);
 PrixUnitaire: Value(Value.PrixUnitaire);
 }
 )
)

Thank you 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
You can try the expression below. The schema says that the value of 'Categorie' is a record (object), with a single text property called Value:

ClearCollect( colSpPanierCreationPoste; ForAll( Table(ParseJSON(ThisItem.PanierRaw)); { ID: Value(Value.ID); Quantite: Value(Value.Quantite); Titre: Text(Value.Titre); OrdreTri: Value(Value.OrdreTri); Categorie: Text(Value.Categorie.Value) Reference: Text(Value.Reference); PrixUnitaire: Value(Value.PrixUnitaire); } ) )

Hope this helps!

Was this reply helpful? Yes No
Verified answer

Jedediah 183 on at

Like
a
(1)

Report
Copy link

Link copied!
Unfortunately, this doesn't work but...
You put me on the right track, since it's a record, I found the right syntax :
ClearCollect( colSpPanierCreationPoste; ForAll( Table(ParseJSON(ThisItem.PanierRaw)); { ID: Value(Value.ID); Quantite: Value(Value.Quantite); Titre: Text(Value.Titre); OrdreTri: Value(Value.OrdreTri); Categorie: {Value:Text(Value.Categorie.Value)}; Reference: Text(Value.Reference); PrixUnitaire: Value(Value.PrixUnitaire); Illustration: LookUp(colSpCatalogue;ID=Value(Value.ID)).Illustration } ) )

Thank you very much 🙂

Was this reply helpful? Yes No