Modifying Workflow to Include Records Modified Yesterday and This Week

[Marouane1908]

My current workflow only updates records that were modified 2 weeks ago. I want to change this so that it also updates records modified yesterday and within this week. How can I achieve this?

[DJ_Jamba]

Hi @Marouane1908 
Assuming your flow currently uses a Get Items action to retrieve the required records and also assuming that by this comment "I want to change this so that it also updates records modified yesterday and within this week. How can I achieve this?", you want to make updates to modified records within the last 2 weeks
Use the following formula in the Odata Filter Query field of your Get Items action:

[Marouane1908]

Thank you @DJ_Jamba for your fast reply, actually i don't think you get what i want to do. So basically my flow is updating the records that are only 2 weeks older and i wanted to delete that. I couldn't find it on my settings page or the flow as well. 

here is a screenshot of the Get items action: 

Thanks 

[Marouane1908]

found this flow as well maybe this is why it isn't updating the new records for example from 1 or 2 days ago: 

 @DJ_Jamba 

[DJ_Jamba]

Hi @Marouane1908 
"So basically my flow is updating the records that are only 2 weeks older and i wanted to delete that"

If filter query is not being used in the get items action then your flow must be figuring out the range of records  to update after the Get Items action.

What comes after the Get items action?

[DJ_Jamba]

For this flow, what formula is inside the Since field?

[Marouane1908]

This is what it comes after get items action : Apply to each 

[Marouane1908]

@DJ_Jamba  

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)

[Marouane1908]

There was an 'action' to initialize a variable with this value @{startOfDay(addDays(utcNow(),-25))}, but I deleted it and run the flow, yet nothing has changed. Do you suggest that I delete the whole flow and start it again from the beginning?

[Marouane1908]

up

[srduval]

The status value in the condition step inside the apply to each, what does that contain/how is it calculated? I know certain calculations don't automatically refresh with sharepoint. For example (I know I have this problem, but this might not be the right example) I have a list with employees and their hire dates, and a calculated column that shows how many days they've been employed. however that days employed doesn't update everyday unless I trigger a recalculation (done via an API call, send HTTP to sharepoint action) after that refresh, I am able to query the list for people who've been employed for x days as of today. Not sure if that is your problem here or not.

[Marouane1908]

This is how it's calculated : 

          "@items('Apply_to_each')?['Status']?['Value']",

          "Updated"

so basically if the status is equals to Updated then the item should be created in the new list and then deleted from the current one.