web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Nested JSON - Get Dist...

Power Apps

Unanswered

Nested JSON - Get Distinct "tags" by id

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi All,

I have a JSON file and I want to get the Distinct "tags" of the user ID and display it on the Items property of the dropdown.

"tags" is in an array format.

Sample JSON generated from getting the ID of the user.

Sample code in the dropdown Items property.

How can I display the values of these two Result?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

shoog 2,164 on at

Like (2)

Report
Is it possible the JSON includes two id's or will it always be one?

If it's always just one, you could use

Distinct(First(collIt2).tags,Value).Result

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
Heya,

To account for any number of potential tags per item you have to get a bit wizardy:

With( { ConcatText: //Get a text string containing all tag items Concat( ForAll( projed, Concat( ThisRecord.Value.tags, Value & ";" ) ), Value ) }, Distinct( //Split the text string into items which then can be made distinct Split( //Don't include last ; so that no blank items Left( ConcatText, Len(ConcatText) - 1 ), ";" ), Result ) )

Included a POC App here for you to download - might be worth playing around with that to see if it will help 🙂

Cheers,

split subitems jS...

Was this reply helpful? Yes No

Join the conversation