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 / 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,189 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

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