Hi Qi,
Thanks for the response!
I have a SharePoint document library for a custom content type with custom columns.
I'd like to support either of the following scenarios:
- Scenario 1: A user drops a file into the document library and a UI pops up to force the user to enter values for the custom columns ie instead of dropping the file in the library and subsequently updating its details to provide those values.
- Scenario 2: A user opens a UI that allows them to provide the file and the values for the custom columns before adding that file to the document library and updating the custom column values entered by the user.
Scenario 1 doesn't look like it's supported at all.
Scenario 2 is possible albeit not easily and definitely not with a no-code solution. The solution is ably described in Matthew Devaney's excellent article here.
Sadly, SharePoint document libraries don't seem to have as much OOTB Power platform support as SharePoint lists:
1) While Power Apps auto generates a set of view/details/add+edit UIs from a connection to a SharePoint list, it doesn't (seem to) do that for SharePoint document libraries
2) There is no native File Attachment control in Power Apps. You have to auto generate the view/details/add+edit UIs from a connection to a SharePoint list to get a UI that has a file attachment control that you then copy to you your UI to upload a file to a SharePoint document library
3) Once you have a Power App UI for a user to select a file to add to document library and enter values for its custom columns, you have to use Power Automate to actually do the work of adding that file to the document library and updating the custom column values. As far as I can tell, the auto-generated Power App UIs for lists do this.
I'm definitely happy to be proven wrong as I'd love to do less work but, ultimately, the Power platform seems to offer more native support for SharePoint lists than SharePoint document libraries. Which is painful as we have far more doc libraries than lists.
Though, I'm keen to know if there is a prescriptive and no-code way to create Forms or Power Apps UIs to operate over SharePoint document libraries OOTB and no-code.
Thanks,
Michael