cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Patching Data 2 lists

Hi there,

 

I'm trying to follow the awesome repeating tables youtube by Shane Young https://www.youtube.com/watch?v=xgznk4XlPCo, but i'm having a problem getting the information from List called Change Management Master (which is populated through patching data from  DetailsForm) into List2 called Change Management Risk Assessment.  I've reviewed this solution  https://powerusers.microsoft.com/t5/Building-Power-Apps/PATCH-function-with-2-lists/m-p/190834#M6227...

but can't seem to get it to work (see attached for current formula).

I've also tried to patch to the second list on the original submission of the DetailsForm (see formula attached) 

Can anyone help me with what i'm doing wrong?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi Phoebe,

 

I've tried to explain my problem a bit better in this question

https://powerusers.microsoft.com/t5/Building-Power-Apps/Two-collections-linked-SP-Lists-Repeating-Ro...

 

Can you help??

View solution in original post

7 REPLIES 7
Highlighted
Community Support
Community Support

Hi @Cym ,

Do you want to update 'Change Management Risk Assessment' from data in 'Change Management Master'?
Based on your description that, you want to get data in DetailsForm that display the data of 'Change Management Master'.

Please notice that "form.LastSubmit" is used for edit form, which means that the last record that is submitted by the form.

However, detailform is not used to submit data, which does not have this property "LastSubmit".

Could you tell me the item of the detailform?

I suggest you use the item of the datailform to represent the item of 'Change Management Master' instead of "detailform.LastSubmit".

If you still have problem, please describe more clearly about the data that you want.

If you could show me two lists' details , it will be better.

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi there,

 

I'm not sure you have quite understood my question. After i collect data in a edit form and  submit it to  a list called ''Change Management Master'i want some of that data to also be submitted to another list called 'Change Management Risk Assessment' After that, i want to update data in the change 'Change Management Risk Assessment' list with additional data from a collection.  Hope that clarifies?

 

Thanks for your help

 

C

Highlighted

oops, forgot to add screenshot of the two lists, please see attacheed

Highlighted

Hi Phoebe,

 

I've tried to explain my problem a bit better in this question

https://powerusers.microsoft.com/t5/Building-Power-Apps/Two-collections-linked-SP-Lists-Repeating-Ro...

 

Can you help??

View solution in original post

Highlighted

Hi @Cym ,

Ok.

I've answered in your new post.

Please firstly mark my answer as solution in this post.

Then let us discuss in that new post.

Thanks!

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi

thanks for your help, but i've solved it with the help in this post:

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Why-does-this-formula-not-update-the-SP-list...

 

The variables were the key - made it super easy.

Highlighted

Hi @Cym ,

Since your problem has been solved, could you change your issue's status to "Answered"?

Thanks!

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,346)