Forum Discussion

Flowlynow's avatar
Flowlynow
Copper Contributor
Jun 20, 2024

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_Elliott's avatar
    Rob_Elliott
    Bronze 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)

    • Flowlynow's avatar
      Flowlynow
      Copper Contributor
      Hi 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

Resources