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

(0) Share

Report

Posted on by Albertax

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:

Run query against data set
Start an array variable
Parse Json and store data against my variable
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?

All responses (2)

Answers (1)

Albertax 111 on at

Like (0)

Report

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

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?
Verified answer

ScottShearer 25,208 Most Valuable Professional on at

Like (1)

Report

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

@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?