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 / How do i get a value f...
Power Automate
Unanswered

How do i get a value from Parse JSON in an array format?

(0) ShareShare
ReportReport
Posted on by 107

Hello everyone, i am trying to get the author value from Parse JSON. 

CYJ_0-1592884580265.png

I am getting a null value. How do i retrieve the value and store it in array?

Categories:
  • Rahber Profile Picture
    1,935 on at
    Hello,

    Can you please show your JSON format so we can better guide you how can you get the author value after parsing JSON?
  • CYJ Profile Picture
    107 on at

    Hi @Rahber ,

     

    Do you mean this?

     
     
    {
      "type": "object",
      "properties": {
        "d": {
          "type": "object",
          "properties": {
            "__metadata": {
              "type": "object",
              "properties": {
                "id": {
                  "type": "string"
                },
                "uri": {
                  "type": "string"
                },
                "etag": {
                  "type": "string"
                },
                "type": {
                  "type": "string"
                }
              }
            },
            "FirstUniqueAncestorSecurableObject": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "RoleAssignments": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "AttachmentFiles": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "ContentType": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "GetDlpPolicyTip": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "FieldValuesAsHtml": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "FieldValuesAsText": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "FieldValuesForEdit": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "File": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Folder": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "LikedByInformation": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "ParentList": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Properties": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "Versions": {
              "type": "object",
              "properties": {
                "__deferred": {
                  "type": "object",
                  "properties": {
                    "uri": {
                      "type": "string"
                    }
                  }
                }
              }
            },
            "FileSystemObjectType": {
              "type": "integer"
            },
            "Id": {
              "type": "integer"
            },
            "ServerRedirectedEmbedUri": {},
            "ServerRedirectedEmbedUrl": {
              "type": "string"
            },
            "ContentTypeId": {
              "type": "string"
            },
            "Title": {
              "type": "string"
            },
            "ComplianceAssetId": {},
            "Group": {
              "type": "string"
            },
            "Division": {
              "type": "string"
            },
            "Company": {
              "type": "string"
            },
            "Category": {
              "type": "string"
            },
            "Content": {
              "type": "string"
            },
            "Status": {
              "type": "string"
            },
            "Date": {
              "type": "string"
            },
            "List_x0020_Created_x0020_By": {
              "type": "string"
            },
            "List_x0020_Modified_x0020_By": {},
            "List_x0020_Created": {
              "type": "string"
            },
            "List_x0020_Modified": {},
            "Author0": {},
            "Readers": {},
            "ID": {
              "type": "integer"
            },
            "Modified": {
              "type": "string"
            },
            "Created": {
              "type": "string"
            },
            "AuthorId": {
              "type": "integer"
            },
            "EditorId": {
              "type": "integer"
            },
            "OData__UIVersionString": {
              "type": "string"
            },
            "Attachments": {
              "type": "boolean"
            },
            "GUID": {
              "type": "string"
            }
          }
        }
      }
    }
  • Rahber Profile Picture
    1,935 on at
    Your schema does look fine.

    For the actual content you are passing in the Parse Json function. Does it have a Author value?
  • CYJ Profile Picture
    107 on at

    Hi @Rahber ,

     

    Ya it does

  • Rahber Profile Picture
    1,935 on at
    So having a close look i found out that your schmea could be generated wrong
    "Author0": {},

    In your schema there is no type defined for Author0 that is why its always giving an null value.

    So i am using https://json-schema-faker.js.org/#

    and you will see that if you generate a JSON against your schema there will be not author field but as i mentioned if you add type string to it it will generate the value..

    Can you please share the actual JSON content?
  • CYJ Profile Picture
    107 on at
    Hi @Rahber ,
     
    For privacy issue, i have remove the uri and btw i have checked that the Parse JSON content. It has the following author value.
     
    {
      "d": {
        "__metadata": {
          "id": "(has value)",
          "uri": "/Items(50)",
          "etag": "\"2\"",
          "type": "SP.Data.Business"
        },
        "FirstUniqueAncestorSecurableObject": {
          "__deferred": {
            "uri": "https:///Items(50)/FirstUniqueAncestorSecurableObject"
          }
        },
        "RoleAssignments": {
          "__deferred": {
            "uri": ""
          }
        },
        "AttachmentFiles": {
          "__deferred": {
            "uri": ""
          }
        },
        "ContentType": {
          "__deferred": {
            "uri": ""
          }
        },
        "GetDlpPolicyTip": {
          "__deferred": {
            "uri": ""
          }
        },
        "FieldValuesAsHtml": {
          "__deferred": {
            "uri": ""
          }
        },
        "FieldValuesAsText": {
          "__deferred": {
            "uri": ""
          }
        },
        "FieldValuesForEdit": {
          "__deferred": {
            "uri": ""
          }
        },
        "File": {
          "__deferred": {
            "uri": ""
          }
        },
        "Folder": {
          "__deferred": {
            "uri": ""
          }
        },
        "LikedByInformation": {
          "__deferred": {
            "uri": ""
          }
        },
        "ParentList": {
          "__deferred": {
            "uri": ""
          }
        },
        "Properties": {
          "__deferred": {
            "uri": ""
          }
        },
        "Versions": {
          "__deferred": {
            "uri": ""
          }
        },
        "FileSystemObjectType": 0,
        "Id": 50,
        "ServerRedirectedEmbedUri": null,
        "ServerRedirectedEmbedUrl": "",
        "ContentTypeId": "",
        "Title": "test2",
        "ComplianceAssetId": null,
        "Group": "group1",
        "Division": "division1",
        "Company": "company1",
        "Category": "Minutes of Meeting",
        "Content": "<div class=\"ExternalClass4340FC45B384498A92E2A418D2391159\"><p>test</p></div>",
        "Status": "Created",
        "Date": "2020-06-04T16:00:00Z",
        "List_x0020_Created_x0020_By": "User1",
        "List_x0020_Modified_x0020_By": "User1",
        "List_x0020_Created": "6/23/2020 11:29 AM",
        "List_x0020_Modified": "6/23/2020 11:32 AM",
        "Author0": "User2",
        "Readers": null,
        "ID": 50,
        "Modified": "2020-06-23T03:47:05Z",
        "Created": "2020-06-23T03:36:20Z",
        "AuthorId": 8,
        "EditorId": 8,
        "OData__UIVersionString": "1.0",
        "Attachments": false,
        "GUID": ""
      }
    }
  • Rahber Profile Picture
    1,935 on at

    Hi,

    I just tried the exact same JSON in my flow and it worked pretty well and i got the User2 value as author.

    Can you try by regenerating the schema again with this json payload and remove the Author0 variable and then re add again.

    if you would like i can have a look at your flow. Otherwise let me know i can send you an exported flow.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 424

#2
11manish Profile Picture

11manish 328 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard