Power Platform Community Forum Thread Details

Getting 'Title' field values from JSON generated by Get Items

Hello Everyone,

I am a newbie in flow so please overlook my common mistakes. I am creating a flow and in that i am using 'Get Items' action to get the items of a list. After that i used 'Filter array' action to get the desired entries of the list. Now i am getting the output in JSON format and i dont know how should i get the values of 'Title' column. I have checked numerous posts on internet but couldn't figure out how to do it. I am attaching a pic of my flow and also the output of 'Filter Array'. The output have 3 entries but i am posting only one. Please help this newbie.

Flow Pic.png

{
 "@odata.etag": "\"9\"",
 "ItemInternalId": "1",
 "ID": 1,
 "Title": "My email ids are stored here",
 "Department": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 1,
 "Value": "deleted this"
 },
 "Department#Id": 1,
 "Modified": "2019-05-16T10:10:41Z",
 "Created": "2019-05-14T09:03:37Z",
 "Author": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|",
 "DisplayName": "Ankush Garg",
 "Email": "I have deleted this. ",
 "Picture": "deleted this/_layouts/15/UserPhoto.aspx?Size=L&AccountName=deleted this",
 "Department": "Information Technology",
 "JobTitle": "Sharepoint Developer"
 },
 "Author#Claims": "i:0#.f|membership|deleted this",
 "Editor": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|deleted this",
 "DisplayName": "Ankush Garg",
 "Email": "deleted this",
 "Picture": "deleted this/_layouts/15/UserPhoto.aspx?Size=L&AccountName=deleted this",
 "Department": "Information Technology",
 "JobTitle": "Sharepoint Developer"
 },
 "Editor#Claims": "i:0#.f|membership|deleted this",
 "{Identifier}": "Lists%252fStateandApprovers%252f1_.000",
 "{IsFolder}": false,
 "{Thumbnail}": {
 "Large": null,
 "Medium": null,
 "Small": null
 },
 "{Link}": "deleted this/_layouts/15/listform.aspx?PageType=4&ListId=deleted this9B82D2E8050DDEC",
 "{Name}": "deleted this",
 "{FilenameWithExtension}": "deleted this",
 "{Path}": "Lists/StateandApprovers/",
 "{HasAttachments}": false
 }

Quick Links

Leaderboard