I'm wanting to create a sharepoint list where our remote teams send in their times via using PowerApps. That side is created.
One of the columns needs to be linked to a database, where they can only select items from that database or excel spreadsheet to stop them from putting any information in.
Currently the list column is just text, so when we export the excel document, the "Project Name and Project Number" allows for human error, where as if they could only select from one list. There wouldn't be.
There's too many Projects to just create them as individual choices.