We are retrieving the Line Manager from a SharePoint list using Get Items.
That field is defined in the list as Person or Group
We know that there will only ever be one line manager in the record...but because it's a person or Group field it's necessary to use Apply to each in flow to retrieve the Line Manager
What I would like to do is something like this:
first(triggerBody()?['LineManager'])
We need to get the DisplayName and the Email - how could we do that?
But the value we get out is:
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|name@web.uk","DisplayName":"fName lName","Email":"name@web.org.uk","Picture":"https://bhfonline.sharepoint.com/teams-and-projects/dev/lab/FinanceSystems_ExpenSys/_layouts/15/UserPhoto.aspx?Size=L&AccountName=halperna@bhf.org.uk","Department":"Development Team","JobTitle":"Developer"}
so how can we extract the DisplayName and Email from that result?
Solved! Go to Solution.
Hi
The result you are getting is an object with its properties (property name : value) separated by commas.
first(triggerBody()?['LineManager'])?['NAmeOfThePropertyYouWantToGet']
makes the magic. THe ones you are requesting are
first(triggerBody()?['LineManager'])?['DisplayName']
first(triggerBody()?['LineManager'])?['Email']
Hope this helps
Proud to be a Flownaut!
Hi
The result you are getting is an object with its properties (property name : value) separated by commas.
first(triggerBody()?['LineManager'])?['NAmeOfThePropertyYouWantToGet']
makes the magic. THe ones you are requesting are
first(triggerBody()?['LineManager'])?['DisplayName']
first(triggerBody()?['LineManager'])?['Email']
Hope this helps
Proud to be a Flownaut!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
20 |
User | Count |
---|---|
62 | |
45 | |
40 | |
29 | |
27 |