Customize column lookup Filter By on view

(1) Share

Report

Posted on by David Pezzoli

230

Hi All,

I have a custom entity with a grid view.

On the columns of this grid, users like to set manual filters as Excel.

When users want to filter a column lookup as Account they need to see only the proposed list of Accounts associated with the created custom rows.

They don't want to see all Dynamics 365 accounts row.

E.g.

On view, the user clicks the account column lookup and set a manual "filter by" on column view:

pastedimage1618225772617v1

the user find the account but note:

pastedimage1618225981211v2

the user wants to see only accounts associated with current custom entity records.

Native Account Lookup on view proposes all records, How can I achieve/apply this filter on the column lookup view filter rule?

In addition: add only one default custom view on the Account Lookup field (alias column) doesn't filter it.

pastedimage1618233872749v1

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @David_Pezzoli

A few things here on your needs.
You can setup custom views in the Dataverse (see image below)

You should be able to create a view that will filter on the relationship between the Account entity and the custom related entity and only display Account records where this relationship exists.

Example doing this with Advanced Find where I have a custom table "Occupancy" that has Many - 1 relationship to the Account. When I execute the Advanced Find it only returns 1 record because I only have 1 of those records setup that has the Account populated.
and the results look like this:

You can then utilize this view as the view in your definition (or turn on "View Selector" and allow the user to be able to select the view they would like.

Hope this helps. Please mark accepted if it answers your question or Like if provided some assistance.

Thanks,

Drew

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (0)

Report
Copy link

Link copied!

Hi @dpoggemann ,
thanks for your suggestions but your post doesn't solve my requirements:
- users love using "filter by" on lookup column view
- users don't want switch or navigate to another custom view with predefined filters as "contains data" or other advanced filters for related records
- as I anticipated, set a lookup custom view as default on form work fine, but on view the lookup column isn't filtered:

I think it is a limit new UI by design....

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @David_Pezzoli,

Sorry that did not answer your question. Is the view you are looking at on the Opportunity entity and you are trying to filter by Account? Just trying to get more details on what you are trying to do here...

Example, I am able to filter by Account on the Opportunity view. When you see the list of Accounts you can click on each one and add multiple to the filter but maybe I am misunderstanding the situation, see below on what I just did on an Opportunity view.

Please let me know what I am not understanding in your query.

Thanks much,

Drew

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (0)

Report
Copy link

Link copied!
Hi @dpoggemann ,
Happy to provide you more details:
Exactly on the Open Opportunities view users click on Account lookup column
Click on "Filter By" (it is the same image provided by you)
They keep select "equal" expression
Now the users insert the first letters of a desired accounts and they see all accounts rows (precisely they see all the accounts on which they have read permissions defined by their assigned security roles): so they can see accounts with or without related opportunities.
But users ask me: "I want to see only the accounts that have an opportunity present in this view!"
So, my request is: inside "column Filter By", is there a way to filter the long list of accounts and propose ONLY the accounts that have at least one opportunity listed in the current view?

Thanks

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @David_Pezzoli,

Understand now 🙂 Thanks! This is not available and you might want to enter an idea for this (https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas/status-key/Started)

I did add the Editable Grid and I am able to "Group By" on the Account field but still does not provide the filtering capability you are looking for to only show the values within the view.

Thanks,

Drew

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (0)

Report
Copy link

Link copied!

Thanks @dpoggemann ,
I needed your confirmation from my UI tests! 😅

Was this reply helpful? Yes No
jlmccormack 2 on at

Like (0)

Report
Copy link

Link copied!

Are there any updates as to whether Microsoft has implemented a way to customize the "Filter By" results on a column in a View? I am looking to do something similar where I need the "Filter By" to only show a subset of records instead of all.

Was this reply helpful? Yes No
lilija 8 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

I would like to ask if there is any updates about these business requirements and maybe when they will be provided by Microsoft.

Thank you.

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (1)

Report
Copy link

Link copied!

@lilija

As far as I know, there is no update and I have not seen anything about it in the roadmap.

Was this reply helpful? Yes No