Save data from one list in another

(0) Share

Report

Posted on by Spawn10

330

I have two SharePoint lists (A & B). List A holds some data that users enter into the list. List B is displayed on the gallery of my app, which has a button. When a user clicks on this button, I want to update the last entry the user created in List A, with some data from the columns in List B.

First I am trying to identify the last entry the user made into list A. For that I am doing something like this...

Lookup(Sort('list A', ID, SortOrder.Descending), 'Modified By'.Email = User().Email).ID

so far, I think that is doing what it should. If there is a better way to identify that item, I am open to learning.

Now I am trying to figure out how to update that item with the data from list B. I don't know of a where clause or how to construct the where syntax. So far, my inaccurate patch looks like...

Patch('list A', {Column1: ThisItem.col1, Column2:col2})

How do I accomplish this? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Spawn10
According to your description, you are using the code to find the user's last item in List A:
Lookup(Sort('list A', ID, SortOrder.Descending), 'Modified By'.Email = User().Email)

And you want to update this item in List A , you can use this in Patch:
Patch( 'list A' , Lookup(Sort('list A', ID, SortOrder.Descending), 'Modified By'.Email = User().Email) , {Column1: Updated Value1, Column2:Updated Value2})

The second parameter in Patch() function is the record you want to update in your data source.

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No