I have a Sharepoint list that has columns of years where paperwork was completed on a date within that year, I want to have another column called Last Filled that is triggered on a modification of one of the years' columns and populate it with that modified value for the row.
Paperwork name | 2019 | 2020 | 2021 | 2022 | Last Filed
Income Taxes | 4/2/19| | | | 4/2/19
Paperwork X | 9/5/19| 9/1/20 | | | 9/1/20
I appreciate all the help
@joshcleme please check this out, try trigger condition
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
In theory that route worked (kind of).
The issue is, when the power automate flow is added it over-rides all of the past rows. So say the year is 2022 and you fill out one cell, it will delete all the other cells in the "Last Filed" column for an odd reason.
Hey @jinivthakkar ,
I did that, it still causes the complete change in the whole column. Any other methods you have to share? Is there something with modify/update that saves the cells that was changed and it's ID so that then it can be change the same row and single cell instead of causing a push of all cells?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.