Weird behavior of search function in Dataverse for teams

(0) Share

Report

Posted on by anubhav247

Hello there,

I know the topic has been discussed in various forums but am still confused.

As per Microsoft Documentation https://docs.microsoft.com/en-us/connectors/commondataservice/

Search function is not in the list of Delegable functions.

As per my understanding, If i set data row limit to 1 then Search function will fail to get the items at row numbers greater than 1. So i set it to 1

Now here is my Data verse for teams table.

Skill id column is a Auto-number column here and i am telling you this just to prove that the first item in the table is C#.

Now am using the search function as below

How come a record sitting at 4th position gets displayed?

I moved on thinking that documentation might needs updation.

I change the search function to..

here it fetches 4 rows when used in a gallery and a combobox.

but it fetches only 1 in a list box.

Question 1.

Am i looking at the right documentation or there exists a separate documentation for dataverse for teams?

Question 2.

Is Search function really delegable in Dataverse for teams app?

Question 3.

Why it shows only 1 row in listbox while it shows 4 in both gallery and combobox?

Note:- am using fluent ui controls.

Regards,

Anubhav

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@anubhav247 Now there are 2 Dataverse connectors. First the legacy, which is on its way out.
Then comes the new one.

The document you are looking at is the old one.
The doc for the new one is here https://docs.microsoft.com/en-us/connectors/commondataserviceforapps/
But, unfortunately there is no mention of delegation there. So its all going to be guess work, I guess!

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

Like (0)

Report

Hi @anubhav247 ,

Search function is delegable in dataverse, please see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#delegable-functions.

If it was not delegable it usually warns me as I am working with it in the canvas app like shown here (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#delegation-warnings)

Not sure on your listbox but did you remove the setting with data row limit of 1?

Hope this helps. Please accept if answers your question or Like if helps in some way.

Thanks,

Drew

Was this reply helpful? Yes No
anubhav247 47 on at

Like (0)

Report

Row limit is 1.

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

@anubhav247 ,
Answers below for your question,
1. No, it is a legacy one. Attached is the latest one for Dataverse delegable functions and operations (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse).
2. yes, Search is a delegable function for Dataverse. you can refer the above link.
3. Search is working as expected. You are searching letter y in description field of Skills table. Search function is case-insensitive (even with single letter it searches the column value). In your case, python is the only word that has y in it, that is why it is displaying only one record. If you use any non-delegable function then Data row limit comes into picture.

I hope it answers your question. Kindly give kudo and accept it as solution.

Regards,
Prakash

Was this reply helpful? Yes No
anubhav247 47 on at

Like (0)

Report

Hey Prakash,

I do not see search function listed in the list of delegable functions on the link you shared above.

Can you share a snapshot if you see it..?
Regards,
Anubhav

Was this reply helpful? Yes No