Push notification from SharePoint

[Willo]

Hello.

I'm looking to create a push notification that looks at a SharePoint list to see if a user has inserted a new row in the last 48 hours. I don't even know where to start on this one. The list will have the office 365 user ID and the created date.

Any help is appreciated!

[v-yamao-msft]

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

[Willo]

Thank you for the details! For my flow, I'm looking to see if there is away for it to review the list and see if there are any new rows added in the last 48 hours. If not send a notification that there has been no activity to the users of the list that should have entered information in the last 48 hours

[v-yamao-msft]

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