Share
Report
62Hi all.
I have built a setup where a cloud flow triggers a desktop flow and sends across a selection of items from a sharepoint list as an input trigger. In the desktop flow I have turned the data sent into an object and set it up to loop through each item and paste the values into an Excel sheet. (Excel sheet being used just for testing that data can be extracted.) This works fine for most of the SharePoint columns however when I try and extra a "Person or Group" field it doesnt recognize the field.
This is my current Desktop flow setup. As mentioned it can successfully get the Title valuehowever is unable to find the Director value
In each loop it is CurrentRow contains data like this (Modified to anonymize and remove irrelevant fields).
{
"ItemInternalId": "1",
"ID": 1.0,
"Title": "Division 1",
"Director": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|JohnDoe@company.co.uk",
"DisplayName": "John Doe",
"Email": "JohnDoe@company.co.uk",
},
"Director#Claims": "i:0#.f|membership|JohnDoe@company.co.uk",
"Modified": "2021-03-23T11:53:15Z",
"Created": "2020-12-15T16:48:23Z",
}
My question is, in Desktop flows how do I correctly reference the Display name of the director. I have already tried both %CurrentRow['Director']% and %CurrentRow['Director/DisplayName']% but neither have been recognized.
All responses (
Answers (
