web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / push notification on s...
Power Automate
Unanswered

push notification on sharepoint list

(0) ShareShare
ReportReport
Posted on by 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

 

Cattura.PNG

Categories:
I have the same question (0)
  • fchopo Profile Picture
    8,003 Moderator on at

    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.

    lessthan.png

     

    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

     

  • diegomarino Profile Picture
    128 on at

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

     

  • fchopo Profile Picture
    8,003 Moderator on at

    Yes!

  • diegomarino Profile Picture
    128 on at

    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"? 

  • fchopo Profile Picture
    8,003 Moderator on at

    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

     

  • diegomarino Profile Picture
    128 on at

    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

  • diegomarino Profile Picture
    128 on at

    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

     

    Cattura.PNGCattura1.PNGCattura2.PNG

  • fchopo Profile Picture
    8,003 Moderator on at

    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

  • diegomarino Profile Picture
    128 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard