PowerApps: Patch SharePoint Lookup, Person and Choice Fields

#PowerApps #Beginner #SharePoint

In this video I show how to work with and Patch complex SharePoint field types in Power Apps including: Lookups, Choice and Person Fields.

[Slash]

These are tricky! I had to work out the person one and the lookup one for a project recently

[mattmauren]

Dang. All that in 8mins and 20secs. You are so good at editing these tutorial videos together, April. GREAT vid. Really enjoy the straight-forward approach to your content.

[SanjivVenkatram]

Greetings April & at the cost of sounding old fashioned, God bless you! Life saver! Thanks so much!

[vpavan]

The lady with short and sweet videos to pull the citizen developers from their road blocks.
A very big shoutout to you April for all your time and help.

[merdwerkz]

Fantastic, April! I was trying to figure out how to write a text value to a new column from the selection made in a lookup from a SharePoint list to kick off a work flow to update the lookup based on the text field value (whew😅). This explanation totally saved my bacon. I was able to solve my problem so much easier. Nice work - thank you!

[MrAglakshmi]

Thank you April for your video. well worth tips! I was searching solution for this for hours and finally found this! You saved my day!

[donaldscott]

Thank you, April! You provided the answer I've been seeking for a week, or maybe a month!

[_divyaakula]

@April you are my angel, was struggling for the whole day for these field types.Thanks a lot.

[DanielSarmientoPayares]

The best video I ever seen about powerapps tricks

[briancanfield]

Thank you! I'm finally able to wrap my thick head around these concepts ✌✌

[Giu.Tanaka]

Usefull video.
I'd like to understand more about those fields for person column.

[loveandhate]

Thanks !
So, if I have a DropDown control (related to another SP list) in my form, I can't use SubmitForm, but Patch only ?
Correct ?
Or perhaps to use SubmitForm for populating MOST of the fields and THEN Patch to fill this ONE DropDown (related to another SP list).
Feasible or not ?

[luzaaneisa]

Excellent, If there is a need to approve adding another record to combobox which relates to a lookup column that retrieves vendor from vendors list, how can I go about it, any help is appreciated.

[jhhatcher]

OMG you are AWESOME - thanks this worked like a charm, and let me tell you I looked everywhere for the answer on dropdowns. WHOOO HOOOO - THANK YOU. Can you do a walkthrough on adding a datepicker?

[mouctechy]

Thank you! I am currently running into an issue on how to edit person or group of person fields. When I use an editform, I can create, delete but update is only working if I populate other fields but if I remove fields it's not reflecting on the data source even though those fields are not required. Any help?

[douglashill]

Hey April, first, love all the material, I have learned a ton, my only critique is (which is probably because I am a beginner), is that you run everything within the app. How is a user accessing this? Are they creating new item from SPO? Is this a mobile App and that's how they will view it vs going into SPO. I guess I'd like to see the functionality outside of the application.

[村花瓢儿白]

Hi April, Your videos' are always very help, Thank you very much!! I have an issue, once click the "Patch" button, the values (two combox : people & status) saved the sharePoint which are good, then the app crashed, pop up window shows "You have exited the app", "refresh the page to reload the app", then empty screen, no form showing up, no matter create new or edit exist record (customized the form using app, still use Sharepoint), I don't know what is wrong, any suggestions? many thanks!!

[vivekanandade]

Hello, great guidance thanks for this. I want to get distinct values from lookup column, I am having lookup column Business unit, it is getting values from another list with duplicate values, I want to show unique value in my drop-down, please help, district isn't working for me.

[breganyou]

Love your videos. I'm trying to find out how to patch a SharePoint person column with multiple values. I'm my Powerapp I'm using a combo box for the people picker. I've found videos on how to patch multiple person field, it but the values are hard coded. I need a way to patch multiple people from the combo box people picker input from my user. So far, I can't find out how to do this. Any ideas? Thanks again.

[billybarbarian]

In the patch for the lookup Combo Box I do not have the ".Id" property available. I do have the ".title" available. I can wrap the .title in the value() function without error but it does not work when submitting ("the specified column is generated by the server and cant be specified" (passing a number in the id field (2) returns this same error)) and it does not display an ID value.

Great video! Love your work! God bless! Thanks for doing what you do=)