cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmriiBacchus
Frequent Visitor

Array from JSON Objects

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
1 ACCEPTED SOLUTION

Accepted Solutions

Hi @AmriiBacchus 

 

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

 

https://youtu.be/8Se_yZqpN60

 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

10 REPLIES 10
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
AmriiBacchus
Frequent Visitor

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
Frequent Visitor

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"
},

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?

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Yes I gave access to all the numbers 

Hi @AmriiBacchus 

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @AmriiBacchus 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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

Hi @AmriiBacchus 

 

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

 

https://youtu.be/8Se_yZqpN60

 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Great thank you!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,129)