Checking value of specific character in form response -- Possible?

[WO1]

All,

Looking for some guidance on the best way to accomplish a request if it is possible, maybe I'm making it too complicated. 

Scenario: We have employees that drive vehicles every day as part of their job function. At the beginning of their shift employees fill out a O365 form with their vehicle ID, mileage, and essentially just indicate there is no damage on the vehicle or add comments if there is damage. What I would like to do is set up a flow that sends e-mail reminders to a specific person whenever 5,000 miles have elapsed to notify them that a specific vehicle requires routine maintenance.

Initially I thought about checking if a number is divisible by the maintenance interval, but that would only work if they filled out the form when the vehicle hits exactly a 5,000 mile increment. I also thought about using a contains to accomplish this with wildcards such as when milage contains 5*** but that doesn't seem to work.

Does anyone have any suggestions on how to accomplish this?

[ChristianAbata]

hi @WO1  what I suggest you is create a sharepoint list to save in a column the 5,000 miles data. Then create another flow schedule that reviews svery day your data and if is equals to 5,000 miles then notify.

like this

[WO1]

Thank you for the suggestion. I thought about doing that, however the challenge in that is that it would only trigger if the vehicle mileage is at exactly a multiple of 5,000 when entered correct? So if the mileage was 5,001 or 15,1012 then the trigger would not fire. Is that correct?

[ChristianAbata]

mmm no friend @WO1  what you need to contition trigger please follow this article

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-...