Hello,
For work I am trying to create a form in PowerApps that allows for Project Managers to provide weekly updates on any status changes for their projects. All the projects are listed in my SharePoint List. The main issue I've had is linking the SharePoint list to my PowerApps. I'm trying to make a drop down from a column entitled "Action Officer", where you can click the drop down and select your name and will then see all of your projects. Right at the start, when I create a drop down, and try any sort of formula I receive the following errors. I've tried it with multiple lists (one private one public). No matter what I do, when I enter the SharePoint List name (It is called WATT - I've tried naming it WATT, 'WATT', [WATT], [@WATT]) it says: "WATT = there is an error in this formula. Try revising the formula and running the formula again."
Any help is appreciated. Please see attachments (pictures).
