web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Run report to find cha...
Power Automate
Unanswered

Run report to find changes in entire table in past month / Capture audit log

(0) ShareShare
ReportReport
Posted on by 232
Hi all,

 

Is there a way to run a report or flow to find which columns have been changed in a certain time period? 

At the moment our data is on a spreadsheet and people manually highlight cells when they change them.

 

I need to find a way the columns have changed in one of my tables. Is there a report i can create to give me all of the columns and records that have changed in the last month?

Categories:
I have the same question (0)
  • Unknown geen idee Profile Picture
    1,757 on at

    Dear MD7,

     

    If you have a sharepoint list as a basis, there is a trigger 'When item is changed' ... which could help you trigger a flow and record any changes.

     

    Alternatively and if you do not have a sharepoint list as a basis, I would run a scheduled flow (maybe every hour or so) which does the following:

    1. List rows in table (of the latest file) - to get the details in the table.
    2. List rows in table (of the previous file ... view last action) - to get the details from the last saved file.
    3. Compare the 2 arrays and note the differences in a logbook (date, change, ...etc).
    4. Save a copy of the current file in a file 'PreviousFile' to use as comparison for the next time.

    The logfile will give you an overview of all the changes over time.

    Alternatively you can always manually review the changes in the 'previous versions' details, assuming your file is saved in a OneDrive/Sharepoint environment.

     

    Hope it helps,

    Happy flowing,

    Koen

     

  • md7 Profile Picture
    232 on at

    hi there,

    Thanks for your reply.

    My data is in dataverse but i presume the steps are fairly the same? 

  • Unknown geen idee Profile Picture
    1,757 on at

    Yes, the dataverse might even give you better options ... if there is a field/data which says something about the modified date. Then you will know that a change has occured. Some D365 data I use has this field included.

     

    Happy flowing,

    Koen

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard