Filter and search a data source via a search box and dropdown

PHOTO

Sun Jul 17 2022 08:27:57 GMT+0000 (Coordinated Universal Time)

Filter('Aviva Account Desk Booking', StartsWith(TextName, SearchBox.Text) && (Status.Value = Dropdown4.Selected.Value || Dropdown4.Selected.Value = Blank()))

COPY

In this case, the formula uses the StartWith function to compare a SharePoint column (TextName) to text input (SearchBox.Text) and a dropdown selector (Dropdown4). It contains and or function (||) to ensure it works if the drop-down is blank. AllowEmptySelection must be set to 'true' for this to work. Used in the Items field.

Save snippets that work from anywhere online with our extensions

Comments

Power Apps

@gofunk1

Initiate MS Team Group Chat via PowerApps Save the current users email as a variable Creates variable with a theme colour palette Send an email from the current user Filters a data source based on the current logged in user Patch data fields, including a choice column to a data source Changes the colour of a selected item in a Gallery Filter and search a data source via a search box and dropdown Changes visibility based on the selection of another Gallery - used for "Tabs" Display current users first name Fix: Combobox/Search is empty check not working - Power Platform Community Retrive a user photo from SharePoint Get user photo from office365 connector from gallery Set a variable with the current users first name, from the currentUser variable Extract values from a collection Extract value from combo box Extract vale from combo box and convert to string/text Convert collection to JSON Combo box values to collection Show newly created items first / sort by most recent entry, will only show items created today Validate/Validation text box length and/or combo boxes contain data Text input validation - turns border red Lookup value against a text input and disable or enable displaymode Lookup items from a textbox Sets items to choices drop down or combo box Change text value based on lookup results returns tops 10 results and sorts by most recent created date Sets a variable with spilt text from a link - YouTube in this case Pass a null or empty value from Power Apps to a flow

##powerapps ##teams ##chat

Initiate MS Team Group Chat via PowerApps

Launch("msteams://teams.microsoft.com/l/chat/0/0?users=[EMAIL]&topicName=[TOPIC]&message=Hey I solved the problem!")

##powerapps

Save the current users email as a variable

Set(UserEmail, User().Email)

##powerapps

Creates variable with a theme colour palette

Set(AppTheme, { palette: { themePrimary: "#04ffff", themeLighterAlt: "#000a0a", themeLighter: "#012929", themeLight: "#024d4d", themeTertiary: "#039999", themeSecondary: "#04e0e0", themeDarkAlt: "#1effff", themeDark: "#41ffff", themeDarker: "#73ffff", neutralLighterAlt: "#02083c", neutralLighter: "#02073b", neutralLight: "#020738", neutralQuaternaryAlt: "#020734", neutralQuaternary: "#010632", neutralTertiaryAlt: "#010630", neutralTertiary: "#c8c8c8", neutralSecondary: "#d0d0d0", neutralPrimaryAlt: "#dadada", neutralPrimary: "#ffffff", neutralDark: "#f4f4f4", black: "#f8f8f8", white: "#02083c"}})

##powerapps

Send an email from the current user

Launch("mailto:prs@capita.co.uk?" & User().Email)

##powerapps

Filters a data source based on the current logged in user

Filter('Matrix Job Sheets', Contact.DisplayName = Office365Users.UserProfileV2(UserEmail).displayName Or Contact.Email = UserEmail)

##powerapps

Filter and search a data source via a search box and dropdown

Filter('Aviva Account Desk Booking', StartsWith(TextName, SearchBox.Text) && (Status.Value = Dropdown4.Selected.Value || Dropdown4.Selected.Value = Blank()))

##powerapps

Patch data fields, including a choice column to a data source

Patch('Aviva Account Desk Booking', DeskPicker.Selected, {Status: {Value: "Booked"}, From: FromCard.SelectedDate, To: ToCard.SelectedDate, Name: PersonPicker.Selected, TextName: PersonPicker.Selected.Email, DisplayNanme: PersonPicker.Selected.DisplayName})

##powerapps

Changes the colour of a selected item in a Gallery

If(ThisItem.IsSelected,ColorFade(RGBA(2, 8, 60, 1), -30%), (RGBA(0, 0, 0, 0)))

##powerapps

Changes visibility based on the selection of another Gallery - used for "Tabs"

If(Gallery2.Selected.Name = "Home", true, false)


* Table({Name:"Home"},{Name:"Manage Bookings"}) // this is the table used in the corresponding Gallery

##powerapps

Display current users first name

Trim(Last(FirstN(Split(currentUser.FullName," "), 1)).Result)

Filter and search a data source via a search box and dropdown

Save snippets that work from anywhere online with our extensions

Comments

More like this

Power Apps

Browse more snippets >>

Filter and search a data source via a search box and dropdown

Save snippets that work from anywhere online with our extensions

Comments

More like this

Power Apps

Browse more snippets >>

Embed code snippet