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.
{
"@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
}
