I have created a Power Apps Flow that uploads documents to a Document Library in Sharepoint. This Flow tags multiple metadata fields, but I care specifically for 3 of those fields to be used in a new Sharepoint List I am attempting to create. These columns/fields I care for are:
1) Project Name (text column)
2) Project ID (text column)
3) Document Type (choice column)
I want to create a new Sharepoint list to track when a new file gets uploaded into the Document Library using that existing Power Apps Flow, and then perform some sort of Lookup function or even conditional formatting to track what TYPE of document was uploaded. My hope is to create another Flow that automatically pastes the new document info (its Project Name, Project ID, and the Document Type) from the Document Library into the new Sharepoint list as its first three columns. After that pasting of information, the new Sharepoint list will contain its own specific columns like "Environmental Permitting document", "Energy Yield Analysis document", "Independent Engineer document," etc and when a new file gets uploaded the cells would show a check mark or green fill color (whatever makes sense) based on what type of document was uploaded. Its possible that one project would have multiple versions of the same document type so I need to allow for multiple selections. I think formatting these columns as Lookup columns is the way to go, however I am unable to select the Document Library column "Document Type" as a choice to look up. There are even a handful of more columns which are not available as Lookup column options, and my Document Library settings is already set to allow for searches. Any suggestions on any pieces to this problem?
