Power Platform Community Forum Thread Details

Hi,

I have the output below from a 'Filter Array' action. I want to restructure it so that It can be used to update a Sharepoint List.

Any help with this would be massively appreciated!

It's currently structured like this:

fieldTitle	fieldReferenceId	fieldValue	sectionTitle	sectionReferenceId	repeatedSectionIndex
TM Item	7d6f6fa9-676d-43b2-8f01-0961c0a61813	Lane closure	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	1
Road speed	0d593880-f3ee-48fa-8d22-9501ccdd2004	40mph	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	1
Manual control	134662bf-7023-4186-ac4e-43be626c442d	Yes	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	1
Manual control	134662bf-7023-4186-ac4e-43be626c442d	No	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	0
Road speed	0d593880-f3ee-48fa-8d22-9501ccdd2004	30mph	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	0
TM Item	7d6f6fa9-676d-43b2-8f01-0961c0a61813	2-way lights	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	0
Add Another TM Item?	f88769ba-2e7e-41b5-b6e3-26a14d6aaa40	Yes	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	0
Add Another TM Item?	f88769ba-2e7e-41b5-b6e3-26a14d6aaa40	No	TM Items	fa40b461-d5d9-498d-a76d-55217dd4fac4	1

And i want it restructured like this:

repeatedSectionIndex	TM Item	Road speed	Manual control
0	2-way lights	30mph	No
1	Lane closure	40mph	Yes

Below is the raw output from the Filter Array action:

{
    "body": [
        {
            "fieldTitle": "TM Item",
            "fieldReferenceId": "7d6f6fa9-676d-43b2-8f01-0961c0a61813",
            "fieldValue": "2-way lights",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 0
        },
        {
            "fieldTitle": "Road speed",
            "fieldReferenceId": "0d593880-f3ee-48fa-8d22-9501ccdd2004",
            "fieldValue": "30mph",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 0
        },
        {
            "fieldTitle": "Manual control",
            "fieldReferenceId": "134662bf-7023-4186-ac4e-43be626c442d",
            "fieldValue": "No",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 0
        },
        {
            "fieldTitle": "Add Another TM Item?",
            "fieldReferenceId": "f88769ba-2e7e-41b5-b6e3-26a14d6aaa40",
            "fieldValue": "Yes",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 0
        },
        {
            "fieldTitle": "TM Item",
            "fieldReferenceId": "7d6f6fa9-676d-43b2-8f01-0961c0a61813",
            "fieldValue": "Lane closure",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 1
        },
        {
            "fieldTitle": "Road speed",
            "fieldReferenceId": "0d593880-f3ee-48fa-8d22-9501ccdd2004",
            "fieldValue": "40mph",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 1
        },
        {
            "fieldTitle": "Manual control",
            "fieldReferenceId": "134662bf-7023-4186-ac4e-43be626c442d",
            "fieldValue": "Yes",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 1
        },
        {
            "fieldTitle": "Add Another TM Item?",
            "fieldReferenceId": "f88769ba-2e7e-41b5-b6e3-26a14d6aaa40",
            "fieldValue": "No",
            "sectionTitle": "TM Items",
            "sectionReferenceId": "fa40b461-d5d9-498d-a76d-55217dd4fac4",
            "repeatedSectionIndex": 1
        }
    ]
}

Categories:

Business Process Flows