GroupBy and JSON functions

(1) Share

Report

Posted on by MarkBaker

I'm trying to pass some json to power automate.

I want to group jobs by the column cr213_job and then inside list the dump details

I have a button with the on select property set to: (not getting desired output)

ClearCollect(
 GroupedData,
 GroupBy('CCDD Dump Approvals', "cr213_job", "GroupedRecords")
);

ClearCollect(
 GroupedDataDetails,
 ForAll(
 GroupedData,
 {
 'job': cr213_job,
 'DumpApprovals': Concatenate(
 "[",
 Concatenate(
 Filter('CCDD Dump Approvals', "cr213_job" = "job"),
 JSON(
 {
 'name': 'Dump Site',
 'code': 'Dump Code',
 'notes': 'Notes',
 'quanity': 'Quantity',
 'enddate': 'End Date'
 }
 ),
 If(job<> Last(GroupedData).job, ",", "")
 ),
 "]"
 )
 }
 )
);

GroupedDataDetails

this is my desired output:

[
 {"approvals": [
 {
 "job": "",
 "dumpsites": [
 {
 "name": "",
 "code": "",
 "quanity": "",
 "notes": "",
 "enddate": ""
 }
 ]
 },
 {
 "job": "",
 "dumpsites": [
 {
 "name": "",
 "code": "",
 "quanity": "",
 "notes": "",
 "enddate": ""
 },
 {
 "name": "",
 "code": "",
 "quanity": "",
 "notes": "",
 "enddate": ""
 }
 ]
 }
 
 ]
 }

How can I do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Kristian_Cole 195 on at

Like (0)

Report
Copy link

Link copied!

I used this quite recently, answer was from another thread:

"
Create a flow like this:

Then, in PowerApps use a ClearCollect(colName, FlowName.Run("JSON Data you want to convert to a collection"))
"

hope this helps!!

Was this reply helpful? Yes No
MarkBaker 45 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply. My problem is creating the collection. How do I create the collection? My code has errors.

Was this reply helpful? Yes No
Kristian_Cole 195 on at

Like (0)

Report
Copy link

Link copied!

Have you tried creating a flow with the parse json function, copy your json into it, run your output should highlight the errors.

Was this reply helpful? Yes No
Verified answer

MarkBaker 45 on at

Like (0)

Report
Copy link

Link copied!
At that point in time I didn't have any json to send to Power Automate. I was having issues with creating the Collection.
I got it to work with this and no power automate needed.
ClearCollect( ResultCollection, ForAll( 'CCDD Dump Approvals', { CCDDJobName: LookUp( CCDDjobs, 'Job ID' = 'CCDD Dump Approvals'[@'Job ID'] ).Address, MaterialSiteName: LookUp( 'Material Sites', ID = 'CCDD Dump Approvals'[@'Material Site ID'] ).Name, DumpCode: 'CCDD Dump Approvals'[@'Dump Code'], Quantity: 'CCDD Dump Approvals'[@Quanity], Notes: 'CCDD Dump Approvals'[@Notes], EndDate: DateValue('CCDD Dump Approvals'[@'End Date']) } ) ); ClearCollect( GroupedResultCollection, GroupBy( ResultCollection, "CCDDJobName", "GroupedRecord" ) ); Set( CCDDReport, JSON(GroupedResultCollection) );

Was this reply helpful? Yes No