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

@AprilDunnam

4 жыл бұрын

Yeah they don't make it that intuitive to figure out for sure!

@kanishkaroychowdhury4050

4 жыл бұрын

lookup i have solved, but cant figure out the person field display in edit

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.

@AprilDunnam

3 жыл бұрын

Thanks Matt!!

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

@AprilDunnam

3 жыл бұрын

You're welcome - glad it was helpful!

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!

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

@AprilDunnam

2 жыл бұрын

You're so welcome!

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!

@AprilDunnam

3 жыл бұрын

I'm so glad!

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.

@AprilDunnam

4 жыл бұрын

Thanks Sudheer 😊

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

@AprilDunnam

2 жыл бұрын

Glad I could help!

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

@AprilDunnam

2 жыл бұрын

I'm so happy to hear that Brian! Glad I could help!

@briancanfield2968

2 жыл бұрын

@@AprilDunnam 👍A quick follow-up inquiry: if I have a screen with an EditForm control, would there be a conceivable use-case for using Patch versus SubmitForm? I have an EditForm control that only includes 1 Data Card intended to be updated, and thus, the others intentionally set to DisplayMode.View. My original thought process was, "Why submit the entire form (to SharePoint) if only 1 field is being modified at a given time?".. But in retrospect, wouldn't I be better off using SubmitForm (versus Patch) so as to leverage the OnSuccess/OnFailure properties?

The best video I ever seen about powerapps tricks

@AprilDunnam

3 жыл бұрын

Thanks Daniel!

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

Great video, April! I would like to understand how to map these fields when you are using Chart options (pie, line, bars) instead of a form. You happen to have a tutorial on that already (sorry if you do, I searched for it but failed to find)? Again, thanks a lot for all the explanation, you rock :)

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 ?

Great Work

@AprilDunnam

3 жыл бұрын

Thank you! Cheers!

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?

Thanks April much appreciated

@AprilDunnam

4 жыл бұрын

You are so welcome

So useful! Thank you

@AprilDunnam

3 жыл бұрын

Glad it was helpful!

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

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?

@AprilDunnam

3 жыл бұрын

So glad to hear this was helpful! Is there something specific you're needing to know about date pickers? There isn't much to them as there is with dropdowns

@jhhatcher1885

3 жыл бұрын

@@AprilDunnam True, I have searched Hi and Low and the closest thing I have found is: CertificationRenewalDate: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", DateValue:DatePickerCertificationRenewalDate.SelectedDate}.DateValue I tried it several different ways but couldn't get it to work like your example of the Dropdown and select complex SharePoint field types. Do you have any suggestions?

Hi @April I created collection onchangeproperty of combobox which I am using in updateif function and patch for bulk update to sharepoint list. if select combobox options for different items in gallery,the patch is passing same value to sharepoint list instead of different values for each item. Appreciate your response.

I am working with a list that has a site column based on a master list and the patch command doesn't recognise the name of the column on the list I am writing back to. The list that the site column looks data up from exists in another site. Does the patch command work with lookup columns which are site columns.

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

Say you use the custom people picker combo box to lookup a user and then Patch the value for a user to the SharePoint List, how do you get the person's name to display in the combo box when you edit the record and want to change the person to someone else?

Cool video, however, nobody seems to show how you can remove a Person column value. I have a list with a person column populated but what if I need to remove the value and left it blank. It seems that I cannot patch an empty claims value. Is there a way of doing that?

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.

Thank you!!!

@AprilDunnam

Жыл бұрын

You're welcome!

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.

@AprilDunnam

3 жыл бұрын

Hey Douglas, I appreciate the constructive feedback. I'm usually so focused on showing how to do things from the edit experience of the app that I tend to stay there and overlook the holistic experience like you pointed out. I will definitely take this feedback into account for my future videos and make an effort to also demo how the end user would open and interact with the app.

Great Video. i have a request if possible can you create a video for auto select fields of a form using SQL server tables

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.

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.

@AprilDunnam

3 жыл бұрын

