As title states, I am looking to mirror a document library to a sharepoint list. I'll bullet point what I'm trying to do, and why I'm having issues.
- I have a powerapp for company employees to submit time sheets.
- This app uses a sharepoint list to reference the employee names & active status, and filters only the ones who are active.
- Powerapps cannot use a document library as a search field in a combo box, this is why I have to use a list.
- We also have a document library that has a folder for each employee, and contains all of their individual submitted documents (Certifications, new hire forms, etc.)
- I want the Sharepoint list to mirror the folder name & active status columns.
My first thought was to create a trigger for whenever an "employee folder" was created or active status was modified, however, I cannot find a trigger to perform this. The only trigger I'm finding requires a list name.
Is there any way to acheive this without having to manually mirror the library and list?
