
Announcements
Hi,
Im new to flow,
Ive got a few column on another list in sharepoint that users type in the amount of kilometres on the clock when they finish for the day,
I need that number to be updated daily to another column
and i also need that number to alert management when its due for a service? ie number reaches 5000 or similar.
Hi @Anonymous ,
In the images below you'll see each of these steps. This is a simple flow which sends one email for each vehicle requiring servicing. If you were to have a column in your list for the date management was informed you could then do amend the condition to say that if the CopyToColumn is greater than 5000 AND MgmntInformed is equal to null then send the email, otherwise don't - in otherwords the email has already been sent on an earlier date so don't send it again.
A more advanced flow would be to add an array variable to get the vehicles and km, add them to a table and then send just one email. But I'm having trouble getting the result to look good at the moment so I hope the simpler flow will get you someway to what you want.
Rob
Los Gallardos
1 - Recurrence Schedule and Get Items
2 - Apply to each
3 - Condition and Email
4 - Email result