Skip to main content

Notifications

Power Pages - General Discussions
Suggested answer

Customising the SharePoint Integration

Posted on 9 Nov 2024 23:33:55 by 33
Hey Power Pages Folks
 
I have a Power Pages site deployed for a client, which utilises SharePoint Integration for documents.  The client has asked me to display against each document, who the person was who uploaded it.  All users are authenticated to use the site, so at least the site knows who they are, but my challenge is how to pass that as metadata against the SharePoint saved file, and then how to display that information back to the Portal via the sub-grid on the form.   
 
As far as I can tell, there is no out-of-the-box solution for this, so I need to think about how to achieve the functionality piecemeal.  Does anyone have an advice as to how this can be done?
 
Thanks in advance
 
Peter
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 832 on 14 Nov 2024 at 22:02:05
    Customising the SharePoint Integration
    pls try the following:
     
    In Power Pages, you already have user authentication, so you can access the user’s ID or email. When a document is uploaded, capture the user's identity (such as their email or a unique user identifier) from the authenticated session.
     
    use Power Automate to handle document uploads and store metadata in SharePoint:
    • Trigger: Configure a flow in Power Automate to run when a file is uploaded.
    • Action: Add metadata for the document in SharePoint to store the uploader’s name or email.
    • In the flow, retrieve the current user’s information from the Power Pages session and pass it as metadata (such as UploaderEmail) to the document in SharePoint.
    • Use OData or REST API calls within Power Pages to retrieve document metadata from SharePoint, including the UploaderEmail or similar metadata field.
    • Ensure that the metadata field with uploader information is included in the SharePoint document library’s view or accessible via OData.
    In your Power Pages sub-grid or document list, display the UploaderEmail or UploadedBy field alongside each document. You can use Liquid, JavaScript, or a custom web component to populate and format this information.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard

Featured topics