You’re offline. This is a read only version of the page.
Hi all,
I have a Gallery and I insert icon there for each desk (Desk 1 & Desk 2)
How can I show text when the mouse hovers over the icons in Gallery.
icon 1-> it will show "Desk 1" name
icon 2 -> it will show "Desk 2" name
Desk 1 & Desk 2 are stored in DeskName column in DeskInfo SharePoint list.
I tried to use "Tooltip" but it doesn't work for each desk.
Thanks.
Hi @kinghnvn
Here is the updated code to avoid Delegation
Share
Report
All responses (
Answers (
Clear(ColOfficeBooking);
ForAll(
Sequence(
DateDiff(
Calander1.StartDate,
Calander1.EndDate
) + 1,0
),
With({CalculatedStartDate: DateAdd(
Calander1.StartDate,
Value,
Days
)},
Collect(
ColOfficeBooking,
Filter(
OfficeBooking,
BookingDate = CalculatedStartDate
)
)
)
)
Thanks,
Stalin - Learn To Illuminate
I have tried the steps but it's still not working.
Continue button OneSelect:
Delegation warning. The "Filter" part of this formula might not work correctly on large data sets.
Gallery icon tooltip
LookUp(
ColOfficeBooking,
Office.Id = ThisItem.ID
&& (DateValue(startTime) <= FromDateTime && DateValue(endTime) >= FromDateTime) &&
(Value(Text(startTime,"hhmm")) * 100 >= StartTimeNumber && Value(Text(endTime,"hhmm")) * 100 <= EndTimeNumber ||
Value(Text(startTime,"hhmm")) * 100 <= StartTimeNumber && Value(Text(endTime,"hhmm")) * 100 >= EndTimeNumber ||
Value(Text(endTime,"hhmm")) * 100 > StartTimeNumber && Value(Text(endTime,"hhmm")) * 100 < EndTimeNumber ||
Value(Text(startTime,"hhmm")) * 100 > StartTimeNumber && Value(Text(startTime,"hhmm")) * 100 < EndTimeNumber)
).Employee.DisplayName
Result: it's not showing the Display name when the mouse hovers over the icon item in Gallery
Hi @kinghnvn
I tried with my Date picker to make sure to collect data for those days using sequence
Clear(ColOfficeBooking);
ForAll(
Sequence(
DateDiff(
Calander1.StartDate,
Calander1.EndDate
) + 1,0
),
Collect(
ColOfficeBooking,
Filter(
OfficeBooking,
BookingDate = DateAdd(
Calander1.StartDate,
Value,
Days
)
)
)
)Small correction to add semicolon and make sure closing brackets are added properly.
Clear(ColOfficeBooking);
ForAll(DateDiff(Calander1.StartDate, Calander1.EndDate),
Collect(ColOfficeBooking,
Filter(OfficeBooking,
BookingDate = DateAdd(Calander1.StartDate, ThisRecord.Value,Days)
) //Filter
) //Collect
) //ForAllThat's good. Definitely, we can use the continue button click event. Please try this.
Clear(ColOfficeBooking)
ForAll(DateDiff(Calander1.StartDate, Calander1.EndDate),
Collect(ColOfficeBooking, Filter(OfficeBooking,
BookingDate = DateAdd(Calander1.StartDate, ThisRecord.Value,Days))
)
)
Hi @kinghnvn
Do you have any other event when you select date(s) from Calendars like OnSelect or OnChange?
Thanks,
Stalin - Learn To Illuminate
thank you @StalinPonnusamy
I don't use the Datepicker for a Book Date only.
I'm using a Calendar to select a date or multiple dates.
Hi @kinghnvn
Set the Onchange property of the Datepicker to
ClearCollect(ColOfficeBooking, Filter(OfficeBooking,
BookingDate = ToDate
)
Set the Tooltip property of the icon to
LookUp(
ColOfficeBooking,
Office.Id = ThisItem.ID
&& //Add your time slot as well like displaymode
).Employee.DisplayName
Thanks,
Stalin - Learn To Illuminate
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
