Pulling data from 2 or more sharepoint lists

[Mod_admin]

Hi I am trying to update an entry in a form by choosing a record from another list.

So for example i have a Form1 on screen1 that is connected to sharepoint listA. In form1 there is a field abc. When user clicks on abc it directs to a new screen, i.e. screen2 which contain entries from sharepoint listB. When user selects any of the options on this screen2, it should be updated in abc field and user should be redirected back to screen1.

what function could i use for this?

[rlmckean]

Hi
One way is as follows
You don't say how you populate form 1. Let's say it is from selecting a record from gallery1
Place a > icon next to field ABC.. in form 1
In the onselect property of the icon add the code
Navigate(form2,fade).
Assume you want the value of field D in form 2 to update field ABC in form 1, where a label called label1 is bound to field D value
Add a button and rename it 'update'
In the onselect property of the update button add code
Patch(listA,first(filter(listA,ID=gallery1.selected.ID)),ABC=form2.label1.text);Navigate(form1,fade)
Hope this makes sense!!
Cheers
Richard

[Mod_admin]

In the form1 i am updating the records through user's inputs. So for example there are 4 fields and each requires input from user. Of these 4 fields one feild is ABC. When user selects abc he is taken to new screen where there are multiple options to choose from a gallery connected to the ListB. 

When i am trying to patch, it's not showing the filed ABC. in fact it is not showing any of the fields of ListA. So i m unable to execute the code ABC= form1.label1.text.

[rlmckean · Accepted solution]

Sorry!

Senior moment last night!

The correct syntax for the patch is 

Patch(listA,First(Filter(listA,ID=Gallery1.selected.ID,{ABC: Label1.text})

Note - the <Value> to patch after the colon needs to be exact as does the field name ABC.

As you are taking the value from a gallery2, then you would patch {ABC: gallery2.selected.<fieldname>} or

you could put the patch and navigate code into the onselect of the arrow on the gallery in which case the patch could be 

{ABC: thisitem.<fieldname>}

Sorry for earlier error !

Cheers

Richard

[Mod_admin]

Thanks Richard for the help.

[Anonymous]

How to patch data from powerapp to sharepoint list

Hello. I have two powerapps : shopping cart and parcel tracking 

shopping cart fields: parcelID, productname, deliverlocation, department, orderstatus

(+other fields too but not impt)

parcel tracking: parcelID, status

The data from the shopping cart form will be found in a sharepoint list called OrderList

The data from the parcel tracking form will be found in a sharepoint list called TrackList

May I know what should I do if I want to submit the data in parcel tracking form and update the order status using corresponding parcel id?

(for example parcelID is 123 in OrderList and TrackList and vendor just need to key in the delivery status and that once submitted will be shown in orderlist as respective orderstatus eg. 'Parcel out for delivery')

TrackList (Parcel tracking)

OrderList

OrderList (Shopping cart)

TrackList

Thank you!! Any help will be appreciated!