cancel
Showing results for 
Search instead for 
Did you mean: 

Allowing PowerAutomate to extract Sharepoint on premise column with multiple people or groups

hi,

 

Referring to below link, the below upgrade currently allow "Get Items" to extract out a column with multiple people or groups but i think it works only for sharepoint online (if the source is sharepoint on premise, it does not work)

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Person-or-Group-field-in-item-should-suppor...

 

Currently, i am in midst of migrating from on premise to sharepoint online. but i think the current "Get Items" in power automate does not allow the program to extract out values when the column has multiple people and group. I have tested that for extraction from sharepoint online it works. but if source is from sharepoint on premise, the get items is not able to get the values. currently it will display as NULL. Kindly see below for my "Get Items" outputs when my source is from sharepoint on premise. 

 

"Approver1": null,
"Approver2": null,
"Requester": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.w|xxxt\\xxx",
"DisplayName": "Person 1",
"Email": "lxxx@mxxx.com",
"Picture": null,
"Department": null,
"JobTitle": null
},

 

 

Can we include this in future upgrades? especially to cater for new O365 users who are migrating from sharepoint on premise to on line. thank you.

Status: New