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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a annual meet...
Power Automate
Unanswered

Creating a annual meeting in a sharepoint calendar

(0) ShareShare
ReportReport
Posted on by 23

Hi,

we have a SharePoint calndar for the bithdays of our employees. We get the birthday of each new employee with a Forms request.

I would like to build a flow, which creats a annual entry in our birthday calendar. The basic should be the Forms request.

 

In the Forms request, the user needs to fill in the name, birthday and with a checkbox if it is OK to share the birthday.

If the user choose "yes" then the flow should create the birthday entry in the sharepoint calendar with annual repeading.

 

I have no clue, how to start building my flow. Maybe some of you had already a similar case and could help me.

 

Thank you.

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,871 Most Valuable Professional on at

    Hi @Delany,

     

    I assume this is a classic Calendar app/list you are using, which has fields like EventDate, EndDate, EventType and RecurrenceData?

     

    If that is the case you could use a Send an HTTP request to SharePoint action to create a Calendar list item with your own preferred recurrence pattern based on the birthday date question filled out in the form, in this case yearly.

     

    When you want to read a bit more about the recurrence data schema I can recommend this blog from Justin: https://fatalfrenchy.wordpress.com/2010/07/16/sharepoint-recurrence-data-schema/

     

    Below would be an example with that approach:

    In this example in am using a Birth Date field answer in the Microsoft Forms form and calculate a yearly pattern which ends after 10 instances (10 years) in the RecurrenceData field. That value is also used to calculate the EndDate of the event. 

     

    {
    "Title": "Birthday @{outputs('Get_user_profile_(V2)')?['body/displayName']}",
    "EventDate": "@{outputs('Get_response_details')?['body/rb96a93f81bc94b6bb8a3310a44c9d662']}T00:00:00Z",
    "EndDate": "@{concat(add(int(formatdatetime(parseDateTime(outputs('Get_response_details')?['body/rb96a93f81bc94b6bb8a3310a44c9d662'], 'en-us', 'yyyy-MM-dd'), 'yyyy')),10), formatdatetime(parseDateTime(outputs('Get_response_details')?['body/rb96a93f81bc94b6bb8a3310a44c9d662'], 'en-us', 'yyyy-MM-dd'), '-MM-dd'))}T23:59:00Z",
    "EventType": 1,
    "fRecurrence": true,
    "fAllDayEvent": true,
    "RecurrenceData": "<recurrence><rule><firstDayOfWeek>su</firstDayOfWeek><repeat><yearly yearFrequency=\"1\" month=\"@{int(formatdatetime(parseDateTime(outputs('Get_response_details')?['body/rb96a93f81bc94b6bb8a3310a44c9d662'], 'en-us', 'yyyy-MM-dd'), 'MM'))}\" day=\"@{formatdatetime(parseDateTime(outputs('Get_response_details')?['body/rb96a93f81bc94b6bb8a3310a44c9d662'], 'en-us', 'yyyy-MM-dd'), 'dd')}\" /></repeat><repeatInstances>10</repeatInstances></rule></recurrence>"
    }

     

    recurrenceyearly.png

  • Delany Profile Picture
    23 on at

    Thank yor for your responese. I will try it that way.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 411

#2
David_MA Profile Picture

David_MA 300 Super User 2026 Season 1

#3
Vish WR Profile Picture

Vish WR 291

Last 30 days Overall leaderboard