Power Platform Community Forum Thread Details

I'm trying to use the following code and I can't make it to work as it refuses to group by

It does not recognise the dev- columns

Initially, the data was stored in a dataverse table but I'm trying to workout the code with a sharepoint list with the same schema

Any support Please

Substitute(

JSON(

Table(

ShowColumns(

Filter(dataGroups, IsBlank(nested) && !IsBlank(id) && !IsBlank(content)),

id,

content

DropColumns(

AddColumns(

GroupBy(

ShowColumns(

Filter(dataGroups, !IsBlank(nested)),

id,

content,

nested,

visible

dev_id,

dev_content,

dev_visible,

dev_nested

nestedGroups,

"["&Concat(

dev_nested,

"""" & dev_nested & """", ","

)&"]"

dev_nested

)), JSONFormat.IndentFour

)

,"dev_",""),

"\",""),

"""[","["),

"]""","]")

Categories:

Building Power Apps

Community site session details

Help with Json

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates