Announcements
So I have a list in SP online I have decided to customise the form in PowerApps. In the one form I am connected to 2 separate SP Lists. I have some fields from list A and some fields from list B on the one form. What i want to do is when the user clicks the submit button on the form ALL the data from ALL fields all get submitted to List A.
hey @Gskinner76
what is the difference between he 2 lists? are there the same columns in both lists? Do you want to use the Patch or Submitform function?
thanks for giving details
Hi The fields in list B do not exist in List A. In List B I only have 2 fields Category and Sub Category which are used as drop downs in the form and are cascaded. Hope this helps
Also I currentyl have a button configured to just submit the fields from list a into list A. I have never used the patch function but happy to be directed that way if it is the best or simplest way
and into which column do you want to save these values in the other list?
i have created 2 columns as single line of text called category and sub category in list A for the values to be submitted to
the only way i see is that you use the patch function. for these 2 single line of text column just reference the dropdowns you have from list b
As an update so i have used the patch function to submit the fields from List A into List A as shown below. But how would i code the patch function to get the value in the fields from list B on the form and submit them into fields in List A
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 421
WarrenBelz 345 Most Valuable Professional
Kalathiya 278 Super User 2026 Season 1
