Unanswered

Search multiple records in model driven app

(0) Share

Report

Posted on by OKM

Hello,

I imported a list of 6000+ records into an entity. This entity I placed in a model driven app, and now I'm looking for a way to search in the first/main column for multiple records and to select all the ones I search for at once, in order to update a certain field in all those records.

The search option only allows me to search one record at a time and the filter only allows two..

What options do I have?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report

If I understand you correctly. You have records in an entity and you want to get a subset of the records from that entity using a list? Some screenshots of what you are trying to do would be helpful.

If you are doing what I think you are trying to do, there is a manual process where you can Export to Excel, do VlookUps to do the search against your list, update the data in Excel and then reimport into the Model-Driven app to update the data. It’s a fairly complex process, but I can give you clearer instructions if I am on the right track with what you are trying to do.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @OKM ,

Based on the needs that you mentioned, I think you want to update multiple records at same time, is it true?

I think the Model-Driven app could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:

Open your Model-Driven app, then take a try with the following steps to change multiple filtered records at same time:

Step1

Step2

Step3

Step4

Please consider take a try with above solution steps, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
PowerBack19 679 on at

Like (0)

Report

@OKM - Another option to consider is using Advanced Find to query/filter the records you need. You can also create a saved custom view (list) from the Advanced Find.

Once the view/list is saved, you can export the list to Excel where you can do the bulk updates. The only caveat is that you don't change anything in the first 3 columns (columns A, B, C). These columns contain the unique ID (GUID) of the records that were exported.

After the records are updated, you can then import the list back in which start an import job. This import job will then match the unique IDs within Excel to the records in CDS and make the updates.

Was this reply helpful? Yes No