
Announcements
Hello guys, I am trying to get the record of the most recent date from RTO Date column (Date type) on a SharePoint List.
is it possible? I am using the GET ITEMS step. Any help will be appreciated. I also wanted to get the date and make set it as a variable
Hi @nagestiada
To get the recent or newest date from SharePoint list using "Get items" action, you need to set the "Order by" & "Top count" parameter:
RTODate desc
You may collect the value from "Get items" output in compose action using an expression:
first(outputs('Get_items')?['body/value'])?['RTODate']
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks