Skip to content

Instantly share code, notes, and snippets.

View m3ngi3's full-sized avatar
🥰

Django Lohn m3ngi3

🥰
View GitHub Profile
@m3ngi3
m3ngi3 / PowerApps_AzureAD_Group
Last active July 1, 2019 06:24
PowerApps_AzureAD_Group
ClearCollect(
colGroups,
AddColumns(AddColumns(
Table(
{colGroupsGroupId: "8057fc8d-1f48-410f-b0fd-920ccbb1a549",LookupName:"O365 PAa",Process:"-1-2-4-5-"},
{colGroupsGroupId: "a21395fb-54e2-4282-825b-316beb6d807f",LookupName:"SC PAa",Process:"-1-3-"},
{colGroupsGroupId: "e11cdea5-942e-4876-a617-e15d4d101f14",LookupName:"O365 SP",Process:"-4-5"}
),
"colGroupsDisplayName",
AzureAD.GetGroup(colGroupsGroupId).displayName,
@m3ngi3
m3ngi3 / GalleryControl_NavigationRibbon_ItemsFilter
Created June 10, 2019 11:17
PowerApps Gallery as Navigation - Formula for Items Filtered
If("django" in Lower(User().Email),COLribbon,Filter(COLribbon,RibbonItemVisibility<>"Owners"))
@m3ngi3
m3ngi3 / GalleryControl_NavigationRibbon_Height
Created June 10, 2019 11:16
PowerApps Gallery as Navigation - Formula for Height
rtc_helloworldblack.Height*(RoundUp(CountRows(GalleryRibbon_Splash.AllItems)/GalleryRibbon_Splash.BorderThickness,0))
@m3ngi3
m3ngi3 / GalleryControl_NavigationRibbon_TemplateSize
Created June 10, 2019 11:14
PowerApps Gallery as Navigation - Formula for TemplateSize
Parent.Width / If(
CountRows(GalleryRibbon_Splash.AllItems)<=GalleryRibbon_Splash.BorderThickness,
CountRows(GalleryRibbon_Splash.AllItems),
If(
Or((((CountRows(GalleryRibbon_Splash.AllItems)/GalleryRibbon_Splash.BorderThickness)-(RoundDown(CountRows(GalleryRibbon_Splash.AllItems)/GalleryRibbon_Splash.BorderThickness,0)))*GalleryRibbon_Splash.BorderThickness)>(0.5*GalleryRibbon_Splash.BorderThickness),((CountRows(GalleryRibbon_Splash.AllItems)/GalleryRibbon_Splash.BorderThickness)-(RoundDown(CountRows(GalleryRibbon_Splash.AllItems)/GalleryRibbon_Splash.BorderThickness,0)))=0),
GalleryRibbon_Splash.BorderThickness,
RoundUp(GalleryRibbon_Splash.BorderThickness*0.5+0.001,0)
)
)
@m3ngi3
m3ngi3 / GalleryControl_NavigationRibbon_WrapCount
Last active June 10, 2019 11:15
PowerApps Gallery as Navigation - Formula for WrapCount
RoundUp(CountRows(GalleryRibbon_Splash.AllItems)/GalleryRibbon_Splash.BorderThickness,0)
@m3ngi3
m3ngi3 / GalleryControl_NavigationRibbon_ClearCollect
Last active June 10, 2019 11:14
PowerApps Gallery as Navigation - Formula for ClearCollect
ClearCollect(
COLribbon,
{
RibbonItemOrder: 1,
RibbonItemVisibility: "Owners",
RibbonItemImage: SampleImage,
RibbonItemTitle: "Options for owners",
RibbonItemDescription: "Description",
RibbonItemOnSelectScreen: scr_owners,
RibbonItemIcon: Icon.Hamburger