Power Platform Community Forum Thread Details

Hi There,

I need some support to filter the array based on the latest date.

Sample Array:

Spoiler (Highlight to read)

[

{
"ParentID":"CRQ000030752389",
"Attachment Name":"updated DP.xlsx",
"WorkInfoSubmitDate":"2023-07-03T15:29:48+02:00",
"WorkInfoSummary":"DP Updated"
},

{
"ParentID":"CRQ000030752389",
"Attachment Name":"Blank",
"WorkInfoSubmitDate":"2023-06-03T13:24:45+02:00",
"WorkInfoSummary":"This ticket was created from the service request system."
},

{
"ParentID":"CRQ000030752389",
"Attachment Name":"DP.xlsx",
"WorkInfoSubmitDate":"2023-05-03T12:12:30+02:00",
"WorkInfoSummary":"DP Attached"
}

]

[{"ParentID":"CRQ000030752389","Attachment Name":"updated DP.xlsx","WorkInfoSubmitDate":"2023-07-03T15:29:48+02:00","WorkInfoSummary":"DP Updated"},{"ParentID":"CRQ000030752389","Attachment Name":"Blank","WorkInfoSubmitDate":"2023-06-03T13:24:45+02:00","WorkInfoSummary":"This ticket was created from the service request system."},{"ParentID":"CRQ000030752389","Attachment Name":"DP.xlsx","WorkInfoSubmitDate":"2023-05-03T12:12:30+02:00","WorkInfoSummary":"DP Attached"}]

Required Output Array:

Spoiler (Highlight to read)

[

{
"ParentID":"CRQ000030752389",
"Attachment Name":"updated DP.xlsx",
"WorkInfoSubmitDate":"2023-07-03T15:29:48+02:00",
"WorkInfoSummary":"DP Updated"
}

]

[{"ParentID":"CRQ000030752389","Attachment Name":"updated DP.xlsx","WorkInfoSubmitDate":"2023-07-03T15:29:48+02:00","WorkInfoSummary":"DP Updated"}]

Regards,

Categories:

Building flows