| Faiza Umair

In this part of CRUD Operations in Canvas App series , we will see in deep of Read operation.

We can perform Reading in Canvas App using Filter() , Search() and LookUp() functions.

Read Data Using Filter()

Syntax: Filter(*DataSource,Condition 1,Condition 2,…)

Toys (Table)
CRUD Operation 1

This Example will give all Toys whose color is red

CRUD Operation 2
CRUD Operation 3
Read Data Using Search()

Syntax: Search(*DataSource,”String To Search”,Column 1,[Column 2,…])

Search() function give records from Table/Collection which contains Conditional Column contains all or part of “String to Search” .

Toys (Table)
CRUD Operation 2
Search(Toys,”Re”,”Color”) or Search(Toys,”Red”,”Color”)

This Example will give all Toys whose color is red

CRUD Operation 3
CRUD Operation 4
Read Data Using LookUp()

Syntax: LookUp(*DataSource,Condition[,Reduced Formula])

DataSource: It could be Table of Dataverse or Collection

Condition: It is check to get exact record

Reduced Formula: Using this formula, we can reduce the record to single value

LookUp() function give single record from Table/Collection that meets the condition.

Toys (Table)
CRUD Operation 2

This Example will give all Toys whose color is red

CRUD Operation 2


The above example give only single value 3 instead of Record, because we apply Reduced formula and got only Age of Matching Record.

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.

More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting