SharePoint 2013 LIst Filters (by latest date)
I am trying to sort a list by the latest date before a predefined date. I need it to also sort on 2 other columns. Basically I need the last date entered before [Date] for each drop down choice Drop down Column 2 Date End Date - (latest record after a date) I found a few things online but I'm not sure where I would add this or what the best plan of attack would be. Filter(ListName,Date=First(Sort(Distinct(ListName,Date),Result,Descending)).Result) Any help or direction is greatly appreciated.
Adding a comment to a DevOps Work Item using a given user
Second time writing this, as when trying to post the first time it gave me an error "invalid html" and discarded all my content -.- In Flow, I am using a DevOps - Update Work Item action, that updates a work item and adds a comment to it, using the Other Field "history" as the content of the comment. The problem is that the author is set to be the owner of the connection that the action is using, yet since the flow is triggering using an email, the author needs to be set dynamically using the email's author (provided he has an account in DevOps). How can I do this? Is there another name in "other fields" section, perhaps something like "Author" that I can use to set the author of the comment given the name, email or id from the email that started the flow? Screenshot:
