I am trying to achieve a small requirement, where in I have a text column which stores the comments of users.
The comment column contains : Timestamp User name and comment and there can be multiple comments in that text field added by different users.
So, i want to extract the latest comment timestamp and check whether that timestamp is older than a week.
How can i achieve this condition.
My data source is SharePoint.
Thank you in advance!
Hi @Jayant2 :
Please try this code:
Last(Sort(AddColumns(Split( "RV - 13/01/2021 10:26 - Comments. JM - 14/01/2021 15:43 - ", Char(13) ),"Thedate",DateValue(Match(Result,"\d\d\/\d\d\/\d\d\d\d").FullMatch,"bg-BG")),Thedate,Ascending)).Thedate
@v-bofeng-msft i was able to extract the last comment based upon the below formula, how do i extract the last date column as it is in the middle and not at first or last. First and last value are easily retrieved by First and last function. I use the separator as "-" and not char(13)
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks