Forum Discussion
Index list - show the last person who edited each page
Hi folks,
I'm looking for guidance on a SharePoint list that indexes a group of pages (A-Z safety topics). I'd like the list to also have a column that identifies the last person to edit each page, and a column that identifies the last person to comment on each page.
Comments in each page are turned on.
In list settings you have modified by, and this only cites the person to modify the line item, not the page that the line points to.
Any help would be appreciated 🙏
- Rob_ElliottBronze Contributor
Flowlynow you won't be able to do this with SharePoint alone, you'll need a flow in Power Automate. That can save the Modified By details into the list. But getting the info about who did the most recent comment is a lot more difficult because the comments are saved in the schema of the list, not in a list, library or column. Even with a send an http request to SharePoint action I think you'll struggle because it can get the first comment and, in theory, replies (although I've never got that to work successfully). But it can't get who made the comment or when.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)- FlowlynowCopper ContributorHi Rob_Elliott,
Thanks for that and in terms of the flow for power automate, is there a guide or web page that can help with that?
Thanks