Connecting a custom list on Sharepoint to a power app calendar

(0) Share

Report

Posted on by AB21

Hi all,

Wondering if someone can help!

I currently have a Sharepoint list which is populated with details for when someone wants to book time off work.

The data includes the dates they want off ect.

I now want to create a power app that allows the HR lady to view all time off booked through a power app as a calendar linked to that Sharepoint list

with the following layout or something similar.

Screenshot 2020-02-19 at 12.03.54 PM.png

Is this possible?

Can someone help!

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AB21 ,

Do you want to connect the Calendar screen to your SP Calendar List?

Based on the needs that you mentioned, I have made a test on my side, please consider take a try with the following workaround:

Add your SP Calendar List into your app. Then select the CalendarEventsGallery1 within your Calendar events screen, set the Items property to following:

/*Shows events only on selected date*/ SortByColumns( Filter( 'Your Calendar List', Text('Start Time', DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate) ), "EventDate" )

Then modify the formula within these Labels within this CalendarEventsGallery1:

Title3.Text:

ThisItem.Title

Body1.Text:

Text(ThisItem.'Start Time', DateTimeFormat.ShortTime)

Description1.Text:

DateDiff(ThisItem.'Start Time', ThisItem.'End Time', Minutes) & Lower(Left("Minute", 1))

remove formula from the BorderThickness property of the Rectangle1 control.

Then select the MonthDayGallery1, set the Visible property of the Circle1 control to following (represents if there is an event occurred in that day😞

/*Visible if calendar events are found on this day*/ CountRows(Filter('Your Calendar List', DateValue(Text('Start Time')) = DateAdd(_firstDayInView,ThisItem.Value,Days))) > 0 && !Subcircle1.Visible && Title2.Visible

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this @v-xida-msft ! but in my situation the Sharepoint list has these names

How would I customise what you have put in the formulas to match this.

The columns 'StartDate' and 'EndDate' are set as type Date & Time.

I don't think this is even a Sharepoint calendar list can it be converted?

Help!

Thanks in advance

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @AB21 ,

Yeah, Of course. The formula I provided above could also be applied to your custom SP List.

Please modify your app's configuration as below:

Add your custom SP List into your app. Then select the CalendarEventsGallery1 within your Calendar events screen, set the Items property to following:

/*Shows events only on selected date*/ SortByColumns( Filter( 'Your Custom List', Text(StartDate, DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate) ), "StartDate" )

Then modify the formula within these Labels within this CalendarEventsGallery1:

Title3.Text:

ThisItem.Title

Body1.Text:

Text(ThisItem.StartDate, DateTimeFormat.ShortTime)

Description1.Text:

DateDiff(ThisItem.StartDate, ThisItem.EndDate, Minutes) & Lower(Left("Minute", 1))

remove formula from the BorderThickness property of the Rectangle1 control.

Then select the MonthDayGallery1, set the Visible property of the Circle1 control to following (represents if there is an event occurred in that day)

/*Visible if calendar events are found on this day*/ CountRows(Filter('Your Custom List', DateValue(Text(StartDate)) = DateAdd(_firstDayInView,ThisItem.Value,Days))) > 0 && !Subcircle1.Visible && Title2.Visible

Please consider take a try with above modification, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft ,

Thank you for this that worked! Im struggling to get all these columns to appear in my power app:

I want them to appear here?

Also Is it possible to get the app to fill in the blanks for example when the time/date is inputted in the list it also fills in the calendar from the startdate till the enddate with the dots too? At the minute it only inputs the dot on the start date of every entry put in the list, not the end date or the complete time that the person wants off. Example: If Simon wanted the 15th - 18th off, all dates will have Simons details in rather then just the 15th

Thanks in advance!

Was this reply helpful? Yes No