web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Array from JSON Objects
Power Automate
Answered

Array from JSON Objects

(0) ShareShare
ReportReport
Posted on by 22

I am building a flow that receives a JSON payload from an API, I want to add these daily to a MS List.  Problem it is coming in as individual objects.  My understanding of JSON and  API's but here is part of my schema

 

{
    "type""object",
    "properties": {
        "100271": {
            "type""object",
            "properties": {
                "Branch": {
                    "type""string"
                },
                "Name": {
                    "type""string"
                },
                "BigCBasics": {
                    "type""string"
                },
                "Progress": {
                    "type""string"
                },
                "Assigned": {
                    "type""string"
                },
                "Completed": {
                    "type""string"
                },
                "CertificateDate": {
                    "type""string"
                },
                "RewardDate": {
                    "type""string"
                }
            }
        },
 
 
There are several of those 6 digit numbers 1 for each person actually... What I would like to do is just take the information for each person and put into the list.  Parsing the JSON just makes a variable for every single one.  Any insight would be amazing.  Thanks
Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @AmriiBacchus 

     

    So you want to extract Branch, Name, BigCBasics, Progress, etc against the six digit numbers 100271 and create a record in SharePoint list? Could you also provide some sample JSON data? 

     

    Thanks

  • AmriiBacchus Profile Picture
    22 on at

    Actually I would prefer to make a record for each one of the numbers which there are several.  So an array that creates an item in SP for each one of those groups, I cannot use the number since it will have to be rewritten each time someone is added.  I think there is something like 40 unique numbers each containing those strings inside. 

  • AmriiBacchus Profile Picture
    22 on at

    Here is a portion with actual data

     

     

     

    },
    "104267": {
    "Branch": "SB",
    "Name": "Miss",
    "BigCBasics": "Inside Sales",
    "Progress": "100%",
    "Assigned": "2022/10/13",
    "Completed": "2022/04/19",
    "CertificateDate": "2022/04/20",
    "RewardDate": "2022/04/20"
    },
    "104285": {
    "Branch": "Ke",
    "Name": "Dustin ",
    "BigCBasics": "Yard & Driver",
    "Progress": "5.56%",
    "Assigned": "2022/10/14",
    "Completed": "n/a",
    "CertificateDate": "n/a",
    "RewardDate": "n/a"
    },

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @AmriiBacchus 

     

    Thanks for providing the data. So every time these numbers (104267, 104285)  can get changed? Do you have a definitive list of all 40 unique numbers?

     

     

  • AmriiBacchus Profile Picture
    22 on at

    Yes I gave access to all the numbers 

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @AmriiBacchus 

     

    I will work on a flow based on the data above and post something soon.

     

    Thanks

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @AmriiBacchus 

     

    Do you need to insert those six digit numbers also in your list?

  • AmriiBacchus Profile Picture
    22 on at

    I do not, in fact prefer the numbers to not be a factor as new ones will often be introduced.  

  • Verified answer
    abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @AmriiBacchus 

     

    I made a tutorial video based on this. Please have a look and let me know.

     

    https://youtu.be/8Se_yZqpN60

     

     

    Thanks

  • AmriiBacchus Profile Picture
    22 on at

    Great thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 809

#3
Haque Profile Picture

Haque 645

Last 30 days Overall leaderboard