Unfortunately the deployment instructions at: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/help-desk-install are incomplete.
I've set up my DataSource - connected to my Sharepoint List and managed to update the TaskCategories, TaskStatus, TaskPriorty, and AdminList Collections to my needs.
In OnStart - I've got this 'Help Desk Tickets' being the name of my Sharepoint List:
ClearCollect(TaskCategories,Choices('Help Desk Tickets'.Category));
ClearCollect(TaskStatus,Choices('Help Desk Tickets'.TaskStatus));
ClearCollect(TaskPriority,Choices('Help Desk Tickets'.Priority));
Set(MyProfile,Office365Users.MyProfile());
ClearCollect(AdminList,"user1@myjob.com","user2@myjob.com");
ClearCollect(TicketList,'Help Desk Tickets');
Set(NumberOfTickets,CountRows(TicketList))
I'm struggling to know how to populate the TicketList collection properly.
Here is what is in as default (hardcoded with examples):
ClearCollect(TicketList,{Id:1,Title:"Fix Mouse",Description:"That is my cat!!!",Category:"Laptop/PC equipment issue",PercentComplete:"0.9",Priority:"HIGH",AssignedTO:"THOMAS ANDERSEN",TaskStatus:"COMPLETED",Author:"ScottK@contoso.com",Editor:"Scott Konersmann",Created:"2/8/2018 3:29 PM",
Modified:"2/5/2018 3:29 PM"},{Id:2,Title:"Replace keyboard", Description:"Please do it ASAP",Category:"Laptop/PC equipment issue",PercentComplete:"0.8",Priority:"LOW",AssignedTO:"YVONNE MCKAY",TaskStatus:"IN PROGRESS",Author:"PATRICK SANDS",Editor:"THOMAS ANDERSEN",Created:"2/5/2018 3:29 PM",Modified:"2/5/2018 3:29 PM"});
I've tried the following:
ClearCollect(TicketList,'Help Desk Tickets');
AND
ClearCollect(TicketList,ShowColumns('Help Desk Tickets',"Id","Title","Description","Category","PercentComplete","Priority","AssignedTO","TaskStatus","Author","Editor","Created","Modified"));
The second example creates a nice Collection with all the correct columns, but is not pulling any data in from my Sharepoint list
Any help here would be much appreciated!
