Morning all!
I'm trying to build a Canvas Power App which uses the data from Microsoft Project Online (project.microsoft.com stored within the Dataverse, not a SharePoint PWA site!).
It was all going well where I could add Dataverse tables such as: Projects, Project Tasks, etc., to the app but then I needed to get the user assigned to a task, value in "Assigned To" column:
Note: obfuscated users with red box.
The "Project Tasks" Dataverse table does not seem to have a reference to "Assigned To" users for any of the columns.
I found another Dataverse table called "Resource Assignment" in which the data appears to have the rows for each assignments and a column for the assignee called "Bookable Resource":
Note: when in this screen I can see the column
However when I am then in the Canvas Power App and bring the table in as a data source, the column "Bookable Resource" is unavailable? It doesn't appear in a field list nor can I access it via the direct references e.g., First('Resource Assignments').'Bookable Resource':
Here are the columns settings "Resource Assignments"."Bookable Resource":
What am I missing? Or should I be getting the project tasks assigned to users from a different Dataverse table?
Thanks,
Josh!