Hey Bobby - What you'll want to do is take the concept in those videos on how to patch multiple but wrap that inside a ForAll() function and loop through the selected items in your combo box. So you can take the selected values in that loop and output that into a collection that you can then pass in to your patch statement

Hi April, This is a really helpful video. I understood how to patch combo box to lookup column in SharePoint List. I have a requirement to patch multiselect combo box to lookup field that allows multiple values. I think that makes it more complex. What changes I need to make for that?

@AprilDunnam

3 жыл бұрын

Hey Prasad - I think this video should help with that :) kzread.info/dash/bejne/lKGa1paDdrqwmbw.html

@prasadathalye1243

3 жыл бұрын

@@AprilDunnam - You are really great and helpful. I second the first comment on that video.. 'This is EXACTLY what I needed to solve a problem I've been having!'... Thanks a million

Hi, how do i patch without combo box on the interface for column Person

🙏🙏🙏 thanks

@AprilDunnam

Жыл бұрын

You’re welcome 😊

Bro you are crack!! but I am stuck in a problem, I am using choices in a combo box since I have a look up field, the thing is that I want this combo box to be prepopulated with the last record in the sharepont list, I wrote this formula "Filter(Choices(SampleLog8kDef.Batch_ID);Id=Max(Id)" but then it returns in the combo box the first record not the last, I hope you can maybe help me thanks yougotthisyougotthisyougotthis

Hi April, after hours, I thought I'd found my solution with your excellent video! Alas, not so much! I am using a combo box that pulls the choices from a collection. Your suggestion works perfectly UNTIL I get to the ID part -- I'm putting in ID:cmboxCity.Selected. and it only gives me Title as a choice; not ID or any other fields. However, I can see ID in my collection. Any idea what I might be doing wrong? Thanks so much! Always love your work.

@AprilDunnam

3 жыл бұрын

