Now that we can call stored procedures directly from Power Apps, who would be interested in a workshop on learning the basics of what they are all about, but also how to create them?

Last Saturday, I mentioned that this week we would cover planning & design for Power Apps projects. It turns out there wasn't as much interest in that as I thought. I'm looking for ideas from you guys again! 😂😭🙏🙏 https://www.skool.com/power-apps-community/power-apps-workshops

I am trying to Patch a Sharepoint "Person or Group" column with Office365 Users from Combo Box. The Combo Box "Items" code is as follows and works to search Users from the Office 365 connector: Filter(Office365Users.SearchUserV2( { searchTerm:Trim(Self.SearchText), isSearchTermRequired:false } ).value,AccountEnabled=Not("#EXT" in UserPrincipalName )) DefaultSelectedItems = It is blank My Patch function is as follows but does not work. Specifically the Combo box is causing the error: Patch('Front Desk Messages', Defaults('Front Desk Messages'), { Title:txt_ContactName.Text, 'OSARC Contact':cmb_OSARC.Selected.DisplayName, 'Contact Date':Date_Contact.SelectedDate, 'Contact Time':txt_ContactTime.Text, 'Contact Phone No':txt_ContactNumber.Text, 'Contact Email':txt_ContactEmail.Text, 'Contact Message':txt_ContactMessage.Text } ); Reset(txt_ContactName); Reset(cmb_OSARC); Reset(Date_Contact); Reset(txt_ContactTime); Reset(txt_ContactNumber); Reset(txt_ContactEmail); Reset(txt_ContactMessage)

I am trying to use a Combo Box and it is not displaying the "DefaultSelectedItems" data as desire. Here is a summary: 1) The Combo box "Items" are coming from the "Planning" table. 2) Prior to getting to this screen, the Project number was selected from the "gal_Contracts" in which the Project is selected. 3) The Combo box needs to display the "Business Name" from the "Contacts" table. 4) There are 3 SQL tables used here: "Planning", "ContractsGeneral", and "Contacts" 5) The contact for the "ContractsGeneral" is different than the contact for the "Planning" table. Hence, do not confuse the duplicative Contact_fk fields in both tables. That is just the way I keep up with foreign keys. As seen in the below screen shots, the foreign key is displayed from the GRAY box which is looking at the "ContractsGeneral" table. Hence, the foreign key data is there. This is the "Default" setting in the Gray box. LookUp(ContractsGeneral,gal_Contracts.Selected.pk_Projects=Projects_fk,Contact_fk) I tried this in the "DefaultSelectedItems" of the Combo Box and can see table records, but can retrieve the data I want to display. LookUp(ContractsGeneral,gal_Contracts.Selected.pk_Projects=Projects_fk) I tried this in the "DefaultSelectedItems" of the Combo Box and just gives me an error. LookUp(ContractsGeneral,gal_Contracts.Selected.pk_Projects=Projects_fk,Contact_fk) See screen shots to help.

I am wanting to patch to an SQL table using a lookup as the record. Here is a summary of the setup: 1) I have a primary SQL table called "Planning". This table contains basically a project number and primary key that is related to every screen in my PowerApp. 2) A user searches and selects the Project No from a gallery which sources the "Planning" SQL table. 3) Upon selected of the Project No., the user would navigate to a general screen for "Contracts" data, which is the "ContractsGeneral" SQL table. 4) On the "General" screen, the user can add a new record and is blank if there is no record for the Primary Key. Or if there is a record for the Project No's Primary Key, then just modify the data and hit save. 5) For the Patch function, using LOOKUP function for the record is not working. "Invalid argument type (Number). Expecting a Record value instead." Both columns in SQL are INT type. Here is my patch function and screen shots below: If(gblNewGeneralContract, Patch( ContractsGeneral, Defaults(ContractsGeneral), { Projects_fk:gal_Contracts.Selected.pk_Projects, Bids_Received:Date_BidsReceived.SelectedDate, Modified:Now(), Modified_By:User().FullName } );, Patch( ContractsGeneral, LookUp(ContractsGeneral,gal_Contracts.Selected.pk_Projects=Projects_fk,pk_ContractsGeneral), { Projects_fk:gal_Contracts.Selected.pk_Projects, Bids_Received:Date_BidsReceived.SelectedDate, Modified:Now(), Modified_By:User().FullName } ); ); Set(gblNewGeneralContract,false) 6) I was expecting this to work easy. I have several solutions that I could try but wanted to know if anyone has experience this. I could just create a gallery on this screen to select the record but didn't want to clutter up the screen.