push notification on sharepoint list

(0) Share

Report

Posted on by diegomarino

128

Hi, i looked for something similar but nothing found.

i have a sharepoint list that i use as calendare, i have a date column and a start time column, i'd like to get a push notification before a certain amount of time specified in another colummn called "notify"

i was building the flow but i cannot figure out how to start the notification at due date-time

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report
Hello @diegomarino

You should do something like this:

1) Recurrence trigger (every day).

2) Get SharePoint items

3) If Start Time - Notify is less than today

4) Then send the notification.

The expression used to get the start dates less notify is:

addDays(items('apply_to_each')?['StartDate'],sub(items('apply_to_each')?['Notify'],-1))

Hope it helps!
Ferran

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

Thanks for the answer, does It send the notification at the time i set?

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Yes!

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report
thanks seems nice but i'm building it, i have a couple of questions:

1) my dates are european, i think i have to use CET instead of UTC, right?
2)
addDays(items('apply_to_each')?['StartDate'],sub(items('apply_to_each')?['Notify'],-1))
this code is not familiar to me, can you explain a little bit or tell me where to find some info?
3) the "startDate" in your formula is a date time right? i have to make a new column to join my date and my time columns that are different. My date column has the following format "GG/MM/YYYY", in the new calculated column i have to use some format funciont to make the format like "YYYY-mm-dd hh-mm"?

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Hello @diegomarino

Answering your questions:

1) You have to use UTC and convert those times to your time zone. For example:

convertFromUtc(utcNow(),'Romance Standard Time')

Convert the current date time to UTC +1. You can look at different time zones here: Time Zone IDs (Compact 2013) | Microsoft Docs

2) This formula gets the StartDate Sharepoint column value, and substracts the number of days stored in the Notify column. As the notify column is a positive number, and we are using "AddDays", I convert it to a negative one using the multiply function (mul) by -1.

3) I don't understand your question. When you say "i have to make a new column to join my date and my time columns that are different", what do you mean? A new column in SharePoint? In any case, in Power Automate you can always use the expression:

formatDateTime('your_date_time_colum_yyyy-MM-dd,'format_needed')

Hope it helps!

Ferran

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

thanks
i was speaking about the structure of my sharepoint list, those are the columns involved.

1) StartDate (only date like 12/01/2021) 2) StartTime (only time like 17:30)

the notification should start in the specified day at the hour and minute in the startTime column, date and time are in two different columns

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

hi, sorry for necroposting but after a long time i want to finish this stuff

this is my updated flow.
i want at 00:00 of every day that the flow iterate in "calendario" sharepoint list every "data inizio" (start date) equals to today (in the sample here you see tomorrow just for testing)
"data inizio" could be blank, so i put that test

at the current build i get the error:
Non è possibile elaborare le espressioni del linguaggio del modello per l'azione 'Condizione' alla riga '1' e alla colonna '12713': 'Nella funzione 'adddays' il valore specificato per la stringa data/ora 'YYYY-04-DD' non è valido. La stringa data/ora deve essere conforme al formato ISO 8601.'.

could you fix that? then i'll build the few other steps.
thanks

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Hi @diegomarino

It seems there's an error on the addDays function. I've done a test on my side with the following expression and it works:

addDays(formatDateTime(convertFromUtc(utcNow(),'W. Europe Standard Time'),'yyyy-MM-dd'),1)

Could you try it?

Regards,
Ferran

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

thanks very much for the answer.
i'm able to code in vba but i just figured out that i'm totally ignorant of flows, so i bought a book.
i read the book first, then i'll continue the development of this flow

Was this reply helpful? Yes No