SharePains

Customize Forms on SharePoint Document Libraries with Power Apps

Customize Forms on SharePoint Libraries

Customize Forms on SharePoint Document Libraries with Power Apps

By:

Pieter Veenstra

Date:

Customize forms

Today I noticed a new feature that I’ve been waiting for for quite a long time. It was already possible to customize forms on lists but now it is also possible to customize forms on SharePoint document libraries.

Customize Forms on SharePoint Document Libraries

As said it was already possible for quite a while to do this on lists but so far document libraries didn’t offer this option and we had to use the out of the box forms.

Power Apps Custom Forms

All you have to do is select the Customize forms option and you can make your changes to the forms. Changing the colour of the forms or changing the layout of the fields is all a piece of cake.

SharePoint custom form in Power Apps

Multiple Data sources

This now means that it is possible to pull in information from other datasources and use them on your forms straight from your document library new and edit forms.

Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There’s a better way — and I can show you exactly what it looks like. I’m the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I’ve been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://staging.sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://staging.sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@staging.sharepains.com

Categories:

Tags:

13 responses to “Customize Forms on SharePoint Document Libraries with Power Apps”

  1. Durga Avatar
    Durga

    We are able to open, update and publish but not able to Submit the form

    1. Pieter Veenstra Avatar
      Pieter Veenstra

      Hi Durga,

      When you hit the edit all button, then make your change does the save button not work?

  2. wilheimpage Avatar
    wilheimpage

    I came across the blog looking for a solution to the same problem as Durga. You can SubmitForm() when the FormMode is Edit, but not New. The reason for this I think is because the Name column aka {Name} is not updatable via the SharePoint PowerApps connector. There’s a workaround to trigger a flow to create the document set using the Send an Http request to SharePoint action, but it’s a big oversight not having the ability to create new.

    1. Pieter Veenstra Avatar
      Pieter Veenstra

      Hi Wilheim,

      I just had another look at this, and I really wonder when you would create a new form?

      New documents are created from the New document menu, in which case the document is created and once the document is there a form can be used to edit the document properties using the custom form in Power Apps. I can’t think of a way where I would first create the document properties in my Power App before creating the document. Can you give me some more details on what you are trying to do?

      1. wilheimpage Avatar
        wilheimpage

        I’ve used it to create document sets. It’s perfect for that, for example if you have a document library for projects and your list of customers is in another list etc.

      2. Pieter Veenstra Avatar
        Pieter Veenstra

        Interesting idea,. I have just found similar issues. When I add Content type as a field on my Power Apps form I’ve even noticed that documents content types are listed but the Document Set content type is not.

      3. Pieter Veenstra Avatar
        Pieter Veenstra

        I’ve created an idea for this on the Power Apps community site. Please upvote it.

        https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Document-Sets-in-Power-Apps-custom-forms-on-SharePoint-Document/idi-p/488041#M29843

      4. Pieter Veenstra Avatar
        Pieter Veenstra

        There is one option that may work. Create your self a form or set of fields, but don’t use the submit form option. Could could start a Flow which does the creation of the document set for you. Not great but probably the best that is possible for now.

      5. wilheimpage Avatar
        wilheimpage

        I suppose they wouldn’t expect you you want to assign that content type to an existing file, and you can’t create new via the Power Apps SharePoint connector. To expand on my workaround a little, I created a flow that runs the Send an HTTP request to SharePoint action to create a document set via the API, and the SharePoint integration OnSave action contains the formula If(SharePointForm1.Mode = FormMode.New, MyFlow.Run(parameters….), SummitForm(……))

  3. Ben Fish Avatar
    Ben Fish

    Can you show a preview of the document like on the details panel with this.

    1. Pieter Veenstra Avatar
      Pieter Veenstra

      You could use an image control and set this to SharePointIntegration.Selected.Thumbnail.Large

  4. inactivefroFabrice Avatar
    inactivefroFabrice

    Hi Guys, do you think that having a powerapps form only for edit and view mode and disable the newform (as done through the new document menu) is possible? If yes, how to disable the powerapps form for new and keep it only for edit / view?

    1. Pieter Veenstra Avatar
      Pieter Veenstra

      Hi Fabrice,

      Within Power Apps, in the SharePoint Integration you could set the OnNew to Navigate(ScreenNotAvailable). All you would then need to do is create a screen and call it ScreenNotAvailable. This is where you could put a message saying that new is not available for this list.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

All Categories