Solved: Selected Ticket Location Name not pulling through

JerryH · ‎06-24-2020

Hi team

After i have created a ticket, i navigate to My Tickets however some of the information does not pull though.

1. Why does my Location label not pull through the location specified on the ticket?

2. Why do i need to click on the ticket for it to pull other information through?

Thanks

JerryH · ‎06-24-2020

hi Warren,

It all of a sudden works.

Thank you for your patience.

Set(
    NumberOfTickets,    NumberOfTickets + 1
);
Patch(
   HelpDesk,
   Defaults(HelpDesk),
   {
      Title: CreateTicketScreenTitleText.Text,
      Priority: {Value: CreateTicketScreenPriorityDropDown.Selected.Value},
      Category: {Value: CreateTicketScreenCategoryDropDown.Selected.Value},
      LocationName:LocationNameDD.SelectedText.Result,
      ClientName: ClientNameDD.Selected.Result,
      PercentComplete: 0,
      Description: CreateTicketScreenTaskDescription.Text
   }
);
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Navigate(MyTicketsScreen)

View solution in original post

WarrenBelz · ‎06-24-2020

Hi @JerryH ,

After 10pm here (Eastern Australia) , so I will be offline shortly.

As I said, take this one at a time, get that working then move onto the next one.

Firstly, look at your list - what types of fields are you writing to?

Look at your controls - what are the valid outputs?

Lastly, make sure any combo boxes are not multi-select - that creates a record, not text and requires a whole new strategy to write back.

Writing to Text from a single-choice control you need ControlName.Selected.xxxx (you can see the xxxx underneath).

Writing to a Choice field from the same control you need {Value:ControlName.Selected.xxxx}

If any of your source fields are Lookup fields (I hope they are not) , another dose of pain for you as you need to retrieve the Id of the lookup source record as well as the value.

View solution in original post

WarrenBelz · ‎06-24-2020

Good @JerryH ,

I was typing my last message and did not see your latest.

Please click Accept as solution as this will help others find it more readily. It also closes the item.

View solution in original post

JerryH · ‎06-24-2020

Hi,

I would like to filter my list by the user.

Distinct(Filter(AssetManagementHelpdDesk, Manager = MyProfile.DisplayName),ManufacturerName)

View solution in original post

WarrenBelz · ‎06-24-2020

Hi @JerryH ,

Distinct(
   Filter(
      AssetManagementHelpdDesk, 
      Manager = User().FullName
   ),
   ManufacturerName
)

will work as long as the spelling is correct. Note however it is not delegable, so you need to do this - at App OnStart

Set(vUserName,User().FullName)

then

Distinct(
   Filter(
      AssetManagementHelpdDesk, 
      Manager = vUserName
   ),
   ManufacturerName
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

WarrenBelz · ‎06-24-2020

Hi @JerryH ,

Is your data source SharePoint? If so, what is the name of the field in SharePoint and can you see the data in the list?

JerryH · ‎06-24-2020

Hi Warren,

Thanks for reaching out.

I am using Sharepoint and LocationName is one of my columns.

I'm supposed to be presenting in 30 minutes so am panicking.

JerryH · ‎06-24-2020

Hi Warren,

I know where i am going wrong. When i create a ticket, the Location and ClientName are not pulling through to Sharepoint.

Can you review the code below and error below that - please

Set(
    NumberOfTickets,    NumberOfTickets + 1
);
Patch(
    HelpDesk,
    Defaults(HelpDesk),
    {
    Title: CreateTicketScreenTitleText.Text,
    Priority: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: CreateTicketScreenPriorityDropDown.SelectedText.Value,
    PercentComplete: 0,
    Description: CreateTicketScreenTaskDescription.Text,
    Category: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: CreateTicketScreenCategoryDropDown.SelectedText.Value,
   LocationName: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: LocationNameDD.SelectedText.Value,
   ClientName: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: ClientNameDD.SelectedText.Value }}}}}
);
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Navigate(MyTicketsScreen)

ERROR: Description: Field 'Description is required

WarrenBelz · ‎06-24-2020

Ok @JerryH ,

Second question - can you see the data in your SharePoint List in the LocationName column?

Also check the Default of the text control - try ThisItem.LocationName.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

WarrenBelz · ‎06-24-2020

Hi @JerryH ,

We posted at the same time - ignore my last one. What type of field is location in the list. If Text, you need

LocationName: LocationNameDD.Selected.Value

If Choice, you need

LocationName: {Value:LocationNameDD.Selected.Value}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

JerryH · ‎06-24-2020

Hi Warren,

LocationName and ClientName are set up as Text Fields on SP because it pulls info from another list. (has previously worked)

Please see revised code + error message. (Please can you help me get this over the line)

Set(
    NumberOfTickets,    NumberOfTickets + 1
);
Patch(
    HelpDesk,
    Defaults(HelpDesk),
    {
    Title: CreateTicketScreenTitleText.Text,
    Priority: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: CreateTicketScreenPriorityDropDown.SelectedText.Value,
    Category: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: CreateTicketScreenCategoryDropDown.SelectedText.Value,
   LocationName: LocationNameDD.SelectedText.Value,
   ClientName: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: ClientNameDD.SelectedText.Value,
    PercentComplete: 0,
    Description: CreateTicketScreenTaskDescription.Text }}}}
);
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Navigate(MyTicketsScreen)

WarrenBelz · ‎06-24-2020

Hi @JerryH ,

The error is that the field is required, so I am assuming you have a blank text box?

Simply go into SharePoint and remove the required property.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

JerryH · ‎06-24-2020

Oh no. Still the ClientName, LocationName & now Category, Percentage & description are not populating in Sharepoint

Set(
    NumberOfTickets,    NumberOfTickets + 1
);
Patch(
    HelpDesk,
    Defaults(HelpDesk),
    {
    Title: CreateTicketScreenTitleText.Text,
    Priority: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: CreateTicketScreenPriorityDropDown.SelectedText.Value,
    Category: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: CreateTicketScreenCategoryDropDown.SelectedText.Value,
   LocationName: LocationNameDD.SelectedText.Value,
   ClientName: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: 1,
            Value: ClientNameDD.SelectedText.Value,
    PercentComplete: 0,
    Description: CreateTicketScreenTaskDescription.Text }}}}
);
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Reset(CreateTicketScreenTaskDescription);
Navigate(MyTicketsScreen)

WarrenBelz · ‎06-24-2020

@JerryH ,

Break this down to one field at a time in the Patch. Have a look at the field type and see if they need that code. Also Choice fields do not need the code you have - see the below. You also had all your }} brackets nested at the end, which is not the correct syntax.

Patch(
   HelpDesk,
   Defaults(HelpDesk),
   {
      Title: CreateTicketScreenTitleText.Text,
      Priority: {Value: CreateTicketScreenPriorityDropDown.Selected.Value},
      Category: {Value: CreateTicketScreenCategoryDropDown.Selected.Value},
      LocationName: LocationNameDD.Selected.Value,
      ClientName: {Value: ClientNameDD.Selected.Value},
      PercentComplete: 0,
      Description: CreateTicketScreenTaskDescription.Text
   }
);
Reset(CreateTicketScreenTitleText);
Reset(CreateTicketScreenTaskDescription);
Reset(CreateTicketScreenCategoryDropDown);
Reset(CreateTicketScreenPriorityDropDown);
Reset(CreateTicketScreenTaskDescription);
Navigate(MyTicketsScreen)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.