In the workshop today (16 April) we talked about a word cloud. I gave a small description on how you could possibly do it, but wanted to get some additional thoughts, because it was an amazing idea. My basic thoughts for beginner word cloud concept is this. Create a gallery that expands the size of the screen you want it. In this case I am pulling from another app I have built so its a full screen gallery. I currently have an SharePoint list where I have three main columns (XCoord, YCoord, and Word Cloud). I currently have the XCoord and YCoord manually set, but this is where this groups hive mind could probably do same amazing things. Keep in mind the XCoord and YCoord are based on the position of the screen. So if you gallery is 50w x 50h you would be able to assign the X and Y values between 0 and 50. In this case I select my Label and set the label X value to ThisItem.XCoord and the Y value to ThisItem.YCoord. This is how it moves the label around the screen in a word cloud format. My quick thoughts. 1. Try to show only the Distinct Items. 2. Create a formula to count the number of distinct values and change the font size based off this count. 3. Dynamically create the XCoord and YCoord. 4. a. This would probably need some tweaking. Maybe put the largest count centered. Set the other X and Y to be based off this. Maybe have some sort of detection built in to make sure there is no "Collisions" 5. Set the onSelect to make that work a variable. Now have your other gallery filtered off that variable.

I have a Gallery that is displaying values from a SharePoint List called 'Skills List'. Each gallery item is a single checkbox. I am trying to set the checkbox default value to true or false dependent on if ThisItem.Skill is included a collection called colUserSkills. Image 1 is the gallery itself with checkboxes. The text value is ThisItem.Skill. The 2nd image is the formula I am using as well as the data in my collection. For some reason the default is only working on the initial value of the collection. Any ideas?

Hi all I need help with applying a filter to a gallery. There are quite a few criteria i want to apply and cant seem to quite get the syntax correct. My current code is as follows: Filter( [@'FLT Requests'], Location = "WS" And TruckType = "Combi" And Completed = false And Allocated = false Or Allocated = true And AllocatedTo = "WS-Combi1" ), I need to show all the requests for the specific location and truck that are open BUT ALSO ones that the driver has provisonally picked up as next jobs. This code shows all records and i cant seem to find the correct way of constructing the filter Any help would be appreciated

Does anyone have insights into why Patch statements in a for all would not complete? I’m pulling a list of workflow tasks from a template list then using a for all statement to patch them into a workflows list. Tasks are created the first time an account record is accessed through a gallery on select function. 99% of the time all 13 workflow tasks are created. Periodically some tasks are not created. Any ideas how to prevent this from happening?

Im trying to also filter with two more dropdown but I have try a few thing no luck. Any advise I would appreciate