I'm new to PowerApps and trying to achieve a solution for the following Problem: I have a Text field where the user will Provide Regions in the the following formats(either 1, 2 or 3). I have a collection(EmployeeCollection) which I'm looping through  to feed different employee Details each having Employeename,Project Priority, Region in Employee Details list. Aug 20, 2020 PowerApp Patch Multiple fields, PowerApps Patch update SharePoint List, PowerAPPS SUBMIT FORMS TO sharepoint list, Powerapps update field value, PowerApps update Multiple Lists. Each row in 'table' must have at least a value for the primary key of 'datasource' -- that's how Patch will find the records in 'datasource' that need to be patched. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Features releasing from October 2020 through March 2021, Check out the Power Platform Community Highlights. I've got a browser screen which shows a bunch of numbers, and I … I have made a test on my side, please take a try with the following workaround: Set the OnSelect property of the "New Item" button (it is "Save" button) to following formula: On your side, you should type the following formula: Note: Please add the Title property (Title column, which is a required column) within your formula. New to the Powerapps thing and trying to figure out how to patch information to a sharepoint data source without saving. Post back if you have any further quesitons. Basically the patch() fucntion should be used as a behavior formula, which means the user initiates a sequence of actions, or behaviors, that will change the state of the app: Understand behavior formulas in PowerApps. ChecklistItemsSource and the CheckedItems collections, have the same column names. But I'd like to be able to save that information to my data source. "B_id" is a unique identifier. Using Patch: If your Source and Destination have the same column names, you can use a simple Patch … Patch('Employee Details', Defaults('Employee Details'), {, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:1,Value:InputRegion.Text}. inside the ForAll function of Submit button.Also let me know whether I should create the Region table anywhere else or any workaround.Kindly look below for codes. Using Patch: If your Source and Destination have the same column names, you can use a simple Patch statement. However, I don't want them to need to go and individually modify every card. PowerApps Patch Function Syntax ForAll(EmployeeCollection, If(!IsBlank(EmployeeNameItem). I’ve also provided details on creating multiple records at once. I think there is something wrong with the formula that you provided. Patch(test, Defaults('test'), { ReasonforLateSubmission: Stack ... Save data from multiple screens to submit using powerApps. Clear(Collection1);Clear(RegionTable);ForAll(Split(ProjectRegion,","),Collect(Collection1,{Iterator:CountRows(Collection1),Value:Result}));ForAll(Collection1,Collect(RegionTable,{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id: Iterator,Value: Value})); Patch('Employee Details', Defaults('Employee Details'), {Title:EmployeeNameItem,Priority:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:1,Value:ProjectPriority},Region:RegionTable,MID:Form1.LastSubmit.ID }))); I have made a test and the issue is confirmed on my side. Here's the full story. Here's one way: Patch(datasource, table) The second parameter specifies a table of records to push into 'datasource'. 1. Patch(testmanies,First(testmanies),{'ExpenseStatus ':ComboBox1.Selected.Value}) Then, click the submit button,you could update option set field. Hello SharePointers, Today we are going to see some development hacks, we will see How To Save Records In Multiple List Using Power Apps Patch() function. When the user clicks Done in the above scenario, we need to update ChecklistItemsSource with changes from CheckedItems collection. Stay up tp date on the latest blogs and activities in the community News & Announcements. I'm saving the text data in EmployeeCollection as Project Region each time after hitting a Save button and when we finally hit Submit button we patch it to Employee Details list.All is working but I'm unable to put, inside the ForAll function of Submit button.Also let me know whether I should create the Region table anywhere else or any workaround.Kindly look below for codes, Save Button (hitting multiple times to save new data in EmployeeCollection), Patch(EmployeeCollection, ThisItem, {EmployeeNameItem:inputname.Text,ProjectPriority:Radio1.Selected.Value,ProjectRegion:Textinput1.Text});Collect(EmployeeCollection,{EmployeeNameItem:"",ProjectRegion:"",ProjectPriority:"",}), Submit Button(Hitting one final time to save data from EmployeeCollection to Employee Details). Check out the on demand sessions that are available now! How to patch a text field to a multi select choice... Power Platform Integration - Better Together! As for 2nd entry if region is GLOBAL,ASPAC in list I can find EMEA,NA, EMEA,NA,GLOBAL,ASPAC. Do you want to save each region within the Text field into the Multiple Choice type column in your SP list? As an alternative solution, you could consider take a try to put them outside the ForAll function. Power Platform and Dynamics 365 Integrations, Power Apps Community Demo Extravaganza 2020, Business Value Webinars and Video Gallery, 2019 Microsoft Business Applications Summit Recordings (Archived), Microsoft Business Applications Summit 2020 Session Recordings.