cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
guyinkalamazoo
Helper III
Helper III

JSON to SharePoint Create Item help needed

I have the following json schema and it is creating the proper json file needed

{
    "type": "array",
    "items": {
        "type":"object",
        "properties": {
            "Order Key": {
                "type": ["string","null"]
            },
            "Omar Order Number": {
                "type": ["string","null"]
            },
            "Order Type Key": {
                "type": ["string","null"]
            },
            "MAT Type Key": {
                "type": ["string","null"]
            },
            "Order Plant": {
                "type": ["string","null"]
            },
            "Omar Status Code": {
                "type": ["string","null"]
            },
            "MDSI  Job Code": {
                "type": ["string","null"]
            },
            "Omar Reason Code Key": {
                "type": ["string","null"]
            },
            "Omar Tech ID": {
                "type": ["string","null"]
            },
            "Field Comments": {
                "type": ["string","null"]
            },
            "Number of Records": {
                "type": ["string","null"]
            }
        }
    }
}

My struggle has been trying to use the output of this file to iterate through its records and just create a new list item in an online SharePoint list.  I did an apply to each and a Create Item.  However, with mapping the fields in SharePoint to those item properties in the json parsed file is not even showing up as an option.  I even did a Compose right after the Parse Json activity and it is not working.

 

Thanks for any direction in this as I have been banging my head on a wall for the most of this day. 

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @guyinkalamazoo ,

 

You can use the Parse JSON action and paste your schema in.  You can then access the dynamic content in Create Items

 

Screenshot_20210925-120149_Chrome.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @guyinkalamazoo ,

 

You can use the Parse JSON action and paste your schema in.  You can then access the dynamic content in Create Items

 

Screenshot_20210925-120149_Chrome.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

Yes, I have already done that.  And Parsing JSON is delivering the proper file.  When I go into map the fields from the SharePoint list, nothing from the Parse JSON outputs are showing in the dynamic display.  Can these be manually entered?  And if so, what is the syntax?  Would it be something like outputs('json')?{items}[0]?

 

Thanks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,269)