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 / Check to see if column...
Power Automate
Answered

Check to see if column has changed in yesterday's data

(0) ShareShare
ReportReport
Posted on by 111

Hi Team,

 

I have a flow that updates daily, getting around 500 rows of data from the previous three months. I need to check to see if two columns have had any changes since the initial flow run (which imports my data).

 

My current flow is setup like this:

  1. Run query against data set
  2. Start an array variable 
  3. Parse Json and store data against my variable 
  4. Apply to each
    1. Get items 
    2. Check length of items 
    3. If item is length is not 0 > then create
    4. Otherwise update

Now i am at a loss, if i need a second Flow to run after this has been successful to check for specific text changes

 

Original flow imports data 

Second flow will check to see if anything has changed and update each item with the Original text and then on a second column changes 

 

Any ideas on how I would implement this? 

 

 

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @Albertax 

    Where is your data stored?  If in SharePoint, you can use a Get changes for an item or file action and specify a start date for the changes.

    Is the data in SharePoint?

     

  • Albertax Profile Picture
    111 on at

    Hi Scott,

     

    Thanks for your response - greatly appreciated. I will do some testing and see how i get on with get items for changes. Would you build this as a separate flow?  

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 573

#2
Valantis Profile Picture

Valantis 407

#3
11manish Profile Picture

11manish 387

Last 30 days Overall leaderboard