Unanswered

Calendar to Link Sharepoint data - few questions require help

(0) Share

Report

Posted on by bbsin

1,994

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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

MudassarSZ365 591 on at

Like (1)

Report
Copy link

Link copied!
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! 😊

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like (0)

Report
Copy link

Link copied!
@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! 😊

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like (0)

Report
Copy link

Link copied!
@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! 😊

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No