Power Apps: Drop down VS Combo box VS List box

Подписаться 27 тыс.

Просмотров 19 тыс.

50% 1

This video does a side-by-site comparison between the Drop down, Combo box and the List box controls. It also shows you some much needed work arounds for List box.
The app demoed in this video is available in the Power Apps community. Here's the link-
powerusers.microsoft.com/t5/W...
Also, if you are interested in further deep-dive videos on how to use the Drop down and Combo box controls then here are the links to Shane's videos
Dropdown
• PowerApps Multiple Dat...
Combo box
• PowerApps Office 365 U...
Interested in my blogging gear? Then take a look at them on Amazon:
- Blue Yeti USB Mic for Recording & Streaming on PC and Mac - amzn.to/3d9g7bY
- Microphone Stand, Mic arm Desk Adjustable Suspension Boom with accessories - amzn.to/2N0YNLp
- Neewer 2 Packs Dimmable 5600K USB LED Video Light with Adjustable Tripod - amzn.to/3qteqdf
- Flexible Desk Mount Clamp Gooseneck Stand for Logitech Webcam - amzn.to/2Ozc4eH
- Sunpak tripod - amzn.to/3jJeov2
- Logitech C922x Po Stream Webcam - amzn.to/3aZlqrt

Наука

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@JeevarajanKumar 3 года назад

Love the collectables and the t.shirt, Daniel. May the force be with you :)

@DanielChristian19 3 года назад

Thanks Jeevarajan. I've collected those over a few years and proudly display them.

@fromchandan 3 года назад

Thank you so much! I was really struggling to filter a dependent combo boxes. This video gave a clear picture how to apply filter.

@DanielChristian19 3 года назад

Your are welcome. Glad this video helped.

@vikramsingh-ws2nn 4 года назад

This is simply great Daniel cleared my issues.

@DanielChristian19 4 года назад

Your welcome!

@vikramsingh-ws2nn 4 года назад

@@DanielChristian19 we are looking more videos, as you share best practices only. I am your great fan

@StephanOnisick 2 года назад

Always learn something from you. Thanks!

@DanielChristian19 2 года назад

Glad to hear it!

@jray1429 2 года назад

Great job! Very informative and useful Thanks!

@DanielChristian19 2 года назад

Glad it was helpful!

@michaeldeabreu2020 4 года назад

Combobox is the most frustrating control inside a gallery as the OnChange creates loops and the DefaultSelectedItems do not work like "this item.x" you have to do search or filter

@jaimetreadwell9228 4 года назад

Very clear, thanks. I have a question, I have been struggling with a dropdown box. I have a data source (it is a Sharepoint list) and another list that will store only one column/box (the one I have selected and set up as a LookUp), this depends on another box, when applying a filter it shows me the options that I want to, but at the moment of Submit the Form, it doesn't update in the list of stored data, it still shows the previous value. I have already tried saving it in some variables and trying to save directly, but it remains the same. (Kind of cascading dropbox)

@DanielChristian19 4 года назад

Hi Jaime, You'll have to do some detective work to isolate the problem. Add a few labels and set their default values to the collection to see what is going on. Based on the information you have provided you might need to look into ForAll or UpdateIf functions.

@jaimetreadwell9228 4 года назад

@@DanielChristian19 Thanks Daniel, I'll try those functions :)

@kanishkaroychowdhury4050 4 года назад

great video... one question... if i want to remove any previous item from the list box in edit mode... how to do it plz?

@DanielChristian19 4 года назад

Thanks for the compliment Kaniskay. Use the Remove function. Here is an example of the formula: Remove( Contacts, Gallery1.Selected )

@moyura2 2 года назад

Thank Daniel, how would you navigate screen using selected value from a listbox ?

@DanielChristian19 2 года назад

Hi Moyra, For the OnSelect() of the Listbox use Navigate()

@sterileprocessingdepartmen5926 3 года назад

Hi Daniel, how can I default a dropdown box with no text when and item or text is not selected? when I create a new list its always defaulted to a selected text?

@DanielChristian19 3 года назад

Hi Central Sterile Processing, The drop down control has a an IsEmpty property which you can use to set the default to blank.

@ReneLopez-vb6gb 3 года назад

Good video Daniel, I have a listbox with 8 items, I have not been able to resolve that when selecting more than one item they go to their respective variable that I have for each item when saving it, it only saves the last selected item, could you give me an example of how to get each item in each respective variable, without the need for a collection, thanks for your help.

@DanielChristian19 3 года назад

Hey Rene', You can try using the If and Set function this way. If( ListBoxName.Selected.Valule="Option1", set(Option1Var, "Option1"), ListBoxName.Selected.Valule="Option2", set(Option2Var, "Option2"), ListBoxName.Selected.Valule="Option3", set(Option3Var, "Option3"), ... )

@harshadborhade8723 3 года назад

Hi Daniel, it is informative video thanks... I have one query regarding combo box multiple selection option. While adding new data, when I select multiple values in combo box, it works fine and save proper data as expected. But when I try to edit this existing data, I can see additional values selected in combo box. For eg- while adding data, I have selected only Admin2 as on of the value. While editing, system shows Admin as well as Admin2 as selected values in form edit mode. I tried using both in and exactin queries. Can you please suggest.

@DanielChristian19 3 года назад

Hey Harshad, There is a workaround for that. You use ClearCollect() function for both the Select and Unselect. Then you save the data that is in the collection.

@harshadborhade8723 3 года назад

@@DanielChristian19 I tried using both the queries. But I think it is working as contains logic. I want to check exact values.

@dharanyadv2138 3 года назад

Hi Daniel, How do i tie up a data source that has more than 500 records to a Combo box? I have a list tat has 513 records and wanted to tie it to a combo box. The query i used is very simple, Sort('Listname', Title, Ascending). But its not working

@DanielChristian19 3 года назад

Hey Dharanya, My recommendation would be to replace the combo box with with a gallery and then using the filter function using a text control.

@hondaokay 2 года назад

Thanks. I have a question, Is it necessary to set up gally to get combobox selected content? If not, how can DefaultSelectedItems be set? My current practice is to set up a textinput and use the concat formula to link all options, but the combobox data will disappear after saving. It seems to be a problem with DefaultSelectedItems, but I don’t know how to set it.

@DanielChristian19 2 года назад

Try this, for the OnSelect of a button or OnChange of the text, save the DefaultSelectedItem to a Set variable. That way you will not loose it.

@hondaokay 2 года назад

@@DanielChristian19 Sorry, I still don’t know what to do. Would you like to provide examples?

@mikelennon1078 3 года назад

One question, if we have a list box (data validation) it will be in a cell, then in VBA we can address that particular cell value ( D2 here). i.e. =IFERROR(MATCH(D2.Value,CustID,0)+3,"") How can this be done with Combo Box?

@DanielChristian19 3 года назад

Hi Mike, With Power Apps you can reference the row and column using filter function. My recommendation would be to use a gallery for something like this and not a combo box.

@mikelennon1078 3 года назад

@@DanielChristian19 Thank you Dan, I am not sure if I follow. Would you please elaborate? I would appreciate it.

@mikelennon1078 3 года назад

@@DanielChristian19 All I need is to get the the Row number or record ID for each selected name and show this value in a dedicated cell.