Enable Allow Searching on Combo Box in PowerApps

  1. Display SharePoint choice field items in Power Apps Combo Box. 
  2. Display the items in ascending order in Power Apps Combo Box. 
  3. Enable Allow Searching to search a particular item in Power Apps Combo Box.

Use PowerApps as front end for showing the items in Combo Box. 
Use SharePoint List as back end.


Let’s walk through the steps to create a choice column in SharePoint Online:

  1. Navigate to Your SharePoint List:

    • Open your SharePoint site and navigate to the list where you want to add the choice column.
  2. Access List Settings:

    • Click on the Settings (Gear) icon in the top-right corner.
    • Select List settings from the dropdown menu.
  3. Create a New Column:

    • Scroll down to the Columns section on the list settings page.
    • Click on the Create column link.
  4. Configure the Column:

    • In the Create a column panel, provide the following information:
      • Name: Enter a title or column heading for your choice field (e.g., “Tags”).
      • Type: Choose Choice from the dropdown menu.
      • Description: Optionally, provide a brief description (e.g., “Certain things we know about the customer”).
  5. Define Choices:

    • Under the Choices section, define the options for your choice field.
      • For example:
        • “Loyal Customer”
        • “Looking to buy soon”
        • “Price driven”
        • “Style preferences”
        • “Family man”
    • You can add more options by clicking the Add Choice button.
    • Customize the color of each choice using the color palette icon.
    • Check the Can add value manually checkbox if you want users to manually type new choices not originally in the set of options.
  6. Additional Settings:

    • Click More options to see additional settings:
      • Display choices using: Set it to Drop Down Menu.
      • Allow multiple selections: Choose Yes if you want users to select multiple options.
      • Require that this column contains information: Set it to No to allow blank values.
      • Add to all content types: Ensure it’s set to Yes.
    • Finally, click Save to create the column.
  7. Verify the Column:

    • Refresh the page, and you’ll see that the Tags column has been successfully added to your SharePoint list.
  8. Assign Tags via the Choice Field:

    • Edit an item in your list.
    • In the right-side panel, you’ll find the Tags column.
    • Choose the appropriate options from the available choices (e.g., “Family man” and “Looking to buy soon”).
    • Save your changes.

Now your choice column is ready to be used for tagging items in your SharePoint list!

Watch this complete tutorial in the below video:



Let’s walk through the steps to add a combo box in Power Apps:

  1. Open Your Power App:

    • Sign in to Power Apps and open the app where you want to add the combo box.
  2. Insert a Combo Box:

    • Click on the Insert tab in the top menu.
    • Choose Input and then select Combo box from the dropdown.
    • A new combo box control will appear on your screen.
  3. Configure the Combo Box:

    • With the combo box selected, go to the Properties pane on the right side of the screen.
    • Set the Items property of the combo box. This determines the choices available in the combo box.
      • For example, if you have a SharePoint list named “Products,” you can set the Items property to:
        Products.ProductName
        
    • Customize other properties as needed:
      • DefaultSelectedItems: Pre-select items if necessary.
      • SelectMultiple: Decide whether users can select multiple items.
      • IsSearchable: Enable searching within the combo box.
      • SearchFields: Specify which data fields to search when users type.
  4. Design the Combo Box:

    • Adjust the layoutsize, and appearance of the combo box to fit your app’s design.
    • You can also add labels or other controls around the combo box for context.
  5. Test Your Combo Box:

    • Run your app to see how the combo box behaves.
    • Verify that it displays the choices from your data source and allows searching if enabled.
  6. Connect to Data Source:

    • If you haven’t already, connect your combo box to a data source (e.g., SharePoint, SQL, Excel) to populate the choices dynamically.

Remember, combo boxes are versatile controls that allow users to select from a list of options, and they can enhance the functionality of your Power Apps!


Let’s walk through the steps to add a SharePoint choice field to a combo box in Power Apps:


  1. Set Combo Box Properties:

    • With the combo box selected, go to the Properties pane on the right side of the screen.
    • Set the Items property of the combo box to the choices from your SharePoint list. For example:
      Choices('Your SharePoint List'.YourChoiceField)
      
    • Replace 'Your SharePoint List' with the actual name of your SharePoint list and 'YourChoiceField' with the name of your choice field.
  2. Enable “Allow Searching”:

    • In the combo box properties, toggle on the “Allow searching” option.
    • This allows users to search within the list of choices.
  3. Test Your Combo Box:

    • Run your app and verify that the combo box displays the choices from the SharePoint list.
    • Users can now search for specific values within the combo box.
  4. Connect to Data Source:

    • If you haven’t already, connect your combo box to a data source (e.g., SharePoint, SQL, Excel) to populate the choices dynamically.

Remember, this combo box will dynamically populate with the choices from your SharePoint list, and users can easily search and select the desired option!

No comments

Powered by Blogger.