Hi April, Could please show how to upload multiple files in SharePoint library using upload attachment control.
@denis73692 жыл бұрын
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
@explainingpowerplatform81913 жыл бұрын
I am getting error when i am patching lookup column of doesnot match the expected type "Record" found type "Table"
@devonmorgan75693 жыл бұрын
I am getting the same error. Did you resolve this issue?
@explainingpowerplatform81913 жыл бұрын
@@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.
@pat_mefisto Жыл бұрын
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!
@user-th4mr6sd7p10 ай бұрын
I'm getting this error - Network Error when using Patch function: The requested operation is invalid. Anyone please help.
@Kej121 Жыл бұрын
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.
@gaborpataki875 ай бұрын
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?
@pawanachettri Жыл бұрын
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
@lucswankaert30607 ай бұрын
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.
@DanielTysonM4 ай бұрын
But how do we then later remove one of selected items from the data source when unselecting from the combobox? :)
@PeterGMcDermott3 жыл бұрын
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.
@dougydoe2 жыл бұрын
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? 😉
@golfnutt8 Жыл бұрын
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.
@ashmon083 жыл бұрын
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.
@hsedigh386710 ай бұрын
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.
@Itsprincessa013 жыл бұрын
How do i set a default value for powerapps gallery, i tried Lookup(mycollection, columnname = "value") this didnt work
@gabrielmonster47413 жыл бұрын
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?
@vishaljhaveri75652 жыл бұрын
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.
@Goose1986RIP7 ай бұрын
I was able to go from not knowing how to patch multiple users, to fully understanding it in
@joenice2422 жыл бұрын
Nice! How to patch multiple records on different existing rows at once?
@PreFereall2 жыл бұрын
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?
@Mikegritton7 ай бұрын
Great video, thanks. I was trying to figure out what the patch wanted for multi-select, this helped a lot.
@ahmadyamout11153 жыл бұрын
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
@DiyEverythingAlways3 жыл бұрын
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
@MrDionmar Жыл бұрын
Exactly that i want, Tks so much!!!! :)
@AprilDunnam Жыл бұрын
I'm glad it was helpful!
@daniellees5723 Жыл бұрын
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.
@pkp0443 жыл бұрын
Hi April, how can we use combobox in repeating table situation? Can you please post link if you already have on. Thank you
@pankajdarure49403 жыл бұрын
Great video as always April, very informative !!! Funny reference to Bobby Axelrod too, I mean who doesn't like Billions right? ;-)
@AprilDunnam3 жыл бұрын
Glad you liked it! You were the first to notice the Billions reference :)
@pankajdarure49403 жыл бұрын
@@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.
@AprilDunnam3 жыл бұрын
@@pankajdarure4940 Yeah I was shocked when I realized he was Brittish. He pulls off the American accent so well!
@neillmison82353 жыл бұрын
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
@olivaadak3 жыл бұрын
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!
@surajranabhat35512 жыл бұрын
Could you make a similar video for dataverse. Thankyou
@raissabenoccithibes37682 жыл бұрын
This is exactly what I need but it didn't work :/
@raissabenoccithibes37682 жыл бұрын
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
@s9612013 жыл бұрын
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 :-)
@IanHudsonih3 жыл бұрын
looking for the exact same answer......
@themacetones2 жыл бұрын
the adverts 2 seconds in your vids do my head in. i actively avoid them cos of it
@AprilDunnam2 жыл бұрын
Sorry you feel that way. I pay for KZbin 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.
@jamiebautista35293 жыл бұрын
MAKE SURE you write the Collect function as "Id" NOT "ID" - you are welcome. Just spent my entire day trying to figure that out!
@AprilDunnam3 жыл бұрын
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.
@bckick3 жыл бұрын
This is extremely helpful. I'm struggling with getting a multi select into a document library. Any help is greatly appreciated.
@emanmuteb6453 жыл бұрын
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
@AprilDunnam3 жыл бұрын
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
@Spurr823 жыл бұрын
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.
@IanHudsonih3 жыл бұрын
I would love to know this as well. Been trying to figure it out for days.
@Kylbigel3 жыл бұрын
Thank you April! I assume if we wanted to delineate the records patched to SharePoint List by Person, use a ForAll + Patch?
@AprilDunnam3 жыл бұрын
Yes that's correct!
@rula12373 жыл бұрын
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
@AprilDunnam3 жыл бұрын
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
@karolinaunderwood1039 Жыл бұрын
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!
@Garfield117893 жыл бұрын
Thank you SO MUCH! This has been bugging me for days! ⭐⭐⭐⭐⭐
@AprilDunnam3 жыл бұрын
Glad I could help!
@cyberpau22983 жыл бұрын
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!
@AprilDunnam3 жыл бұрын
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 :)
@rpremaza3 жыл бұрын
OH THANK YOU!!!! Very clearly explained... On a side note.... MS really should make this process easier.
@AprilDunnam3 жыл бұрын
Glad I explained it clearly! No arguments here on that!
@rpremaza3 жыл бұрын
@@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.
@MulaMuster2 жыл бұрын
Again, this is not working.
@AprilDunnam2 жыл бұрын
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".
@deecheanwang57643 жыл бұрын
This is extremely helpful!!! I've been looking for it for a long time. Thank you!
@AprilDunnam3 жыл бұрын
Glad it was helpful!
@jimfitch3 жыл бұрын
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)
@AprilDunnam3 жыл бұрын
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/
@jimfitch3 жыл бұрын
@@AprilDunnam Exactly what I was looking for! Thanks, April (& Matthew)
@prasadathalye12433 жыл бұрын
This is EXACTLY what I needed to solve a problem I've been having too! Thank a million
@AprilDunnam3 жыл бұрын
Great to hear - glad it helped you overcome a problem. Thanks for watching!
@ThomasS17768 ай бұрын
This helped out something I have been stuck on for days. Thank you.
@AprilDunnam8 ай бұрын
I'm glad I could help get you unstuck!
@ThomasS17763 ай бұрын
@@AprilDunnam I had to redo this project, and this was once again, invaluable.
@jlvanvalk3 жыл бұрын
Excellent video. Subscribed. Thank you!
@AprilDunnam3 жыл бұрын
Thanks for the sub!
@winnerbelieve65512 жыл бұрын
Excellent.Thanks for this tutorial
@AprilDunnam2 жыл бұрын
You're welcome! Glad it was helpful!
@Poryotis3 жыл бұрын
Thank you so much for doing this video! Very helpful
@AprilDunnam3 жыл бұрын
You're very welcome! Glad it was helpful - thanks for watching!
@hayleeadamson64492 жыл бұрын
This is exactly what I needed too! Thank you!!
@AprilDunnam2 жыл бұрын
So glad!
@christerrussberg3059 Жыл бұрын
Hi April, many thanks for this tips.
@AprilDunnam Жыл бұрын
You are so welcome!
@quinnhenry67193 жыл бұрын
This is EXACTLY what I needed to solve a problem I've been having!
@AprilDunnam3 жыл бұрын
That's great to hear Quinn!
@sundrapillay66683 жыл бұрын
Thanks April for all your excellent work and sharing