How to change field data based on time passed?

[Wallyy]

Hello all, 

Currently I am trying to have something populate a gallery that filters based off of a status and a type.

(Filters so that it shows items that are not complete, and are of type recognition)

I want to have this status automatically update to "Complete" after 7 days or so, so it automatically gets taken off of the gallery but not deleted from Lists.

What is the best way of going about changing a Status Value from "In Progress" to "Complete" after  a timeframe? I am thinking to base it off of creation date, but I am not sure how I'd go about doing that. 

Any suggestions would be appreciated, thanks

[RusselThomas]

Hi @Wallyy ,

So if I understand correctly, nothing changes with the filter, just the data on the backend would be updated after seven days from creation, and therefore the filter will update the view based on the updated data.

You can refresh the source in PowerApps to get the latest data by using a timer, but updating the data based on a timestamp would require PowerApps to be running 24/7 - which may be a bit of a challenge depending on where you're running it from.

It sounds like this is something that would be better managed with Power Automate - you can schedule a daily (or hourly) check on the dataset and update the status of "In Progress" records whose created timestamp is equal to or older than 7 days, to "Complete".  This will run regardless of whether the PowerApp is running or not.

Depending on how often you run the flow and how often the app is run and restarted, you can also add a Refresh() button on your app to refresh the data source, or add a timer control to refresh - at least as often as the flow runs...

Kind regards,

RT

[Wallyy]

Hi @RusselThomas,

You are correct. I have a "status" column with a few different fields, two of which are "In progress" and "completed".

How would I go about doing this in PowerAutomate? I think I can manage to figure out how to do the checks but I am not sure how I actually link the data from sharepoint/Lists and use it.

[v-xiaochen-msft]

Hi @Wallyy ,

You can try to create a scheduled flow. The flow is automatically executed once a day.

It checks the created time of all items in the list. It automatically modifies the status value of these items if the current time is more than 7 days away from the creation time.

Created le '@{subtractFromTime(utcNow(),7,'Day')}'

Best Regards,

Wearsky

[Wallyy]

Hi @v-xiaochen-msft ,

Thanks! That is filtering all items created >7 days ago. How can I add another filter based on a TypeEvent Value?

For example I would only want to filter and update if the TypeEvent values are either Recognition or Safety. 

[v-xiaochen-msft]

Hi @Wallyy ,

You could try the filter array action.

@or(equals(item()?['Test_Status/Value'], 'Recognition'),equals(item()?['Test_Status/Value'], 'Safety'))

Best Regards,

Wearsky

[Wallyy]

Hi @v-xiaochen-msft ,

I tried this but I can't seem to figure out how to use the correct output.

Which should I choose for the output from previous steps? I haven't been able to pick one and it only update the items I am trying to specify. 

[v-xiaochen-msft · Accepted solution]

Hi @Wallyy ,

The dynamic content doesn't contain what you want. You could try the items() function in expression.

Best Regards,

Wearsky

[Wallyy]

Hello @v-xiaochen-msft ,

Thanks! I managed to get it working now. I appreciate the help with PowerAutomate.