Hey Cindy - I realize that this has been a couple months since you asked this. Sorry for the delay, I got behind :( What is your items property for your combobox set to? I wonder if it's set to a collection or something else that might not have a reference to the ID

Thank you for that Though it is more like an addition than a patch, where we would need to find the record we are updating using filter function.. Why not microsoft add function to simplify manipulation of those complex fields. It doesnt look like easy low code to business users.

@AprilDunnam

3 жыл бұрын

Hi Jeff - Patch isn't just an addition. The Patch function can handle both adding net new items to a data source AND handling changes/additions to an existing item

How can a I patch data with an image using the cámara control???

This was interesting. I have a question. If I have already selected a person in the Person field and then want to remove that selected person from the Person field and make it blank but I couldn't do it. It does not update the field with Blank value and retains the previously selected person. Any ideas?

@AprilDunnam

3 жыл бұрын

Hey there - this post on the power users community shows a method of passing a blank value to a person field: powerusers.microsoft.com/t5/Building-Power-Apps/Clear-people-picker-box-in-SharePoint-list/td-p/178204

hi great video... how to display and edit those complex columns from gallery can u plz upload?

@AprilDunnam

4 жыл бұрын

Thanks! Sure I'll add that to my list.

Hi April, I don’t think you need the odata type of you submit it like this: For choice fields: Patch( SharepointListName; Defaults(SharepointListName); {ChoiceFieldName:{Value:"NewValue"}} ) Lookup: Patch( SharepointListName; Defaults(SharepointListName); { LookUpField: { Id: 4; //ID of lookup column. Must be written with a small "d"! Value: "ChoosenValue" //Value can be left blank } } ) Person: Patch( SharepointListName; Defaults(SharepointListName); PersonFieldName: { Claims: Concatenate( "i:0#.f|membership|", User().Email // Person email ), Department: "", DisplayName: "", Email: User().Email, // Person email, can be blank JobTitle: "", Picture: "" } )

@AprilDunnam

4 жыл бұрын

Thanks for the tip!

This is a great video. I have it working except for patching with the person field. I cannot get the .Mail identifier to populate/be recognized. Only the .DisplayName is populating as a recognized identifier for some reason. Any idea what I am doing wrong?

@Bghdlot1027

3 жыл бұрын

Apparently the .DisplayName identifier works in the Claims: and Email: portions of the person filed. I thought I needed the .Email but so far so good with using it my way. Strange.

@AprilDunnam

3 жыл бұрын

Him that's odd, the .email should work. Either way glad you got it working

Any idea on how to submit to submit multiple rows from a collection to a lookup? I can get it to submit but the lookup publishes the first choice in the collection to every row.

@AprilDunnam

3 жыл бұрын

You'll need to leverage the ForAll() function to loop through the selected rows. For example: Patch( 'My List', Defaults('My List'), { Title:"PowerAppsTest", MulitChoiceLookupField:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value}) } )

@bjwkp13

3 жыл бұрын

@@AprilDunnam so I should clarify, I'm using a dropdown not multiselect, its simpler for my needs. In the collection there could be 3 rows of data and when I patch it to sharepoint the lookup defaults always to whatever the choice is in row 1. My belief is that this is a syntax issue and just cant figure out the syntax. Here is my code for reference: ForAll( OppCollection, If( !IsBlank(NetwProgName), Patch( 'Proposal Opportunity Tracker', Defaults('Proposal Opportunity Tracker'), { 'FXN Network Program Name': { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: NetwProgName2.Selected.ID, Value: NetwProgName2.Selected.Title }

Hi April, I have a list in sharepoint which record temperature every 30 min, how do I find the temperature difference, between the lastest and last reading on powerapps? .in sharepoint it doesn't allow as the data is listed in rows. thank you

@AprilDunnam

3 жыл бұрын

So there are a few different ways to do this. I'm not sure how you are wanting this to surface up in the app. But one way that I would do it is to do a filter query to get the top 2 most recent temp readings for the current logged in user. So assuming that in your SP List you are using the Title field to store the email of the user and another number field called Temperature, I would add a Label with the following formula to do the difference calculation: First(FirstN(SortByColumns(Filter(Temperatures,Title = User().Email),"Created",Descending),2)).Temperature - Last(FirstN(SortByColumns(Filter(Temperatures,Title = User().Email),"Created",Descending),2)).Temperature Hope that helps

@silverwhite11

3 жыл бұрын

@@AprilDunnam thank you so much April will try it out

How do I pull the person's name from my organization's sharepoint list?

I got a lookup column and the user selects multiple items. Then I save it to the collection. Then on a final screen, I got a submit button, I patch the collection to the Sharepoint list. But for the lookup column, I am getting errors. I am trying Metadata(SP):{Value: metadata(collection).Value, Id: metadata(collection).Id}

@AprilDunnam

3 жыл бұрын

Hey there - You should be able to do this without a collection like so: Conditions: ForAll(MultiSelectDropdown.SelectedItems, { '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: ThisRecord.ID, Value: ThisRecord.Title })

@fasawan2477

3 жыл бұрын

Thanks April, it works like a charm

@AprilDunnam

3 жыл бұрын

@@fasawan2477 Great!

April, how do you pass a blank person in a Person field?

@AprilDunnam

3 жыл бұрын

Hey there - this post on the power users community shows a method of passing a blank value to a person field: powerusers.microsoft.com/t5/Building-Power-Apps/Clear-people-picker-box-in-SharePoint-list/td-p/178204

Hi April, how do i patch an existing record (not new)

@AprilDunnam

4 жыл бұрын

Yes, you certainly can. Just one small tweak needed. Instead of using Defaults(Your data source), you need to put in a Lookup to your data source of some kind. For example: Patch(MyDataSource, Lookup(MyDataSource, ID = ThisItem.ID), {Title: TItle, etc})

@munfordable

4 жыл бұрын

@@AprilDunnam amazing! and thanks! what if there was several items with the same lookup value ie looking up with non unique value and i wanted to patch all of them

The more I learn about Power Apps, the more I miss InfoPath 😒

@AprilDunnam

3 жыл бұрын

😢