Dunnam, you are an utter legend! I have been writing and re writing formula trying to patch multi select values based on cascading option sets. Fail after fail after fail. I watch your video and 20 minutes later boom, it works.
This video was quite helpful to me. Thank you so much ma'am. And just a suggestion of renaming the title. I guess people would like if you added some text like lookup, or combo-box in the title of the video. Took me so long to get this beautiful video, with a lucid explanation.
@@AprilDunnam So now that we saved to a PEOPLE field. When I bring that record back in to my app screen again, is there a way to populated the combo box search field (with those people) so I can remove and/or add people? Thank you!!! Rob.
Very usefull tutorial. PA is sometimes really tricky to figure out. One question though : What is the benefit of ClearCollect(MyColl,Blank()) compared to Clear(MyColl) ? Thank you
This is the one which I was looking for so long! thank you for this tutorial. just one question can you tell how to Append to this Multi select LookUp? Many Thanks!
@@AprilDunnam Speaking of which, recently I was shocked to know that he is a Brit (not that it really matters but still)! Could have never imagined that from his accent.
Hi April. Thanks for your helpful video. My parent and child lists are document libraries; it works great if I use lists. However, with libraries, it gives me an error message in the patch section.
Hi April, I just bounced on this video as I needed some insight into what I was doing. For some strange reason, the Office365UsersV2 wasn't working for me in displaying all my AD users in the combo box. I had to revert to the one without the V2 which worked. I know its almost 2 years since this video but I would have thought V2 was suppose to be the improvement. I spent hours trying to figure out why but to no avail. Any thoughts on what I may be missing? 😉
this is good! If I have an If statement to determine whether to patch an existing entry or to create new (default), would I need to specify the full patch including all of the field names and the values on both patch codes? Can I store it in a variable or collection instead?
Hi April, thank you for all your videos. We have customized your open source apps and used it in our team. We also added lots of new features and configurability. I have some concerns though, I would love to see if you can show the proper way on the following things: 1. Configuration file for PowerApps (e.g. dynamically change images using sharepoint list url, etc.) 2. CI/CD 3. Staging and Testing phases in PowerApps 4. Best Practices Thank you and cheers!
Hey there - happy to hear you're using and customizing some of my apps! It's definitely on my list of videos to make to talk more about the deployment process for apps :)
Hi April, Thanks for this. However what the concat function for the people picker is concerned it does not work for me. The patching with the collection goes fine but for me, but to display the email adresses coming from the person field of sharepoint , I dont get the property Displayname when putting the a dot after the fieldname in the gallery. It does not show me any property.
This is sooooooooo close to accomplishing what I'm trying to do: I have a SharePoint list with a multi-select column and I'd like to filter the gallery in PowerApps based on those values. Example data Title Column = Food Name / Multi-Select Column = Meals Orange / Breakfast Apple / Breakfast, Dessert Sandwich / Lunch, Dinner Soup / Lunch, Dinner Salad / Lunch, Dinner Bacon / Breakfast, Lunch In this example, using PowerApps, how can I sort a gallery to show me all of the food that is appropriate for lunch, or allow the user to select the desired meal(s) to find relevant food items? Thank you a million times over for your videos.
Thanks for pointing this out! That's something that we all learn the hard way at some point (I know that's how I learned). I should have called it out in the video.
Thanks for this post April its really useful. I am working with a lookup column that is a site column derived from a list in another site (in the same site collection). I found I the Patch command doesn't recognise the site column. To test further I created a local lisyt in the same site, created a lookup site column to this list and your solution works fine. Any idea why PowerApps doesn't recognise a site column form a list in another site? I am working with a form btw
Exactly what I was looking for for my team selector option! My only issue is I can't seem to get my view form to display more than 1 person. Her fix was for a gallery, but forms don't have a Text section. Does anyone know the solution for this?
Does this work in Gallery? What I mean is, it is possible to have a ComboBox where a user can select different multiple items per row? Because on the last part you just converted it into a text. Basically a MultiSelect ComboBox inside a gallery where a user can change the values of the ComboBox then display the entire list for selection but also keep track of what the user has selected for each row in the gallery. I have been scratching my head for quite some time now regarding this.
Hi April, this looks to be exactly what I need. However, when I attempt to create the collection I receive an error "Name isnt valid. 'colSoftwareToPatch' isnt recognized. Is there something else I need to do? Thanks.
Thank you April - that solved my problem! However a new problem came up - my edit form used in the app stopped working correctly. When I edit the item in edit form and click on button with Submitform function, I receive a 'Network error when using Patch function: An unknown error occured'. This only happened after I modified the app according to the instructions. So multiple people are patching correctly to the SharePoint list but I cannot edit the entries anymore. Any ideas anyone? Thanks!
Hi - nice video :-). Afollow up question though... let’s say you patch a couple more so that the gallery has 3 records/items. If you then go back and select this record in the gallery - how do you get the combo box to read your datasource and show these 2 named in the combo box...? (defaultselecteditems). I’ve experienced you can get the cb searchfield to show the names, but they’re not actually selected. So if you want to edit and add a third name you need to pick all 3 from scratch. Please prove me wrong... Thanks :-)
Great video, April, & soooo close to what I’m struggling with right now: multi select choice column with fill-in allowed. How would we handle that? (Please)
Hey Jim! Matthew Devany recently had a great blog post that spoke about havining an "other" option for drop downs that might be useful: matthewdevaney.com/create-a-dropdown-with-an-other-option-in-power-apps/
I've tried it all, but I have a combo box which has a data source of a SharePoint list and it doesn't work. I can patch data from the combo box to another SharePoint list where I store all the records, but once I wish to retrieve the data and allow the user to edit items, it does fail. Within my app I do not use forms, only galleries and the patch function and it is not an option to rebuild it from scratch... any ideas to solve it?
Very helpful video, what can i do if i want to get only one person value from the people picker? For example, I want Hugo email to send him an approval request
You can use the First() function or FirstN() to return a single item from the people picker. Here's more on those functions: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last
I have the same request but instead of choice my combo box item is a list from SharePoint, and I'm also patching in single of text column, could you please 🥺 suggest me, I'm stuck
Dear if i would like to update records in a gallery using checkboxes to sharepoint lookup field using patch field how to do the patch function . I am stuck on it and i need your help please
@@devonmorgan7569 Yup i did , it is a complex column you need to take care of ID and values. I just collected result in collection and patched the collection. Let me know if you need more help.
Hey there - this post on the Power Automate Community forum should helped with that: powerusers.microsoft.com/t5/General-Power-Automate/Return-only-first-item/td-p/327198
I tried this and it worked but i'm trying to use this in conjunction with submit and for whatever reason when i add SUBMIT FORM before it only the first person in the collection is patched. If I REMOVE the submit for all of the users are patched. this is a really peculiar issue.
Any idea how to get these results back in a combo box that you have stored in SharePoint, so in my situation, I have a screen with crontols, var set to view or new, if its new, combo show the lookup to users , if it view, i want it to populate with the options I have in my SP item that has been passed to that screen, all the simple bits like the if view or new etc, is cool, and the item ive passed, but not sure how to display the items, as it doesnt like anythiing I out in.
Sorry you feel that way. I pay for RU-vid premium so I don't have to see advertisements. I don't mind them though because I know how much work it takes to produce content and will gladly deal with ads to support the work people are putting into this.
My patch gives me an error message, even that I use the ForAll previously to it. Maybe, that's because I don't previously have a predetermined list to use in a LookUp field in a SharePoint List. I have to let the user to define the list and then
I'd suggest posting on the power users forum. I've heard several people say that they've gotten it to work. Maybe posting the formula you're trying to use on the forum would provide a way to troubleshoot the error. I don't have much to go on with "again this is not working".