Answered

How to add DisplayName to a JSONResponse to display choices

(0) Share

Report

Posted on by MiguelMeloOP

Hello,

In a custom plugin i'm calling an API to retrieve a list of items, and i would like those items to be displayed as choices for the user in a DynamicClosedListEntity.

The items are in a table type variable, and i know that to be displayed as choices, each item must have a DisplayName property.

So i want to add this property for each item and to set its value to a concatenation of some of its properties.

I suppose the best way to achieve this is to rebuild a new variable in a SetVariable block, but i'm struggling in vain with FX functions.

Is there anyone to help me?

Thank you

Categories:

Topic creation & management

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

HenryJammes Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MiguelMeloOP

What does your JSON look like?
In the set variable node, using Power Fx, you could use a variation of this formula:

ForAll( Topic.MyTable, { DisplayName: name, OtherProperty: property, ID: id } )

Was this reply helpful? Yes No
MiguelMeloOP 6 on at

Like (0)

Report
Copy link

Link copied!
The JSON comes from this mocked API and it looks like this:
[ { "id": 1, "name": "Pizza Heaven", "address1": "Kungsgatan 1", "address2": "111 43 Stockholm", "latitude": 59.336078, "longitude": 18.071807 }, { "id": 2, "name": "Pizzeria Apan", "address1": "Långholmsgatan 34", "address2": "117 33 Stockholm", "latitude": 59.315709, "longitude": 18.033507 } ]

So does it mean that i have to manually re-assign each known property?

Was this reply helpful? Yes No
HenryJammes Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Yes, I think so. Although I don't know if there's a better way to rename a table property in Power Fx?

Was this reply helpful? Yes No