Search
Create an new app empty, add a gallery connected to alist, add a textbox that we will use for searching.
—————————————————-
Change the Gallery Items to
Search([@’Zebra-Employee-Detail’],SearchBox.Text,”Title”,”Department”)
search the list columns Tile or department
Sort
Sort(Filter(‘Registration Form’,Course.Value=“Power Apps”),RegistrationDate)
Sort(Distinct(DS,’Columns to show’),Result) // in a dropdown
SortByColumns(Filter([@‘Registration Form’],Course.Value=“Share Point Online”), “Title”, Descending)
Add a Dropdown to show search results:
Distinct(‘Zebra-Employee-Detail’,Department)
for items properties use:
ShowColumns(Search([@’Zebra-Employee-Detail’],SearchBox.Text,”Title”), “Title”)
for gallery
Search([@’Zebra-Employee-Detail’],Dropdown2.Selected.Department,”Department”)
Filter(‘Zebra-Employee-Detail’, Department = Dropdown2.Selected.Result)
Filter
Change the Gallery Items to:
Filter(‘Zebra-Employee-Detail’,SearchBox.Text in Title) //Filter(Data Source,Condition) works on short list
Filter(‘Zebra-Employee-Detail’,StartsWith(Title, SearchBox.Text)) //Filter(Data Source,Condition)
add one more condition, it works like And
Filter(‘Zebra-Employee-Detail’,StartsWith(Title, SearchBox.Text),FavoriteColor = “Red”)
Filter(‘Zebra-Employee-Detail’,Department = Dropdown2.Selected.Department)
————————————————————–
Lookup
Returns the first record:
LookUp( IceCream, Flavor = “Chocolate”, Quantity )
LookUp(‘Zebra-Employee-Detail’, StartsWith(Title, SearchBox.Text)) //Filter(Data Source,Condition)
Search with a dropdown:
Set the dropdown items to:
Distinct(‘Zebra-Employee-Detail’,Department)
set the Gallery Items to:
Filter(‘Zebra-Employee-Detail’, Department = Dropdown2.Selected.Result)
Sum up Filtered column
Sum(Filter(‘datasource’, col.Value = “some text”), ‘col to add up’)
[code] UpdateContext(
{
isMatch: If(
CountRows(
Filter(
BS,
‘colName’ = somField.Value
)
) = 0,
false,
true
)
}
);
[/code]
Get only the records that have a match
[code] Filter(DB_Lookup,
Title in Filter(
DC, ‘colName’ = somField.Value
)
)
[/code]
Get only the records that does not have a match
[code] Filter(DB_Lookup,
Not(
Title in Filter(
DC,’colName’ = somField.Value
)
)
)
[/code]