You’re offline. This is a read only version of the page.
I am a novice to power automate. How can I create a new item to my SharePoint list without re-entering all the values for each column, I can default the values for my new item from my most recent item in the list.
Hi @Grasswal
1. First you need to use Get Items, SharePoint Action
-Set the site and list
-Set the Order By to ID desc
-Set the Top Count to 1
this way it will give you the last record first
2. Create an Apply to Each Action
-Set the value/Input/From to the Dynamic Body/Value property of your Get Items. It will only have 1 so don't worry
3. Inside the Apply to each add a Create Item action for SharePoint
-Populate the Defaults, with the Dynamic Propertys inside the Apply to Each. It will have all the Column Names from SharePoint
4. Do Whatever else you want
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
All responses (
Answers (
53,963
