cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshcleme
New Member

Update a column by using recently modified cells

Hello!

 

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. 

 

Any ideas?

 

ex. 

 

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

 

4 REPLIES 4
jinivthakkar
Dual Super User
Dual Super User

@joshcleme please check this out, try trigger condition

 

https://www.youtube.com/watch?v=tlS6pSAx-GY

 

--------------------------------------------------------------------------------

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.

joshcleme
New Member

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.

jinivthakkar
Dual Super User
Dual Super User

@joshcleme it shouldn't happen, just try a poc with a dummy list and then try implementing it in your main list/data source.

joshcleme
New Member

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? 

Helpful resources

Announcements
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 tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,150)