Hi,
We were using UipathTeam.Sharepoint.Activities with legacy. We switched to Windows and now we have some issues with getting the author of a line created in sharepoint.
The problem is that Get List items doesn’t return an Author of class FieldUserValue from where you can use a .Email property to get the mail.
Now this activity returns a dictionary with { “AuthorId”, 13 }.
How can I get the Author email with from this new dictionary?
Thank you!
Get List Items in Windows returns AuthorId only, as I think the solution is to use the returned ID with Get User Profile activity or Microsoft Graph API to fetch user details. This will give you the Author email which can then be mapped back to your list item. Steps are first extract AuthorId from the dictionary, then call Get User Profile with that ID to retrieve properties. Finally map the Email field from the profile back to your data table or dictionary.
Basically “Get User Profile” is not in the existing package. You have in Sharepoint.Activities only Get User but requires an email string which you don’t have.
This feels like a regression, because also Editor return only an ID.
the issue is old activities work on rest and new activities work on graph api…and in graph api those details are not exposed directly as opposed to rest
only way is get your user table access which generally requires a higher level and then fetch the columns…generally not a feasible way…
cheers