Unanswered

Power Automate solution for Calendar View

(0) Share

Report

Posted on by BrucePHU2023

Hi from a beginner,

I'm working on a solution that requires scheduling appointments in a SharePoint Calendar List. The problems I am facing is that:

My Patient list exceeds the 5000 threshold – so I have broken the Patients into 3 separate Lists based on a range of Personal ID’s.
This would require my "Appointments List" to Lookup each of the Patient Lists based on the Personal ID. This LU also is used to return Address, DoB etc, so subsequently this requires far too many Lookups and is not suitable.
This all works in the normal SP List Views although not very elegant, but for the required Calendar View (which the users require) the out of the box Calendar cannot accommodate the 3 Patient Lists.
- On the Edit View Form, the “Start Date” & “End Date” is obtainable, but “Title of items on Calendar” needs to be the “Personal ID” (from 1 of the Patient Lists), and the ”Subheading” needs to be the Patient Name.

Can some body point me in the right direction as to where to start with a suitable solution please?

Thanks in advance.

Apologies if wrong Forum?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@BrucePHU2023 may i know what you are trying to do in Power Automate with the Calendar list, even though the threshold limit is 5000 items for SP list, the list can support more records if worked well in terms of filters and indexes.

Was this reply helpful? Yes No
BrucePHU2023 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for taking the time to reply Anna it is appreciated,
I have a Patients List that exceeds 5000, this is looked up from an Appointments List.
The user enters a Patient ID in the LU to check if it exists, if it does the Patient is selected and the appointment details are completed, if not the new Patient is added to the patient List.
The Patient lookup does not work due to the 5000 breach. I understand filtering the views to return less than 5000, but how do I make the Lookup work when I need to check all of the Patient records.
The users required a calendar view to manage the different Clinics. All of this works fine when below threshold.
I was hoping to split the Patient lists but accessing these through a Calendar view is problematic.
Thanks Bruce

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@BrucePHU2023 in your case i think you will need a customized solution like, use the Modern list which will not have the calendar look, but you can develop a spfx webpart which has the calendar look and shows data from the list to show the calendar, but this will require custom code

Was this reply helpful? Yes No
BrucePHU2023 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks Anna,
I thought as much, I will give it a go but not a programmer. Question is do I stay with the split lists for this?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@BrucePHU2023 i think Single list should be easier to manage, you can refer to this article https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59 on how to manage large lists efficiently

Was this reply helpful? Yes No