Unanswered

Searching multiple Dataverse tables that have the same columns

(0) Share

Report

Posted on by RobChilds

I have multiple Dataverse tables each with the same columns in.

I want to have a text input search box in a canvas app that searches these multiple tables and shows you the results (ideally you can define the columns it shows you in your results)

What would be the most efficient way of doing this?

Any advice greatly appreciated.

Thanks,

Rob

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RobChilds

Merge the tables into a collection and Search that.

ClearCollect(colall, table1, table2, etc)
RobChilds 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry a key piece of info I should have mentioned is that each table is around 900,000 rows (hence the reason for having multiple tables with the same columns).

Would you still recommend the ClearCollect function in regards to delegation?

Thanks,
Rob

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@RobChilds, ClearCollect can't be delegated to Dataverse, you will get only the first 500(max of 2000) records.

If your search result will not be more than the delegation limit, you can use the ClearCollect and Search funtions together:

ClrearCollect(colName, Search(Formula1), Search(Formula2))

The Search function is delegable and will search through all your records.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com