Great video, thanks. I was trying to figure out what the patch wanted for multi-select, this helped a lot.

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.

I was able to go from not knowing how to patch multiple users, to fully understanding it in

This is extremely helpful!!! I've been looking for it for a long time. Thank you!

@AprilDunnam

2 жыл бұрын

Glad it was helpful!

This is EXACTLY what I needed to solve a problem I've been having too! Thank a million

@AprilDunnam

3 жыл бұрын

Great to hear - glad it helped you overcome a problem. Thanks for watching!

Thanks April for all your excellent work and sharing

@AprilDunnam

3 жыл бұрын

Thanks for watching!

This is great! Thank you very much for explaining it as was looking for this for some time

@AprilDunnam

Жыл бұрын

You're welcome! Glad I could help!

Thank you so much for doing this video! Very helpful

@AprilDunnam

3 жыл бұрын

You're very welcome! Glad it was helpful - thanks for watching!

This is EXACTLY what I needed to solve a problem I've been having!

@AprilDunnam

3 жыл бұрын

That's great to hear Quinn!

This is exactly what I needed too! Thank you!!

@AprilDunnam

2 жыл бұрын

So glad!

Thank you SO MUCH! This has been bugging me for days! ⭐⭐⭐⭐⭐

@AprilDunnam

2 жыл бұрын

Glad I could help!

Excellent.Thanks for this tutorial

@AprilDunnam

Жыл бұрын

You're welcome! Glad it was helpful!

Excellent video. Subscribed. Thank you!

@AprilDunnam

3 жыл бұрын

Thanks for the sub!

Hi April, many thanks for this tips.

@AprilDunnam

Жыл бұрын

You are so welcome!

Short video, huge tips!! Nice job!

@AprilDunnam

3 жыл бұрын

Glad you liked it!

Exactly that i want, Tks so much!!!! :)

@AprilDunnam

Жыл бұрын

I'm glad it was helpful!

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.

This helped out something I have been stuck on for days. Thank you.

@AprilDunnam

5 ай бұрын

I'm glad I could help get you unstuck!

@ThomasS1776

13 күн бұрын

@@AprilDunnam ​ I had to redo this project, and this was once again, invaluable.

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!

OH THANK YOU!!!! Very clearly explained... On a side note.... MS really should make this process easier.

@AprilDunnam

3 жыл бұрын

Glad I explained it clearly! No arguments here on that!

@rpremaza

3 жыл бұрын

@@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.

This is extremely helpful. I'm struggling with getting a multi select into a document library. Any help is greatly appreciated.

You are awesome! :)

@AprilDunnam

3 жыл бұрын

Thanks Bobby :)

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!

@AprilDunnam

3 жыл бұрын

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 :)

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 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?

brilliant

@AprilDunnam

2 ай бұрын

Thank you!

Great video as always April, very informative !!! Funny reference to Bobby Axelrod too, I mean who doesn't like Billions right? ;-)

@AprilDunnam

3 жыл бұрын

Glad you liked it! You were the first to notice the Billions reference :)

@pankajdarure4940

3 жыл бұрын

@@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.

@AprilDunnam

3 жыл бұрын

@@pankajdarure4940 Yeah I was shocked when I realized he was Brittish. He pulls off the American accent so well!

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

Hi April, how can we use combobox in repeating table situation? Can you please post link if you already have on. Thank you

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.

Hi April, Could please show how to upload multiple files in SharePoint library using upload attachment control.

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.

Nice

@AprilDunnam

3 жыл бұрын

Thanks!

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?

MAKE SURE you write the Collect function as "Id" NOT "ID" - you are welcome. Just spent my entire day trying to figure that out!

@AprilDunnam

2 жыл бұрын

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.

Nice! How to patch multiple records on different existing rows at once?

Could you make a similar video for dataverse. Thankyou

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.

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? 😉

Thank you April! I assume if we wanted to delineate the records patched to SharePoint List by Person, use a ForAll + Patch?

@AprilDunnam

2 жыл бұрын

Yes that's correct!

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

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!

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

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

@AprilDunnam

3 жыл бұрын

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

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)

@AprilDunnam

3 жыл бұрын

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/

@jimfitch

3 жыл бұрын

@@AprilDunnam Exactly what I was looking for! Thanks, April (& Matthew)

But how do we then later remove one of selected items from the data source when unselecting from the combobox? :)

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.

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?

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.

@IanHudsonih

3 жыл бұрын

I would love to know this as well. Been trying to figure it out for days.

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.

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

@AprilDunnam

3 жыл бұрын

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

How do i set a default value for powerapps gallery, i tried Lookup(mycollection, columnname = "value") this didnt work

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

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 - 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 :-)

@IanHudsonih

3 жыл бұрын

looking for the exact same answer......

the adverts 2 seconds in your vids do my head in. i actively avoid them cos of it

@AprilDunnam

2 жыл бұрын

Sorry you feel that way. I pay for KZread 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.

I'm getting this error - Network Error when using Patch function: The requested operation is invalid. Anyone please help.

I am getting error when i am patching lookup column of doesnot match the expected type "Record" found type "Table"

@devonmorgan7569

2 жыл бұрын

I am getting the same error. Did you resolve this issue?

@explainingpowerplatform8191

2 жыл бұрын

@@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.

This is exactly what I need but it didn't work :/

@raissabenoccithibes3768

2 жыл бұрын

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.

@AprilDunnam

Жыл бұрын

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".