Power Apps Help Desk

[richardcampbell]

I'm new to Power Apps, trying to deploy the Help Desk template. I assumed it was going to be simple but I am running into all sorts of issues.

Once I deployed the template, I updated the AdminList to include my email. This worked and I am able to log in as both a user and an admin.

Next I opened Data and replaced the TicketList collection with my SharePoint list. When I do this I get many errors.

[EddieE]

@richardcampbell 

I'm unfamiliar with the Help Desk template, but in general, when replacing a datasource with inside an app you will need to manually change all the references, eg

where TicketList is written in your Patch code of your second image, this needs to be changed to the name of your SharePoint List

This needs to be done throughout the entire app.

The last error seems to be about a Person/Author. The error is saying a Record is expected but is receiving a Text value. To me, this sounds like the 'Author' field from TicketList is a complex type (such as a Person type field in SharePoint) and your 'Author' field you've setup in your SP List is of type Text. There are a number of ways to fix this, just depends on your needs.

[richardcampbell]

I had my SharePoint list named the same so when I added the Data set it asked me if I wanted to replace the other one. I said yes but it still broke everything.

I changed the name of my SharePoint list so it was different, added it to the PowerApp and replaced the name and am still getting the same error.

I had the Author and AssignedTO fields as text fields, I changed them to Person or Group fields, was that the right thing to do based on the other errors?

Thanks for the help EddieE!

[EddieE]

@richardcampbell 

Firstly, changing the name of SP Lists is never a good idea, this can break more things then is worth it. If you named your list TicketList the in-app intellisense would've want to receive 'TicketList' (note the single quotes) and not TicketList which is the representation of a variable ie in this case, a collection.

Use intellisense to select your data source - this should fix things. If you have change the List name, you may need to delete then re-add the data source, although I'd be inclined to start again with a new list - less errors ...

Changing field types - ie from Text --> Person/Group - is also not good. The best idea would've been to create new columns then reference these. It's also a bad idea to change the names of columns ...

On whether using Text or Person fields is the " ... right thing to do ... " this is up to you. Personally, I steer clear of Person columns unless I'm using them in a Form and I let PowerApps pull through the DataCard properties needed for that column. I then don't mess with these as they can be tricky to get right once you start adjusting them.

If you are still getting the data source error please post an image of the error or copy and paste it here so I can see what's happening. It's a little difficult to know what's going on and I'd only be guessing without seeing it.

[richardcampbell]

I deleted the Data connector in PowerApps, recreated the SP list from scratch, and reattached it to the Help Desk app.

I did leave the Author and AssignedTO fields as People fields

I ran through and let intellisense help me add the data, it does it without single quotes

Here's my CreateTicketScreenCreateButton:

Set(NumberOfTickets,NumberOfTickets + 1);
Patch(TicketList,Defaults(TicketList),{Id:NumberOfTickets,
Title:CreateTicketScreenTitleText.Text,
Priority: CreateTicketScreenPriorityDropDown.SelectedText.Value,
'Created By':MyProfile.Mail,
TaskStatus:"NOT STARTED",
PercentComplete: "0",
Created:Now(),
AssignedTO:"",
Description:CreateTicketScreenTaskDescription.Text,
'Modified By':MyProfile.Mail,
Modified:Now(),
Category:CreateTicketScreenCategoryDropDown.SelectedText.Value });
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Navigate(ConfirmSubmitScreen,None)

And the errors I am seeing are attached

[EddieE]

@richardcampbell 

It appears that the 'AssignedTO' field is the problem. If at this stage in your app you are leaving it Blank() then just leave it out of your Patch statement, ie

Set(NumberOfTickets,NumberOfTickets + 1);
Patch(TicketList,Defaults(TicketList),{Id:NumberOfTickets,
Title:CreateTicketScreenTitleText.Text,
Priority: CreateTicketScreenPriorityDropDown.SelectedText.Value,
'Created By':MyProfile.Mail,
TaskStatus:"NOT STARTED",
PercentComplete: "0",
Created:Now(),
Description:CreateTicketScreenTaskDescription.Text,
'Modified By':MyProfile.Mail,
Modified:Now(),
Category:CreateTicketScreenCategoryDropDown.SelectedText.Value });
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Navigate(ConfirmSubmitScreen,None)

[richardcampbell]

I left it out and now it is giving me an error for Author but that is being left out also

[EddieE]

@richardcampbell 

By 'Author' do you mean 'Created by'? The columns

- Created

- Created By

- Modified, and

- Modified By 

are all inbuilt SP columns and as such their data is controlled by SP. Try removing these from your Patch as well.

Also, if 'Author' isn't 'Created By' check if it's set as Required in SP. If so then you will need to supply a value (all Required fields MUST be included in your Patch).

However, if you do not need it to be Required, then Uncheck this box in SP and Refresh your data source.

[richardcampbell]

It's not one of those, it's a different column in the SP list.

I made everything not required when I created it.

[EddieE]

I’m not seeing a red line error indicator in your formula, are you sure it’s the OnSelect property that’s the issue. There maybe another button property causing the error