cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bmurphy1
Level: Powered On

Sharepoint List Appointment to Outlook Appointment

I've already created a Sharepoint list that connects to a power app and to excel sheet. 

 

An outside sales rep creates a prospect (potential customer) inside of the PowerApp that is tied to the SharePoint list.  This list contains contact info and notes.  An inside sales rep then follows up with a phone call to schedule onsite appointment.  The SharePoint list has a column to set an appointment date.

 

I'd like to create a flow that then creates an outlook appointment for that date for the outside sales rep based on what was inputted in the SharePoint list.

 

Please help, still new to all this.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Sharepoint List Appointment to Outlook Appointment

 Hey @bmurphy1 

 

You can use the below expression to check if the particular field value is null or not and trigger the flow only if that value is not null. 

 

@not(empty(triggerBody()?['CurrentStatus']))

 

Here, CurrentStatus is the name of the column that I am checking is not null and you can replace that with the column name you want to check on. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

3 REPLIES 3
Dual Super User
Dual Super User

Re: Sharepoint List Appointment to Outlook Appointment

Hey @bmurphy1 

 

One of the best ways to do this according to me is, create another column in SP list named event ID. this need not be visible to everyone. 

 

You can try using the trigger, "When an item is created or modified in SharePoint" trigger and then add a trigger condition to check if the date column for the appointment date is null or not (get started with trigger conditions here https://siddharthvaghasia.com/2019/08/06/trigger-ms-flow-on-condition-based-on-columns-value-with-sh...)

 

And then get the item to check if the event id is empty or not (if empty means the appointment is not yet created and i am assuming that there will be a unique appointment)

 

and if not empty, create an outlook event with the above details. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

bmurphy1
Level: Powered On

Re: Sharepoint List Appointment to Outlook Appointment

Normally the appointment date cell is null.  Is there a way to trigger it once it get's filled out?

Dual Super User
Dual Super User

Re: Sharepoint List Appointment to Outlook Appointment

 Hey @bmurphy1 

 

You can use the below expression to check if the particular field value is null or not and trigger the flow only if that value is not null. 

 

@not(empty(triggerBody()?['CurrentStatus']))

 

Here, CurrentStatus is the name of the column that I am checking is not null and you can replace that with the column name you want to check on. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,693)