Move Sharepoint list data to other Sharepoint list

[TimmyBoy]

Hello,

Is it possible to move a whole record from one sharepoint list to a other sharepoint list?

So yes, could you tell me how.

I try to use this

Patch(
                     Data_Pro,//ThisRecord,
                     LookUp(Data,'Id (ID)'=checkedout.'Id (ID)'), 
                     { 
                       USER:myUsername,
                       UPDATEDATE:Text(Now(), "[$-nl-NL]d-m-yyyy"),
                       ADDED:""
                       } 
                )
             ;

But seems it does nothing

Any support please

Thank you

[TimmyBoy]

Hello,

Okay i tried this part

          ForAll(
          UserBrowseGallery1_4.AllItems,
          Patch(
    Data_Pro,
    UserBrowseGallery1_4.AllItems
));

But then i get an error that said item not found

How can i patch this data from gallery into a sharepoints list

At once?

So it just creates all the records we have in the gallery

Update:

I also tried this

Patch(Data_Pro,
    ForAll(Filter(UserBrowseGallery1_4.AllItems) As _item,
        {'Id (ID)': _item.'Id (ID)'
        
        }
    )
);

But also given me an error 😞

[TimmyBoy]

Update:

I tried this and seems working

but no data

ForAll(UserBrowseGallery1_4.AllItems As _item, Patch(Data_Pro,Defaults(Data_Pro), {Id: _item.'Id (ID)'}))

I really don't get it 😞

What do we wrong??

[turnerj3]

I recommend starting by making a Collection of the Gallery first.

Collect(SampleCollection, UserBrowseGallery1_4.AllItems)

Put this on a button OnSelect event and run the button.

You can then click on the Collections tab in powerapps and see what populated in the SampleCollection.

Now, you can make sure you collected the data and what column ID is in.

Then, Patch the collection to the Sharepoint list.

ForAll(SampleCollection, Patch(Data_Pro, Defaults(Data_Pro),{Id: SampleCollectionItemIdColumnNameHere}));

[TimmyBoy]

Hi @turnerj3 

I tried, but get an error

field_13 seems to be Id field

ForAll(coldata, Patch(Data_Pro, Defaults(Data_Pro),{Id: coldata.'Id (ID)'})

And when i use this

ForAll(coldata, Patch(Data_Pro, Defaults(Data_Pro),{Id: 'Id (ID)'})

I get

So what do i wrong?

[turnerj3]

Send me a screenshot of your collection that was generated.

[TimmyBoy]

@turnerj3 

Here the part of the collection

[turnerj3]

Use Id: ID

[TimmyBoy]

Hi @turnerj3 ,

Yes that worked, but seems its not copying all the fields

Any idea how to get all the data?

[turnerj3]

Hi @TimmyBoy ,

   That’s great! So in your Patch code tell it all columns you want to Patch. Currently we only told it to Patch Id:ID. Match the other fields in DataPro to Coldata. {Id:ID, Title:Title, etc}