Pink Eye Crow

  From Calendar Matrix Visual to a multitude of charts. Same data, different presentation. I have not added any new bookings, so our hotel does not perform well. I thought I will show in this video more of data modelling and logic of visuals, rather than data entry and its effect on visual. I have added few measures for % calculation. The famous CALCULATE() formula. Booked days = Calculate ( COUNTROWS ( biRoomCalendar ), Filter ( biRoomCalendar , [Current Status] = "B" )) Booked, % = Calculate ( COUNTROWS ( biRoomCalendar ), Filter ( biRoomCalendar , [Current Status] = "B" ))/ COUNTROWS ( biRoomCalendar ) Empty,% = Calculate ( COUNTROWS ( biRoomCalendar ), Filter ( biRoomCalendar , [Current Status] = "A" || [Current Status] = "V" ))/ COUNTROWS ( biRoomCalendar ) M&OO,% = Calculate ( COUNTROWS ( biRoomCalendar ), Filter ( biRoomCalendar , [Current Status] = "O" || [Current Status] = "M" ))/ COUNTROWS ( biRoomCalendar ) I di...

  I slightly adjusted the data model and Power App by removing Room Status in Rooms list and adding Choice column in Booking List. Now when booking we can block the days for Maintenance and Out of Order. I sketched a quick Power BI Report , connected to my SharePoint List with data model and also embedded Power App. Now the data can be added directly to PBI and updated after refreshing. Unfortunately, I have Free PBI on my home machine so I could not publish and set Power Automate to refresh my dashboard.  Again, budget variant! :) My Data Model is based on  3 SharePoint Lists and 3 Tables, generated / created in Power BI. Simple DateKey Table  DateKey = CALENDAR ( Min (Bookings[DateFrom]), max (Bookings[DateTo])+ 30 ) And few columns:  MonthNum = Month ( [Date] ) Month = Format ( [Date] , "mmm" ) Year = Year ( [Date] ) Month Year = [Month] & "-" & [Year] biRoomCalendar was created by using Generate Formula. biRoomCalendar = Generate ( Calendar ( Min ...

Edited 26.8.23: Link to data sample create SharePoint lists Link to download                           App sample Link to download ****  Since it does not look like we will have any nice summer holiday this year, I'd decided to fantasise about booking a room. How sad is that! lol A quick app, filters the available rooms for the required period, and Book Room button submits the booking form. Video demonstrates app in action.  Formulae also visible, but I will add logic formulae below as well( I am  skipping formatting formulae) App OnStart  Set(varDate,1) txtvarDays Default  varDays On Change  Set(varDays, Value(txtvarDays.Text)) allows manually enter amount of days / nights Icon Arrow Up Day+ OnSelect  Set(varDays, varDays+1) Icon Arrow Down Day- OnSelect  If(varDays>1,Set(varDays, varDays-1)) // does not go below 1 Find Room Button Refresh(Bookings);ClearCollect(colDates,ForAll(S...

  It took me three evenings, but I did it at the end. Learnt new formulae, though I still think the performance can be improved. Lots of thanks to Reza Dorrani for nested gallery example. Group By in Power Apps Gallery with Large SharePoint Lists - YouTube and  WiZey  for Solved: Collect all dates within a date range - Power Platform Community (microsoft.com) ForAll( Sequence( DateDiff(StartDate, EndDate) ), DateAdd(StartDate, Value, Days) )  I also found similar solution is MS Documentation About Sequence() function Sequence function in Power Apps - Power Platform | Microsoft Learn This  helped me a lot to come up with setting a sequence of the dates between first and last date in array. Multi Select Checkbox in PowerApps - YouTube by  taik18 - Mohammed Adnan was a great help with collecting checked items Bulk Patch was copied from   Create or update bulk records in Power Apps - Power Apps | Microsoft Learn Department Dropdown  ...

  One of the challenges I had when using folders within SharePoint Lists, was to separate folders from items in galleries. There were few things to consider: make sure filter is delegable, there is no unnecessary extra Y/N columns and so on. While exploring Flexible height galleries I applied the visibility trick based on IsFolder property, it  worked a treat. This is one of the cases that it is better show in video, then try to describe in words. You may already noticed, I do not like words too much. :)

  SharePoint Site has a lot of great  web parts. However, I have found that the Buttons for Site Navigation get spaced out too much, and you need to add each button individually. While exploring SharePoint Lists, I thought why not to combine Tile View or rather Gallery List View with Hyperlink column and embed list as a webpart on site. And so I did. After slightly tweaking JSON I changed the standard white background to themed colour, meaning, it will adapt to the site's theme. And the great part about using list is that it is dynamic! With every new row you get additional button. you can also set and apply filter to use same list but different variations of buttons for different site page. Cool, isn't it? Start with creating new List from blank . Add Hyperlink column. Add more columns for filtering, something simple like text type HomePage ( Y/N), and another column Page2 ...  Enter data Title cannot be blank, so we have to type something in. Select Gallery View Save Vi...