web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery items based on...

Power Apps

Answered

Gallery items based on Lookup Field

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Experts,

In my canvas app, I am using

1) Users Entity

2) Custom entity called Routes

Routes has a lookup field called Courier that has Users Entity as a related entity.

I have two requirements:

1) I want a gallery that shows the list of distinct couriers as Routes can have more than one row associated with one courier.

2) I want to have Search text box as well which can search couriers bases on Full Name for example which is a field in Users Entity.

What I have tried so far:

1) I have not been able to do Users.Routes (It says the specified column is accessible in this context)

2) Distinct(Routes, Courier).Result (This works for requirement #1 but I do not know how to make search work (requirement #2))

So, is there a way to get only the distinct records from Users entity that are referenced in Routes entity?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

DevendraSingh 144 on at

Like (0)

Report
Copy link

Link copied!
Hi,
Requirement 1: Use the formula Distinct(Routes, Courier) to get the distinct couriers, and in the gallery use the formula ThisItem.Result.'Full Name' to display the full name.
Requirement 1 & 2: Following are the steps,
Step1: Create a collection to store the above query result, i.e. Collect(colItems, ForAll(Distinct(Routes, Courier), {'Full Name': Result.'Full Name', 'First Name': Result.'First Name'}))
Step2: Add a text box control
Step3: Add a gallery control, and write the formula Search(colItems, TextBox.Text, "Full Name") on items property
Please click Accept as Solution, if this solution solved your issue. If this post was useful, please consider giving it Thumbs Up.

Thanks & Regards,
Devendra Singh

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Here is a simple workaround, create a new column by AddColumns function to store the FullName of couriers from User Entity.

Please try to put the following code to Gallery.Items property:

Search(Distinct(AddColumns(Routes,"UserFullName",Courier.'Full Name'),UserFullName),SearchTextInput1.Text,"Result")

Set Text property of Label inside Gallery: ThisItem.Result

Hope this helps.

Sik

Was this reply helpful? Yes No

Join the conversation