Get a list item's version on a specific date

(0) Share

Report

Posted on by rayray1

Hi All,

I would like to build a list with keywords in it that I can use to monitor trending keywords over the last 7 days.

I have a report list:

Report Keyword (lookup column from keywords list)

report 1 Bus

report 2 Car, Scooter

report 3 bike, car

report 4 scooter, car

And a keywords list

Title Counter

Bike 1

Car 3

Scooter 2

Bus 1

Every time a user adds an item to the report list, they select keywords from the lookup column for the the keyword list.

When the report is submitted, a flow increments a counter in a column on the keyword list by 1 to make a change to the item and create a new version..

I thought a good way to identify a trending topic would be to get the version number of the keyword list item and compare it to the version number 7 days ago. If the version was set to "19.0" 7 days ago and it's "23.0" now, then I know that 4 version changes have occurred and the keyword has been used 4 times.

Then I can sort the list by whatever has changed most in the last 7 days and users can easily see what's "trending".

But.... I don't know how to get a list item's version on a specific date. Is it possible?

Thanks,

Ray

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @rayray1 ,

Yes. You can try to use date to get version number with action 'get changes for an item or a file'.

Best Regards,

Wearsky

Was this reply helpful? Yes No
rayray1 18 on at

Like (0)

Report
Copy link

Link copied!

Yes! That's got it.

Thanks so much Wearsky!

I used the formatDateTime as you mentioned:

I output to one messy variable, rather than the two nice ones you mentioned, but essentially, I am just updating a variable with version until - version since and converting to a float:

Then updating a column in my list called Version change with my variable

Which gives a number.

If I run this daily across the list, I can get a trend for the last x days, then sort according to the version change number.

Thanks, again 🙂

Was this reply helpful? Yes No