Power Platform Community Forum Thread Details

Hi Everyone, I am a little stumped on something and hoped to get some assistance.

I have a gallery where I have all the fields point to one Sharepoint list and 1 field that points to a different SharePoint list. This is a look-up column that points to a linked Helpdesk ticket.

In previous apps I have created, I have been able to create a button that when selected, navigates to another screen to an edit form where I can edit that record. Using something like this - Navigate(SCRTicketRecord,ScreenTransition.Cover,{SelectedItem: Gallery.Selected});
EditForm(FormTicketRecord)

Because the field that I am trying to open is from a different data source than the Gallery, I am unsure how to do this.

The "Link to ticket' column points to a different Sharepoint list and filters the dropdown values -

Filter('Helpdesk Tickets', 'Issue Status'.Value = "In Progress").Title

I basically want to click on a button and open the Linked Ticket in an edit form.

I hope that makes sense

Categories:

Building Power Apps

Hi @Lutzy ,

I have assumed some field and list names here - also unless you are using your lookup column directly in SharePoint, you might consider why you are using this field type as it can cause you unwanted grief in Power Apps, however OnSelect of the Gallery

Navigate(
 SCRTicketRecord,
 ScreenTransition.Cover
);
EditForm(FormTicketRecord)

and the Item of the Form

LookUp(
 TicketRecord,
 Title = Gallery.Selected.'Link to ticket'.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.

MVP (Business Applications) Visit my blog Practical Power Apps