Тёмный

Convert Multi-Select Choice Field to Checkboxes in Power Apps 

Andrew Hess - MySPQuestions
Подписаться 8 тыс.
Просмотров 14 тыс.
50% 1

This question came from one of you, and thank you for asking. Such a great idea! In this video we use a multi-select choice field in SharePoint and covert it into multiple checkboxes in Power Apps.
As you select a checkbox and submit the form the data is saved as a multi-select choice field.
0:00 Introduction
1:20 Creating a Multi-Choice Field in SharePoint
2:00 Refreshing the Datasource
3:00 Replace combobox with check boxes
4:15 Collect OnCheck Property
5:04 RemoveIf OnUnCheck Property
6:20 View Collection in a Listbox
6:45 Update Property of Combobox Card
8:28 Concat Selection for Default Property
9:45 If Find() IsBlank()
11:14 OnVisible Property of New Form ClearCollect
13:50 Conclusion
Concat ThisItem Formula:
Concat(ThisItem.LifeCycle,Value,",")
Default of Checkbox Formula:
If(IsBlank(Find(Checkbox1.Text,Label15.Text)),false,true)
Update Card Formula:
colLifeCycle
OnVisible of Screen Formula:
ClearCollect(colLifeCycle,galProjects.Selected.LifeCycle);

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

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 57   
@javierpereyra7098
@javierpereyra7098 2 года назад
Very good content Andrew! thanks for always bringing something to teach us :)
@andrewhess123
@andrewhess123 2 года назад
Thanks so much Javier! thanks for always supporting me! I appreciate it a ton!!!
@PowerAppsTutorial
@PowerAppsTutorial 2 года назад
Very nice! ...and I love that mic!
@andrewhess123
@andrewhess123 2 года назад
Thanks Darren! 1 step at a time, now I need a green screen 😃
@christerrussberg3059
@christerrussberg3059 Год назад
Hi Andrew, thanks for this tip.
@andrewhess123
@andrewhess123 Год назад
Hi Christer, thanks for watching! 😀
@PauloHenrique-ln1vm
@PauloHenrique-ln1vm 2 месяца назад
Very good, thanks!
@andrewhess123
@andrewhess123 2 месяца назад
Obrigado amigo! Made an assumption you knew Portuguese, hope I was right 😅I also love learning other languages
@meliajones4690
@meliajones4690 Год назад
I have noticed when selecting a checkbox that selection is showing on all SharePoint records, not staying unique to the one editing. Can you assist with fixing that?
@Vikki-zj4ss
@Vikki-zj4ss 3 месяца назад
Hi Andrew, Thank you so much for the tutorial. Have been looking for this kind for many days. I have been using data verse choice column with recommended type, which will refer choices from a choice table. Any thoughts or help on implementing these on those type of choice columns please? Thank you
@andrewhess123
@andrewhess123 3 месяца назад
Hi Vikki, yeah with Dataverse Choice types are a little bit different! There's a couple tricks here or there that. I don't have a video on it specifically but I know Shane Young does at around 13 : 29 in his video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UJ2jwOC_TkY.htmlsi=Bt8nUDh0zGJNVaeJ&t=809 .... I will have to make a video on it myself!
@carlilelance
@carlilelance Год назад
Nice. One of the clearest tutorials out there on this subject. Unfortunately, your method isn't very dynamic. What if you have a list of 30+ checkboxes. Becomes very tedious to hard code that.
@andrewhess123
@andrewhess123 Год назад
Hi Lance, for 30+ checkboxes I would probably make each of those a single line text field and convert them to checkboxes in Power Apps, I would separate them, instead of a large choice field. Thanks for watching Lance!
@geralddahl9159
@geralddahl9159 2 года назад
Does this method work without forms? (I know your presentation is based around SharePoint but I'm envisioning Dataverse where I'm working with a multi-select combo-box in a gallery and wanting to display the results of the combo-box as checkboxes - as opposed to the combo-box just saying 5 items etc.) Thanks for this video - much appreciated!
@andrewhess123
@andrewhess123 2 года назад
Yes I believe you could make this work with Dataverse. SharePoint is only the backend, could work with any datasource I would think.
@shgall02
@shgall02 Год назад
How would you do this without a gallery?
@samk-ye1ev
@samk-ye1ev Год назад
Hello, I tried the same approach for Data Verse as data source, it is giving "Expected OptionSetValue value" error on the update property when i entered collection name. any idea?
@andrewhess123
@andrewhess123 Год назад
Hi sam k, not sure about that one
@orleevelarde9997
@orleevelarde9997 11 месяцев назад
I'm encountering an issue when reloading the powerapp. The collection is cleared upon reload and it deletes the data saved in sharepoint.
@andrewhess123
@andrewhess123 11 месяцев назад
Yes collections are only stored in the memory of the app. But deleting what was written in SharePoint is another issue. Not sure how that could happen.
@chinmaykadambalu6331
@chinmaykadambalu6331 8 месяцев назад
Hi I am facing the same issue can you help me how to resolve this issue? Thanks in advance.
@chinmaykadambalu6331
@chinmaykadambalu6331 8 месяцев назад
@@andrewhess123 Hi I am facing the same issue can you help me how to resolve this issue? Thanks in advance.
@andrewhess123
@andrewhess123 8 месяцев назад
When reloading the app, the collections should be blank this is not an issue, but the functionality. @@chinmaykadambalu6331
@orleevelarde9997
@orleevelarde9997 8 месяцев назад
@@chinmaykadambalu6331 You will need to get the data from sharepoint and save (ClearCollect) it in the collection. Add this command on Main Screen (OnVisible).
@CaptCJ1969
@CaptCJ1969 Год назад
Hi, I've been looking for a while on how to do this, thanks for the video. I do have one issue, my collection doesn't seem to update with the selections Thanks It looks like using the 'Alt' key to test didn't work. When I went into full play mode, it kicked it into life!
@andrewhess123
@andrewhess123 Год назад
Awesome Craig! Sorry I'm just getting back to you, glad you got it to work!
@CaptCJ1969
@CaptCJ1969 7 месяцев назад
Hi Andrew,@@andrewhess123 I've used this on 3 apps now, it's been great. That said on the current app (which I started last year and I'm now revisiting), when I create a new form, all checkboxes are empty, however if I check a box and submit the form, when I view the form, it has pulled the results from the previous saved form as well. New form submitted with checkbox 1 only, new form submitted with checkbox 2 only, when viewing form 2, checkboxes 1 and 2 are checked. When I looked at my SP list, 1 of my submitted forms had multiples for the selections! If I add the list box back in to see what's in the collection, it is already populated when I create a new form, even though my checkboxes are correctly unchecked. It seems like the ClearCollect on the FormScreen isn't working. Any help would be welcome. Thanks Craig
@analyticsadda6080
@analyticsadda6080 10 месяцев назад
I want not able to use collection in data card update properties. It is throwing error. Expected record value
@andrewhess123
@andrewhess123 10 месяцев назад
My assumption is the issue is with the collection, when you add the collection to the Listbox does it appear correctly?
@susanteng3592
@susanteng3592 15 дней назад
What is your code in submit button? Do you use patch? Do you have the code to patch the checkbox values to a multi-choice column in Dataverse table?
@andrewhess123
@andrewhess123 14 дней назад
Hi Susan, Most likely the datasource is SharePoint and the submit button is just submit(form1). And I am writing the selection as a single line text
@Jonathan_Vlog
@Jonathan_Vlog Год назад
Hi Andrew, thank your your video. Can you achieve this on a Form (For CRM) using Dataverse, how?
@andrewhess123
@andrewhess123 Год назад
Hi Jonathan, I'm not sure about a Model Driven app using Dataverse. Model driven apps are limited in their functionality. I do think you could create a canvas app that has a Dataverse backend or use a Dataverse for Teams app and do this.
@Jonathan_Vlog
@Jonathan_Vlog Год назад
@@andrewhess123 Yes, it is very limited, specially this new field multiselect choices. If one tries to add check boxes, it asks you to connect it with some boolean field before dropping jn the form, so your multiselect field here is not visible. I had to achieve this using a long workaround, I thought you might have some shorter workaround like the one on the video. Thank you.
@andrewhess123
@andrewhess123 Год назад
@@Jonathan_Vlog Yeah...not sure about how to get around it... yet
@gyanibaba5189
@gyanibaba5189 3 месяца назад
Thanks for the useful content, But I just want to select only one check box at a time, means Single select check for list option, Could you please assist
@andrewhess123
@andrewhess123 3 месяца назад
Hi Gyani! On the OnCheck property of each of the boxes, have it either Reset the other checkboxes or set their values to false. Those are 2 options you could do.
@gyanibaba5189
@gyanibaba5189 3 месяца назад
@@andrewhess123 SharePoint choice column converted to check box in power apps using vertically gallery and check box, but all choice option display as same check box properties and not getting on check property for each choice options
@mayankloayalka9635
@mayankloayalka9635 Год назад
Hi whenever I enter colLifecyle in the update . I get an error stating expected Record Value can u please help
@andrewhess123
@andrewhess123 Год назад
Hi Mayan, there's many things that could make this happen. Is your backend SharePoint? What does your OnCheck property say? On one of the check boxes, is it similar to Collect(colLifecycle, "Plan"), or is your column type a lookup instead of a multi choice field? Does it say Expected Record, and found what? Try this also, Collect(colLifecycle, {Value:"Plan"})..notice the curly brackets. There's lots of things that could be happening from that error message.
@christos-spyridonmoschofid3978
What does the galProjects stands for?
@andrewhess123
@andrewhess123 Год назад
galProjects is the name of my gallery on my Home Screen, the one with the red/yellow/greens
@palikaanusha3043
@palikaanusha3043 Год назад
How do I do reset the checkbox using customize forms, could you please help me that
@andrewhess123
@andrewhess123 Год назад
Hi Palika, it depends on how you have it set up, but you can set the default property to blank depending if its a new item, or edit item.
@palikaanusha3043
@palikaanusha3043 Год назад
@@andrewhess123 thanks for your response
@andrewhess123
@andrewhess123 Год назад
@@palikaanusha3043 Sorry for the late response, Holidays have taken a lot of my time 😀
@northcastleintegration6066
@northcastleintegration6066 Год назад
Every thing worked for me EXCEPT the Update. I put in the collection name (I double checked the spelling) but I get the red squiggly lines. I know the collection works because the list box test worked. When I submit the form, all of the fields get written to my Excel sheet, except for the collection. Is it because my "update" is in error? Thank you. - Paul
@andrewhess123
@andrewhess123 Год назад
You are using Excel as a backend? I believe the steps would be different, you would want to convert the Update Property to a text instead of a choice.
@andrewhess123
@andrewhess123 Год назад
A collection will not write to an Excel cell. You can write the Concat statement as a text field and then write that to Excel.
@northcastleintegration6066
@northcastleintegration6066 Год назад
@@andrewhess123 Thanks. I will try that and let you know!
@northcastleintegration6066
@northcastleintegration6066 Год назад
It populated, now I just need to figure out the if() statement to write only checked values.
@andrewhess123
@andrewhess123 Год назад
@@northcastleintegration6066 Awesome, glad you got it! Feel free to reach out, willing to help any time.
@jl1399
@jl1399 Год назад
Concat(ThisItem.LifeCycle,Value,",") what does LifeCycle in this formula represent? The column name?
@andrewhess123
@andrewhess123 Год назад
Yes
Далее
Wait! Solve Delegation Easily! In Power Apps Search
29:57
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
Просмотров 6 млн
В GEOMETRY DASH СДЕЛАЛИ GTA
00:27
Просмотров 572 тыс.
Multi Select Choice Column As Checkboxes in Power App
12:17
Multi Select Dependent (Cascading) Dropdown
14:51
Просмотров 8 тыс.
Dynamic Repeating Combo boxes in Power Apps
26:12
Просмотров 2,4 тыс.
Multiselect Checkbox Filter in Power Apps Gallery
8:49
Multi-select checkbox - PowerApps Forms   #54
11:16
Просмотров 1,7 тыс.
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
Просмотров 6 млн