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

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

Thanks Matt!!

You're so welcome!

Thanks Sudheer 😊

I'm so glad!

You're welcome - glad it was helpful!

Glad I could help!

Thanks Daniel!

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

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

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

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

Thank you! Cheers!

You are so welcome

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.

You're welcome!

Glad it was helpful!

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

You’re welcome 😊

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

Thanks for the tip!

Hey Prasad - I think this video should help with that :) kzfaq.info/get/bejne/mNOWp5d7q72umY0.html

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

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

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

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.

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

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

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

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

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

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

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

Thanks April, it works like a charm

@@fasawan2477 Great!

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

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

😢