Hi @Willo,
Do you want to send a notification when a user has inserted a new row in the list in the last 48 hours?
I have made the following test, please check it for a reference.
For testing, add a Manual button trigger. You may consider adding a Recurrence trigger so that the flow could run per day or on other frequency.
Get items from the list, insert the following code in the Filter query field:
Created ge ‘formatdatetime(addHours(utcNow(),-48),'yyyy-MM-ddTHH:mm:ssZ')’
Note: Please surround the function part with a single quote in the filter query field.
Add the action to send a push notification.
Please try it on your side and feel free post back if you need more help.
Best regards,
Mabel
Hi @Willo,
Thanks for updating.
Do you want to send a notification when there is no action to the list within last 48 hours?
Here is another flow for your reference.
It is triggered by a button, just feel free change it to any other triggers against your scenario, such as a Recurrence.
Get items from the list. Still input the code I provided previously to filter out items that were created within the last 48 hours.
Created ge ‘formatdatetime(addHours(utcNow(),-48),'yyyy-MM-ddTHH:mm:ssZ')’
Add a Compose action with the following code to check if the return value of Get rows is null or not.
if(empty(body('Get_items')?['value']),true,false)
Add a condition to check if the Compose output is True or False with this function:
@equals(outputs('Compose'), bool('true'))
Under If YES branch, send a mobile notification.
Please take a try with it.
Best regards,
Mabel
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
23 |
User | Count |
---|---|
61 | |
46 | |
43 | |
30 | |
28 |