I have found the ability to schedule reports great. I am running a custom site owner report on a scheduled basis to capture people who have site owner access to sites.
Ideally I would like to use this data to populate a list and write the users to a people picker column.
The report currently outputs the users full name only - with no option to change the value returned. I would like the report to return the site owners email address (which is unique) instead of their display name (which in some cases is not unique)
Appreciate your time to investigate if this would be possible.
I have found the ability to schedule reports great. I am running a custom site owner report on a scheduled basis to capture people who have site owner access to sites.
Ideally I would like to use this data to populate a list and write the users to a people picker column.
The report currently outputs the users full name only - with no option to change the value returned. I would like the report to return the site owners email address (which is unique) instead of their display name (which in some cases is not unique)
Appreciate your time to investigate if this would be possible.