Calendar to Link Sharepoint data - few questions require help

[bbsin]

hi 

I am trying to use out of the box calendar and followed one of the user Reza's Youtube to build.

I cannot get 
1) I like to display the event title and venue using SP list start date (date picker) and end date with the button within the gallery
Filter(Sharpointlist, EventStartDate = DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days)) - not too sure. how

2) why is there a big circle button in between 28 and 30?

3) I like to filter the gallery calendar with two drop-down when user click to display 
4) the user dropdown how to change it to display user name, is showing as i.0#.f.... (it's people pick in SP List)
5) May I know how to default the filter to display all and only when user select the two filter to show accordingly 

Thank you

Appreciated 

[MudassarSZ365]

Hi @bbsin ,

to Display Event Title and Venue set this code on the items property of the gallery

Filter(
  SharePointList,
  EventStartDate <= DateAdd(_firstDayInView, ThisItem.Value, Days) && 
  EventEndDate >= DateAdd(_firstDayInView, ThisItem.Value, Days)
)

to Filter Gallery with Dropdowns set this code on the items property of the gallery

Filter(
  SharePointList,
  Dropdown1.Selected.Value = ColumnName1, 
  Dropdown2.Selected.Value = ColumnName2
)

To display the user name from a People Picker column, use the proper attribute from the column:

Dropdown.Selected.DisplayName

To default the filter to show all items and apply filters only when the user selects options from the dropdowns, use an If condition in your filter formula:

Filter(
  SharePointList,
  (IsBlank(Dropdown1.Selected.Value) || ColumnName1 = Dropdown1.Selected.Value) && 
  (IsBlank(Dropdown2.Selected.Value) || ColumnName2 = Dropdown2.Selected.Value)
)

If these solutions help you, please mark this as the solution and leave a thumbs up. Thank you! 😊

[bbsin]

@MudassarSZ365 

Hi Appreciate the details codes, but not too sure I cannot get to display

Filter('L&OD Programme Plan Tracking', EventStartDate <= DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) &&
EventEndDate >= DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)
);
Filter(
'L&OD Programme Plan Tracking',
drpStatus.Selected.Value = EventStatus,
drpUser.Selected.Value = EventIC
);
If(Filter(
'L&OD Programme Plan Tracking',
(IsBlank(drpStatus.Selected.Value) || EventStatus = drpStatus.Selected.Value) &&
(IsBlank(drpUser.Selected.Value) || EventIC = drpUser.Selected.Value)
)

the EVENT IC SP name , people picker, still cannot display just the name

is it possible to change to search instate of drop down, so that user can input to select?
Thank you

Regards

[MudassarSZ365]

@bbsin ,

People Picker Display Name: To display just the name from a People Picker field in SharePoint, you need to ensure you're referencing the .DisplayName property of the field. However, if you're dealing with a dropdown control, you should be able to just use Dropdown.Selected.DisplayName or for a gallery, ThisItem.PeoplePickerField.DisplayName.

So, if your People Picker field in SharePoint is EventIC, the formula to display the name would be something like ThisItem.EventIC.DisplayName.

Filtering the Gallery: To filter based on dropdowns, your formula should look something like this:

Filter(
    'L&OD Programme Plan Tracking',
    (IsBlank(drpStatus.Selected.Value) || EventStatus.Value = drpStatus.Selected.Value) &&
    (IsBlank(drpUser.Selected.Value) || EventIC.Email = drpUser.Selected.Email)
)

Gallery Display for Date Range: Your formula for filtering based on the date range looks correct, but ensure that _firstDayInView is properly set to the first visible day in your calendar view and that TimeUnit.Days is the appropriate interval you want to use.

Filter(
    'L&OD Programme Plan Tracking',
    EventStartDate <= DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) &&
    EventEndDate >= DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)
)

If the provided information resolves your query, I'd appreciate it if you could mark it as the solution and leave a thumbs up. Thank you! 😊

[bbsin]

hi ,@MudassarSZ365 

Think I am getting there.

1) the event Title are not displaying at the gallery at all. Also is it possible to display two items
is it using Thisitem.Title && Thisitem.Venue? 
Eg 
Event Name
Venue

- the button is only input as Thisitem.Title
SP field is date time

2) how to reset to default show all after the user clicked to return to empty in the drop down selection? 

Thank you

[MudassarSZ365]

@bbsin ,

To display the event title and venue in the gallery put this code on the text property of the label 

ThisItem.Title & "\n" & ThisItem.Venue

To reset the dropdown to show all items after a selection has been made, you can set the Default property of the dropdown to:

{Result: ""}

And modify the filter formula for the gallery items property

Filter(
  SharePointList,
  drpStatus.Selected.Value = "" || EventStatus = drpStatus.Selected.Value,
  drpUser.Selected.Value = "" || EventIC.DisplayName = drpUser.Selected.DisplayName
)

This way, when the dropdown selection is empty (""), it will show all items.

If the provided information resolves your query, I'd appreciate it if you could mark it as the solution and leave a thumbs up. Thank you! 😊

[bbsin]

hi @MudassarSZ365 

I am not too sure how to filter the gallery based on the dropdowns and user
1) Do I put the filter inside the nested gallery?


2)  I have two events in Dec starting same date 28 Dec, it's not showing multiple events on the same start date till end.
it was displaying fine when I added one event , now it's not working for dec at all

3) Jan is showing but how to many the same event across the date?

4) To filter by the event status, group type and owner

Do I put the filter property inside the nested gallery?

does know right, as there's error, please advise. 

Filter(
SHarePoint list',
(IsBlank(drpStatus.Selected.Value) || CurrentStatus.Value = drpStatus.Selected.Value) &&
(IsBalnk(drpGrpType.Selected.Value) || GroupBy(.Value = drpGrpType.Selected.Value)
(IsBlank(drpUser.Selected.Value) || EventIC.Email = drpUser.Selected.Email)
)

Thank you

[bbsin]

@MudassarSZ365 

Hi  I try cannot get it working,
not sure where is not right

1) to display the event details

Filter(
'L&OD Programme Plan',
EventStartDateTime <= DateAdd(_firstDayInView, ThisItem.Value, Days) &&
EventEndDateTime >= DateAdd(_firstDayInView, ThisItem.Value, Days)
);
F
(IsBlank(drpUser.Selected.Value) || ProgOwner = drpUser.Selected.Value) &&
(IsBlank(drpStatus.Selected.Value) || EventStatus = drpStatus.Selected.Value)
)

I want to display the Title, Venue 

2) Why is there a blue highlight on the 11 Jan?

Thank you