Answered

Gallery with LookUp Values dissapear when Gallery sort added

(0) Share

Report

Posted on by WillieEra

Support,

I have build an app that filters on a gallery, there are lookup fields, the gallery works correctly, however the moment I add a sort function the fields that reference a lookup changes to blank values, when I apply the same code to a gallery and exclude the lookUp fields it works perfectly.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Kindly show the formula to enable is look at it.

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

Was this reply helpful? Yes No
WillieEra 45 on at

Like (0)

Report
Copy link

Link copied!

The formula to do the lookup: LookUp('[dbo].[aas_wf_destination_dim_tbl]',Dest_ID_FK=Dest_ID,Destination)
This works in the gallery,

However the moment change the item on the gallery from the table name to the sort capability the LookUp values goes blank
Here is the Item code under the gallery for the sort:

Sort(Filter('[dbo].[aas_wf_transaction_tbl]',Cust_ID_FK=Gallery_Job_Search_Customer.Selected.Cust_ID),Open_Date,Descending)

It works perfectly except for the LookUp values that goes missing.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Use:
Sort(Filter('[dbo].[aas_wf_transaction_tbl]',Cust_ID_FK=Gallery_Job_Search_Customer.Selected.Cust_ID),Open_Date,Descending)

Is this Gallery_Job_Search_Customer.Selected
a Dropdown.
If so what is the items property of the Dropdown

Was this reply helpful? Yes No
WillieEra 45 on at

Like (0)

Report
Copy link

Link copied!

The Gallery_Search_Customer is another gallery:
You select the screen that shows you a gallery of clients, then you select the client from the gallery which directs you to another screen with a gallery that contains the jobs for that client.

Was this reply helpful? Yes No