cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WO1
Helper I
Helper I

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

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?

 

 

3 REPLIES 3
ChristianAbata
Super User II
Super User II

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

 

scheud.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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?

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-...



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (67,250)