cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phuba
Regular Visitor

Replicating items in SharePoint Lists (without listing all columns)

We have a list named "Records" and another one with the exact same definition named "Archived Records". A Power Automate flow runs every night and finds the Records items eligible for archiving (i.e., to be moved to "Archived Records"). The logic is

(a) Get archiving-eligible items and for each

(b) get item from "Records"

(c) create (replica) item in "Archived Records"

(d) delete original item from "Records"

In (c), the "Create item" action forces us to specify the value of each individual column of the list, values obtained from (b).
If it happens that a new column is added to both "Records" and "Archived Records", we are obliged to modify the Power Automate flow to include that new column if we want to keep the logic.

Is there a way to create an item based on data obtained from get item action, without the need to list all values?

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @phuba ,

 

It is possible to do this using sharepoint rest api. But it is not as simple as the 'create an item' action.

vxiaochenmsft_0-1640834948194.png

vxiaochenmsft_1-1640834973299.png

vxiaochenmsft_2-1640834985992.png

 

_api/web/lists/GetByTitle('your list name')/items()

 

Best Regards,

Wearsky

 

 

 

 

 

Thanks @v-xiaochen-msft, REST API calls would be fine for me. 

However, it does not solve the issue - our objective is to minimize maintenance.

if a column is added (to both "Records" and "Archived Records) we would have to modify the Power Automate flow anyway. Therefore, REST API calls or "Get item" / "Create item" actions, make no difference - in both cases, the PA flow would have to be update which we would like to avoid.

v-xiaochen-msft
Community Support
Community Support

Hi @phuba ,

 

Unfortunately this is impossible.

 

Best Regards,

Wearsky

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,583)