Power Automate

Unanswered

Extract specific attributes of an array to form a new array

(0) Share

Report

Posted on by User_Naami

Hi,

I have the following a big Array that looks like this.

{

"body": [

{

"Date": "24/Apr/2023",

"Subject": "Maths",

"Start Time": "08:30 AM",

"End Time": "09:30 AM",

"Lunch Duration": 0

{

"Date": "24/Apr/2023",

"Subject": "Lunch",

"Start Time": "12:00 PM",

"End Time": "12:30 PM",

"Lunch Duration": 30

{

"Date": "24/Apr/2023",

"Subject": "English",

"Start Time": "02:30 PM",

"End Time": "03:30 PM",

"Lunch Duration": 0

}

{

"Date": "25/Apr/2023",

"Subject": "Maths",

"Start Time": "07:30 AM",

"End Time": "09:30 AM",

"Lunch Duration": 0

{

"Date": "25/Apr/2023",

"Subject": "Lunch",

"Start Time": "12:00 PM",

"End Time": "12:50 PM",

"Lunch Duration": 50

{

"Date": "25/Apr/2023",

"Subject": "English",

"Start Time": "01:30 PM",

"End Time": "03:30 PM",

"Lunch Duration": 0

}

]

}

I want to create a new Array that combines the first 3 attributes such that my new Array looks like this.

{

"body": [

{ "Date": "24/Apr/2023",
"Start Time": "08:30 AM",
"Lunch Duration": 30,
"End Time": "03:30 PM"
}

{ "Date": "25/Apr/2023",
"Start Time": "07:30 AM",
"Lunch Duration": 50,
"End Time": "03:30 PM"
}

]

}

I'm only interested in the "Date", "Start Time", "Lunch Duration" and "End Time" in that order. My original Array has that in this order.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @User_Naami

As per my understanding you are looking for reordering the 'body' array and save it in another array variable. To achieve this, you may use "Select" action for reordering the elements and then use the output of "Select" action to create a new array variable.

Sample flow with actions are as follows:

If it solves your problem then, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
User_Naami 82 on at

Like (0)

Report
Copy link

Link copied!

HI @ManishSolanki The logic does not work for me.

This is what my flow looks like that produces my array.

The result of my "Select" produces the following array:
{
    "body": [
        {
            "Date": "24/Apr/2023",
            "Subject": "Maths",
            "Start Time": "08:30 AM",
            "End Time": "09:30 AM",
            "Lunch Duration": 0
        },
        {
            "Date": "24/Apr/2023",
            "Subject": "Lunch",
            "Start Time": "12:00 PM",
            "End Time": "12:30 PM",
            "Lunch Duration": 30
        },
        {
            "Date": "24/Apr/2023",
            "Subject": "English",
            "Start Time": "02:30 PM",
            "End Time": "03:30 PM",
            "Lunch Duration": 0
        }
{
            "Date": "25/Apr/2023",
            "Subject": "Maths",
            "Start Time": "07:30 AM",
            "End Time": "09:30 AM",
            "Lunch Duration": 0
        },
        {
            "Date": "25/Apr/2023",
            "Subject": "Lunch",
            "Start Time": "12:00 PM",
            "End Time": "12:50 PM",
            "Lunch Duration": 50
        },
        {
            "Date": "25/Apr/2023",
            "Subject": "English",
            "Start Time": "01:30 PM",
            "End Time": "03:30 PM",
            "Lunch Duration": 0
        }

    ]
}

Was this reply helpful? Yes No