cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hkmamun
Helper II
Helper II

MS Flow to Sync Between SharePoint List and Outlook Calendar

Hi Guys,

I am a complete newbie in Power Automate. I am creating a Daily Activity Planner App in Power Apps. To store data I am using SharePoint List with below columns

Title 

Single line of text (Subject)

 

StartDate 

Date and Time

 

EndDate 

Date and Time

 

Description 

Multiple lines of text

 

ActivityFor 

Person or Group (Only allowed single selection)

 

Participants 

Person or Group (Allowed Multiple selection)

 

Location 

Choice

 

Status 

Single line of text (Pending/Completed)

 

CreateFrom 

Single line of text

 

StartDateText

Calculated (calculation based on other columns)

 

EventID

Single line of text

 

ModifiedEvent

Yes/No

  

 

Activity Creation Form:

User will create an activity by giving Title/Subject, StartDateTime, EndDateTime, Location and Participants (None/Single/Multiple). After submitting each participant will get event request and Individual Activity will be created for each participant.

Need to create individual Activity against each event from user’s outlook calendar.

 

Load Form:

When the application will load it will show all the today’s event (Outlook Calendar) for the logged in user. User can mark as “Complete” for each event. Since outlook event does not have any status column to mark as Pending/Complete so am using a Status column in SharePoint list.

 

Solution I did so far:

I am using Power Apps for the front end. When an outlook event is created from other source (except this app) I have created an MS Flow which will create individual activity in the SharePoint list for each participants including the creator create the event. In the list I am saving EventID with Flow.

So to identify individual activity for each user I am using “ActivityFor” column in SharePoint list.

 

NOTE: User can also update and Delete Activity from App or Event in Calendar.

 

Can you guys please help to give me some idea/solution how I can solve this overall situation.

 

Best Regards,

Mamun

0 REPLIES 0

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,567)