Hello everyone,
I'm in a trap and can't get out of it.
I have developed an App for my Team. This below in the picture is the monthly calendar for workplace planning. What I would like is for the work location to be displayed next to each person as in the picture below, based on start date (from) and end date (to) as in sharepoint list
GalleryCalendar = Sequence(gblDaysInMonth)
Gallery5 (nested gallery) =
Filter('Leave Request';
DateAdd(_firstDayInView-1;ThisItem.Value;Days)>=FromWork && DateAdd(_firstDayInView-1;ThisItem.Value;Days)<=ToWork && 'Created By'.DisplayName=Name.Text)
GalleryUser = ForAll(Distinct('Leave Request';'Created By'.DisplayName).Result;LookUp('Leave Request';'Created By'.DisplayName=Result))
SharePoint List:
Thank you for your help!!


Report
All responses (
Answers (