cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Adehmar
Frequent Visitor

Hiding/filtering duplicate record in search fields in a model-driven app

Hello everyone!

 

I have two records in column "groups" with the same name. However I want for search fields to only show the one with the number 78, which is from another column "code" related to it, and ignore/hide/not search the other. How could I go about doing this?

 

 

8 REPLIES 8

//pseudo-formula 
// - replace yourExistingFormula below with any formula you already have that's already searching or filtering now that's working
// - replace CodeColumnName below with actual name of your Code column
Filter(yourExistingFormula,CodeColumnName=78)
Adehmar
Frequent Visitor

Where should I put that code? Mine is a model driven app, I cannot find any place to put it.

 

Is there any way to do this with xrmtoolbox?

@Adehmar 

 

Check if below helps as a guide:

Power Fx Formula Columns in Dataverse

 

Okay I gave it a look and unfortunately that doesn't help me solve the issue.

I've been checking out dataverse views but those don't seem to change the search results, and I've yet to find something in xrmtoolbox.

Yeah I've been using those but using the filters don't hide the rows I want to filter out, when using search.

 

Third party people use the app so they shouldn't be able to see both results, just the 78 one.

@Adehmar 

 

A. Navigate to  https://admin.powerplatform.microsoft.com/ and then

 

1. Select the right environment.

poweractivate_0-1665517597889.png

 

2. Click Settings

poweractivate_3-1665517679691.png

 

3. Click chevron to left of Product

poweractivate_2-1665517648140.png

 

4. Click Features

 

poweractivate_4-1665517736822.png

 

5. Scroll down to Advanced find options and then for Modern advanced find in model-driven-apps toggle this to On.

 

poweractivate_5-1665517826387.png

 

 

6. Scroll to the very bottom and click Save

poweractivate_6-1665517923888.png

 

 

7. Go to make.powerapps.com

 

8. Refer to this guide below and try to use it.

Advanced find in model-driven apps

 

See if you can also create a view with the filters already there, and make this the default view, if you want the filters pre-applied.

 

See if it helps @Adehmar 


Third party people use the app so they shouldn't be able to see both results, just the 78 one.


In that case @Adehmar you may be better off using this guide to make sure that specific records are not ever shown to those users, whether in the Search or anywhere else in Dataverse, and you should do this using the below guide:

Column-level security to control access

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,196)