Notifications
Announcements
Hello Guys,
I need to export project wise latest record from SharePoint to excel sheet. I am trying to build a flow but not getting any idea.
Sample Data:
Project Date
A 01-01-2018
A 01-01-2019
A 01-01-2022
B 01-12-2018
B 01-06-2019
B 01-08-2021
C 01-01-2019
C 01-06-2020
C 01-12-2021
Expected Output:
please help me on this!
Thanks in advance!
Hi @HemanthV :
I've made a test for your reference:
1\My SP list:
2\My Flow:
The Result:
Best Regards,
Bof
This template also accomplishes a similar thing with less steps & no looping: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Distinct-Records/td-p/2191533
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 538 Super User 2025 Season 2
Tomac 405 Moderator
abm abm 252 Most Valuable Professional
