Forum Discussion

SharePointHelp678's avatar
SharePointHelp678
Copper Contributor
Jan 25, 2024

Displaying Site Page Data (Verion, Modified By, Modified...etc) In PowerApps

Hello all!

I'm trying to build out a Power App that can help to track site page data and document library item data. The purpose is to show the current version, who modified the site or library item last and when it was modified. 

I think I understand how this could be done with a document library but I also have some site pages that I need to get the same information for. I know there is a "Site Pages" area and I can get some of the information there but I really need everything in one place, and I won't be able to see any of the document library data I need to monitor from the "Site Pages" area. 

Is there any way to pull site page data into a Power App?

Thanks for any help!

PowerApps
sharepoint
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Jan 29, 2024

    SharePointHelp678 yes you can pull site pages data into your app in exactly the same way you would with a list or library. When you connect a data source, in the list of your lists scroll down to the bottom and in the "Enter custom table name" field type Site Pages, click the checkbox then click Connect.

     

     

    Then you can add a gallery as in the image below where the items property is 

    SortByColumns('Site Pages', "Modified", SortOrder.Descending).
     
    You enter the data you want, so for the version number the text property is 
    "Version: "&ThisItem.'Version number'

     

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources