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.
Hey, April, I love your videos always super helpful. Unfortunately, I can't get this one to work for me. I'm trying to patch to a current record with a multi person person column. I did set my ForAll and Patch exactly as you did except using a lookup for the patch instead of defaults. Is there something else I need to do to patch to an existing record? Thank you so much for any assistance.
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.
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 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.
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.
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?
@@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.
@@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.
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?
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.
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? 😉
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.
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
@@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.
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!
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
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?
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!
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.
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
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
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, 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 :)
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 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.
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
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 :-)
Sorry you feel that way. I pay for RUclips 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".
I was able to go from not knowing how to patch multiple users, to fully understanding it in
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.
Thank you for the helpful content. would you please explain what should be the DefaultSelectedItems for the combobox?
Great video, thanks. I was trying to figure out what the patch wanted for multi-select, this helped a lot.
Hi April, Could please show how to upload multiple files in SharePoint library using upload attachment control.
This helped out something I have been stuck on for days. Thank you.
I'm glad I could help get you unstuck!
@@AprilDunnam I had to redo this project, and this was once again, invaluable.
Hey, April, I love your videos always super helpful. Unfortunately, I can't get this one to work for me.
I'm trying to patch to a current record with a multi person person column. I did set my ForAll and Patch exactly as you did except using a lookup for the patch instead of defaults. Is there something else I need to do to patch to an existing record? Thank you so much for any assistance.
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.
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 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.
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.
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?
OH THANK YOU!!!!
Very clearly explained...
On a side note.... MS really should make this process easier.
Glad I explained it clearly! No arguments here on that!
@@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.
I am getting error when i am patching lookup column of doesnot match the expected type "Record" found type "Table"
I am getting the same error. Did you resolve this issue?
@@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.
Short video, huge tips!! Nice job!
Glad you liked it!
This is extremely helpful!!! I've been looking for it for a long time. Thank you!
Glad it was helpful!
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?
This is great! Thank you very much for explaining it as was looking for this for some time
You're welcome! Glad I could help!
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.
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? 😉
MAKE SURE you write the Collect function as "Id" NOT "ID" - you are welcome. Just spent my entire day trying to figure that out!
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.
But how do we then later remove one of selected items from the data source when unselecting from the combobox? :)
Hi April, how can we use combobox in repeating table situation? Can you please post link if you already have on. Thank you
Hi April, many thanks for this tips.
You are so welcome!
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
This is exactly what I needed too! Thank you!!
So glad!
Thank you SO MUCH! This has been bugging me for days! ⭐⭐⭐⭐⭐
Glad I could help!
Great video as always April, very informative !!!
Funny reference to Bobby Axelrod too, I mean who doesn't like Billions right? ;-)
Glad you liked it! You were the first to notice the Billions reference :)
@@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.
@@pankajdarure4940 Yeah I was shocked when I realized he was Brittish. He pulls off the American accent so well!
Exactly that i want, Tks so much!!!! :)
I'm glad it was helpful!
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!
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
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?
Nice! How to patch multiple records on different existing rows at once?
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!
Excellent.Thanks for this tutorial
You're welcome! Glad it was helpful!
What if I want to patch multiple tasks with multiple assignees to individual rows? So that 3 tasks with 3 assignees would turn into 9 rows
Thank you April! I assume if we wanted to delineate the records patched to SharePoint List by Person, use a ForAll + Patch?
Yes that's correct!
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.
This is extremely helpful. I'm struggling with getting a multi select into a document library. Any help is greatly appreciated.
Thanks April for all your excellent work and sharing
Thanks for watching!
Could you make a similar video for dataverse. Thankyou
perfect, so in Power automate when I have a field with mutli selected options, how can I get items based on the first selected value only
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
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
How do i set a default value for powerapps gallery, i tried Lookup(mycollection, columnname = "value") this didnt work
Thank you so much for doing this video! Very helpful
You're very welcome! Glad it was helpful - thanks for watching!
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, 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 :)
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/
@@AprilDunnam Exactly what I was looking for! Thanks, April (& Matthew)
Excellent video. Subscribed. Thank you!
Thanks for the sub!
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.
This is EXACTLY what I needed to solve a problem I've been having too! Thank a million
Great to hear - glad it helped you overcome a problem. Thanks for watching!
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.
I would love to know this as well. Been trying to figure it out for days.
I'm getting this error - Network Error when using Patch function: The requested operation is invalid. Anyone please help.
This is EXACTLY what I needed to solve a problem I've been having!
That's great to hear Quinn!
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
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 :-)
looking for the exact same answer......
the adverts 2 seconds in your vids do my head in. i actively avoid them cos of it
Sorry you feel that way. I pay for RUclips 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.
You are awesome! :)
Thanks Bobby :)
brilliant
Thank you!
Nice
Thanks!
This is exactly what I need but it didn't work :/
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
Again, this is not working.
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".