Announcements
i have two identical sharepoint list ,all the columns are same . i want to submit the edit form to these independent sharepoint list simultaneously. what can be changed in the on select of the submit button so that it submits the edit form simultaneously to the both of these sharepoint list
As far as I know the edit form is tied to the one data source.You could patch the data to the other list right after the submit form in the onselect, but you would have map the columns and values in the patch.
can you give me an example code snippet on that,both the lists have exactly the same coloumns anly the name is different
OnSelect=SubmitForm(Form1);
Patch(2nd list, Defaults(2nd list),{Title:data card value.Text, 2ndColumnName:data card value, etc})
if there is like fourty coloums in the second sheet i have to do for all the coloums and match it with the data card
Wait on that. Try this firstInstead, after submitform
Refresh(1stlist);
Patch(2nd list, 1st list)
use this Patch instead
Patch( list2, ForAll( Sequence(CountRows(list1)), Defaults(list2) ), list1 );
its returnig error shared a photo with this
@tmpandc ,
I have tried about everything with no luck on total simplification.
This is as easy I can find to do it. Map column to column instead of column to datacard.
Patch(List2,Defaults(List2),{Where:Last(List1).Where,Glcode:Last(List1).Glcode})
Using last only patches over the last entry from the first list.
I hope this helps.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 377 Most Valuable Professional
11manish 165 Super User 2026 Season 2
MS.Ragavendar 110 Super User 2026 Season 2
