Success Stories

No blog post yet.

Design features

3 Level Dropdown, Search, Date only for files, Back/Forward FILTERS, file open, name path copy, empty sample record & show file type DONE
Almost like a file manager with out power automate only using Power Apps
NOTE: Be aware of delegation warnings and documents limit(works fine upto 2000 files or folders)

YAML Code

- conFileManager:

Control: GroupContainer@1.3.0

Variant: ManualLayout

Properties:

Height: =693

Width: =1283

X: =40

Y: =40

Children:

- Gallery3_3:

Control: Gallery@2.15.0

Variant: BrowseLayout_Vertical_ThreeTextOneImageVariant_ver5.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

BorderThickness: =1

Fill: =RGBA(237, 237, 237, 0.75)

Height: =518

Items: =colSample

Visible: =!Gallery3_2.AllItemsCount

X: =56

Y: =159

Children:

- Rectangle3_3:

Control: Rectangle@2.3.0

Group: Group1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Fill: =RGBA(0, 18, 107, 1)

Height: =Parent.TemplateHeight - Separator4_3.Height

OnSelect: =Select(Parent)

Visible: =!Gallery3_2.AllItemsCount

Width: =4

- NextArrow4_3:

Control: Classic/Icon@2.5.0

Group: Group1

Properties:

AccessibleLabel: =Self.Tooltip

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(166, 166, 166, 1)

Height: =50

Icon: =Icon.ChevronRight

OnSelect: |-

=Set(varFoldersPath,varFoldersPath & ThisItem.Name & "/");

If(

CountRows(Split(varFoldersPath, "/"))<=4,

Set(varFolderH, IfError( Index(Split(varFoldersPath, "/"), 3).Value, "Select"));

ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" ) && IsFolder=true),Name)));

If(

CountRows(Split(varFoldersPath, "/"))<=5,

Set(varSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 4).Value, "Select"));

ClearCollect(colSubSubFoldersH, {'{Name}': "Select"});

Collect(colSubSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" & city_drp_10.SelectedText.Value & "/" ) && IsFolder=true),Name)));

If(

CountRows(Split(varFoldersPath, "/"))<=6,

Set(varSubSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 5).Value, "Select"))

)

Set(varFolderH, IfError( Index(Split(varFoldersPath, "/"), 3).Value, "Select"));

ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_6.SelectedText.Value & "/" ) && IsFolder=true),Name));

Set(varSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 4).Value, "Select"));

ClearCollect(colSubSubFoldersH, {'{Name}': "Select"});

Collect(colSubSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_6.SelectedText.Value & "/" & city_drp_7.SelectedText.Value & "/" ) && IsFolder=true),Name));

Set(varSubSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 5).Value, "Select"));

Set(varFoldersPath,varFoldersPath & ThisItem.Name & "/");

Set(varFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))) )

,(Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))))) -(1+ Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

Set(varSubFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

,(Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))))) -(1 + Find( "/", ( varFoldersPath),1+ Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))))) )

);

Set(varSubSubFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

/*Set(varFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))))

,Len(varFoldersPath) - (1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))))

);*/

//Set(varFolderH,Left( Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),Find( "/", ( varFoldersPath))))), Find( "/", ( varFoldersPath),20)));

//SetProperty(city_drp_6.SelectedText, {Value:"MP"});

PaddingBottom: =16

PaddingLeft: =16

PaddingRight: =16

PaddingTop: =16

Tooltip: ="View item details"

Visible: =!Gallery3_2.AllItemsCount

Width: =50

X: =Parent.TemplateWidth - Self.Width - 12

Y: =3

- Image4_3:

Control: Image@2.2.3

Group: Group1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Height: =84

Image: =If(ThisItem.IsFolder,Foder_icon, ThisItem.Thumbnail.Medium)

OnSelect: =Select(Parent)

RadiusBottomLeft: =8

RadiusBottomRight: =8

RadiusTopLeft: =8

RadiusTopRight: =8

Visible: =!Gallery3_2.AllItemsCount

Width: =84

X: =16

Y: =(Parent.TemplateHeight / 2) - (Self.Height / 2)

- Title4_6:

Control: Label@2.5.1

Group: Group1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Color: =RGBA(50, 49, 48, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Height: =Self.Size * 1.8

OnSelect: |-

=Copy(Self.Text);

Notify("File name copied",NotificationType.Success)

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =14

Text: =ThisItem.Name

VerticalAlign: =VerticalAlign.Top

Visible: =!Gallery3_2.AllItemsCount

Width: =Parent.TemplateWidth - 185

X: =115

Y: =8

- Subtitle4_3:

Control: Label@2.5.1

Group: Group1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Height: =18

OnSelect: |-

=Copy(Self.Text);

Notify("File path copied",NotificationType.Success)

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =10

Text: =ThisItem.'Full Path'

VerticalAlign: =VerticalAlign.Top

Visible: =!Gallery3_2.AllItemsCount

Width: =430

X: =115

Y: =33

- Body2_3:

Control: Label@2.5.1

Group: Group1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Height: =19

OnSelect: =Select(Parent)

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =10

Text: |-

=$"File type: {IfError(Index(Split(ThisItem.'Full Path', "."), 2).Value, "Folder")} Date: {Coalesce(Text( ThisItem.Date), "Date not available")} Created By: {Coalesce(Text(ThisItem.'Created By'.DisplayName),"N/A")}"

//{Left( ThisItem.'Created By'.Email,Find("@",ThisItem.'Created By'.Email)-1)}

VerticalAlign: =VerticalAlign.Top

Visible: =!Gallery3_2.AllItemsCount

Width: =430

X: =115

Y: =50

- Title4_7:

Control: Label@2.5.1

Group: Group1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Color: =RGBA(39, 113, 194, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

OnSelect: =Launch( ThisItem.'Link to item')

Overflow: =Overflow.Scroll

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =10

Text: |-

=//ThisItem.'Folder path'

ThisItem.'Link to item'

VerticalAlign: =VerticalAlign.Top

Visible: =!Gallery3_2.AllItemsCount

Width: =430

X: =115

Y: =67

- Separator4_3:

Control: Rectangle@2.3.0

Group: Group1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Fill: =RGBA(56, 96, 178, 1)

Height: =2

OnSelect: =Select(Parent)

Visible: =!Gallery3_2.AllItemsCount

Width: =Parent.TemplateWidth

Y: =Parent.TemplateHeight - Self.Height

- Label6_9:

Control: Label@2.5.1

Group: Group1

Properties:

Align: =Align.Center

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(255, 255, 255, 1)

Fill: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

Height: =43

OnSelect: =

Size: =9

Text: ="Nothing to open"

Visible: =!Gallery3_2.AllItemsCount

Width: =62

X: =568

Y: =8

- Label6_10:

Control: Label@2.5.1

Group: Group1

Properties:

Align: =Align.Center

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(255, 255, 255, 1)

Fill: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

Height: =43

OnSelect: =

PaddingBottom: =2

Size: =8

Text: ="Nothing to Download"

VerticalAlign: =VerticalAlign.Bottom

Visible: =!Gallery3_2.AllItemsCount

Width: =62

X: =568

Y: =61

- Icon1_2:

Control: Classic/Icon@2.5.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(0, 18, 107, 1)

Height: =41

Icon: =Icon.BackArrow

OnSelect: |-

=Set(varFoldersPath,Concat(FirstN(Split(varFoldersPath,"/"),CountRows(Split(varFoldersPath,"/"))-2),Value,"/") & "/");

If(

CountRows(Split(varFoldersPath, "/"))<=4,

Set(varFolderH, IfError( Index(Split(varFoldersPath, "/"), 3).Value, "Select"));

ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" ) && IsFolder=true),Name)));

If(

CountRows(Split(varFoldersPath, "/"))<=5,

Set(varSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 4).Value, "Select"));

ClearCollect(colSubSubFoldersH, {'{Name}': "Select"});

If(

CountRows(Split(varFoldersPath, "/"))<=6,

Set(varSubSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 5).Value, "Select"))

)

//Set(varFoldersPath,varFoldersPath & ThisItem.Name & "/");

Set(varFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))) )

,(Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))))) -(1+ Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

Set(varSubFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

Set(varSubSubFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_6.SelectedText.Value & "/" ) && IsFolder=true),Name));

Visible: =CountRows(Split(varFoldersPath,"/"))>2

Width: =40

X: =8

Y: =16

- Label3_3:

Control: Label@2.5.1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Font: =Font.'Open Sans'

Height: =28

Text: =varFoldersPath

Width: =496

X: =61

Y: =23

- DatePickerFrom_1:

Control: Classic/DatePicker@2.6.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

DefaultDate: =

Font: =Font.'Open Sans'

IconBackground: =RGBA(56, 96, 178, 1)

IconFill: =RGBA(255, 255, 255, 1)

Reset: =varReset

Width: =168

X: =389

Y: =57

- Gallery3_2:

Control: Gallery@2.15.0

Variant: BrowseLayout_Vertical_ThreeTextOneImageVariant_ver5.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

BorderThickness: =1

Height: =517

Items: |-

=Filter( Documents, ('Folder path'=varFoldersPath) && (TextInputSearch_1.Text in 'File name with extension') && If(DatePickerTo_1.SelectedDate=Blank() || DatePickerFrom_1.SelectedDate=Blank(), "" in Date, ("false" in IsFolder && (DatePickerFrom_1.SelectedDate <= Date && DatePickerTo_1.SelectedDate >= Date) || ("true" in IsFolder && "" in Date))))

Filter( Documents, ('Folder path'=varFoldersPath) && (TextInputSearch.Text in 'File name with extension') &&

If(DatePickerTo.SelectedDate=Blank() || DatePickerFrom.SelectedDate=Blank(), "" in Date,

//If(!IsFolder,

(

"false" in IsFolder &&

(DatePickerFrom.SelectedDate <= Date && DatePickerTo.SelectedDate >= Date)

("true" in IsFolder && "" in Date)

)))

// & Created<DatePicker1_1.SelectedDate & Created>DatePicker1_1.SelectedDate)

//WORKING LOGIC

//Filter( Documents, 'Folder path'=varFoldersPath && TextInputSearch.Text in 'File name with extension' && If(!IsFolder, (DatePickerFrom.SelectedDate <= Date && DatePickerTo.SelectedDate >= Date) ,"" in Date))

//Filter( Documents, 'Folder path'=varFoldersPath && TextInputSearch.Text in 'File name with extension' && If(DatePickerTo.SelectedDate=! Blank() || DatePickerFrom.SelectedDate=!Blank(), If(!IsFolder, (DatePickerFrom.SelectedDate <= Date && DatePickerTo.SelectedDate >= Date) ,"" in Date),"" in Date))

X: =56

Y: =159

Children:

- Rectangle3_2:

Control: Rectangle@2.3.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Fill: =RGBA(0, 18, 107, 1)

Height: =Parent.TemplateHeight - Separator4_2.Height

OnSelect: =Select(Parent)

Visible: =ThisItem.IsSelected

Width: =4

- NextArrow4_2:

Control: Classic/Icon@2.5.0

Properties:

AccessibleLabel: =Self.Tooltip

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(166, 166, 166, 1)

Height: =50

Icon: =Icon.ChevronRight

OnSelect: |-

=Set(varFoldersPath,varFoldersPath & ThisItem.Name & "/");

If(

CountRows(Split(varFoldersPath, "/"))<=4,

Set(varFolderH, IfError( Index(Split(varFoldersPath, "/"), 3).Value, "Select"));

ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" ) && IsFolder=true),Name)));

If(

CountRows(Split(varFoldersPath, "/"))<=5,

Set(varSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 4).Value, "Select"));

ClearCollect(colSubSubFoldersH, {'{Name}': "Select"});

If(

CountRows(Split(varFoldersPath, "/"))<=6,

Set(varSubSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 5).Value, "Select"))

)

Set(varFolderH, IfError( Index(Split(varFoldersPath, "/"), 3).Value, "Select"));

ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_6.SelectedText.Value & "/" ) && IsFolder=true),Name));

Set(varSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 4).Value, "Select"));

ClearCollect(colSubSubFoldersH, {'{Name}': "Select"});

Set(varSubSubFolderH, IfError( Index(Split(varFoldersPath, "/"), 5).Value, "Select"));

Set(varFoldersPath,varFoldersPath & ThisItem.Name & "/");

Set(varFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))) )

,(Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))))) -(1+ Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

Set(varSubFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

Set(varSubSubFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))) )

);

/*Set(varFolderH,

Left(

Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath))))

,Len(varFoldersPath) - (1 + Find( "/", ( varFoldersPath),1 + Find( "/", ( varFoldersPath)))))

);*/

//Set(varFolderH,Left( Right( varFoldersPath,Len(varFoldersPath) - Find( "/", ( varFoldersPath),Find( "/", ( varFoldersPath))))), Find( "/", ( varFoldersPath),20)));

//SetProperty(city_drp_6.SelectedText, {Value:"MP"});

PaddingBottom: =16

PaddingLeft: =16

PaddingRight: =16

PaddingTop: =16

Tooltip: ="View item details"

Visible: =ThisItem.IsFolder

Width: =50

X: =Parent.TemplateWidth - Self.Width - 12

Y: =3

- Image4_2:

Control: Image@2.2.3

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Height: =84

Image: =If(ThisItem.IsFolder,Foder_icon, ThisItem.Thumbnail.Medium)

OnSelect: =Select(Parent)

RadiusBottomLeft: =8

RadiusBottomRight: =8

RadiusTopLeft: =8

RadiusTopRight: =8

Width: =84

X: =16

Y: =(Parent.TemplateHeight / 2) - (Self.Height / 2)

- Title4_4:

Control: Label@2.5.1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Color: =RGBA(50, 49, 48, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Height: =Self.Size * 1.8

OnSelect: |-

=Copy(Self.Text);

Notify("File name copied",NotificationType.Success)

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =14

Text: =ThisItem.Name

VerticalAlign: =VerticalAlign.Top

Width: =Parent.TemplateWidth - 185

X: =115

Y: =8

- Subtitle4_2:

Control: Label@2.5.1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Height: =18

OnSelect: |-

=Copy(Self.Text);

Notify("File path copied",NotificationType.Success)

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =10

Text: =ThisItem.'Full Path'

VerticalAlign: =VerticalAlign.Top

Width: =430

X: =115

Y: =33

- Body2_2:

Control: Label@2.5.1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Height: =19

OnSelect: =Select(Parent)

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =10

Text: |-

//{Left( ThisItem.'Created By'.Email,Find("@",ThisItem.'Created By'.Email)-1)}

VerticalAlign: =VerticalAlign.Top

Width: =430

X: =115

Y: =50

- Title4_5:

Control: Label@2.5.1

Properties:

BorderColor: =RGBA(0, 0, 0, 1)

Color: =RGBA(39, 113, 194, 1)

Font: =Font.'Open Sans'

FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

OnSelect: =Launch( ThisItem.'Link to item')

Overflow: =Overflow.Scroll

PaddingBottom: =0

PaddingLeft: =0

PaddingRight: =0

PaddingTop: =0

Size: =10

Text: |-

=//ThisItem.'Folder path'

ThisItem.'Link to item'

VerticalAlign: =VerticalAlign.Top

Width: =430

X: =115

Y: =67

- Separator4_2:

Control: Rectangle@2.3.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Fill: =RGBA(56, 96, 178, 1)

Height: =2

OnSelect: =Select(Parent)

Width: =Parent.TemplateWidth

Y: =Parent.TemplateHeight - Self.Height

- Label6_11:

Control: Label@2.5.1

Properties:

Align: =Align.Center

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(255, 255, 255, 1)

Fill: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

Height: =43

OnSelect: =Launch(ThisItem.'Link to item')

Size: =9

Text: ="Open"

Visible: =!ThisItem.IsFolder

Width: =62

X: =568

Y: =8

- Icon2_2:

Control: Classic/Icon@2.5.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(255, 255, 255, 1)

Height: =40

Icon: =Icon.OpenInNewWindow

OnSelect: =Launch(ThisItem.'Link to item')

Visible: =!ThisItem.IsFolder

Width: =49

X: =578

Y: =8

- Label6_12:

Control: Label@2.5.1

Properties:

Align: =Align.Center

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(255, 255, 255, 1)

Fill: =RGBA(0, 0, 0, 1)

Font: =Font.'Open Sans'

Height: =43

OnSelect: =Download(ThisItem.'Link to item')

PaddingBottom: =2

Size: =8

Text: ="Download"

VerticalAlign: =VerticalAlign.Bottom

Visible: =!ThisItem.IsFolder

Width: =62

X: =568

Y: =61

- Icon2_3:

Control: Classic/Icon@2.5.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(255, 255, 255, 1)

Height: =26

Icon: =Icon.Download

OnSelect: =Download(ThisItem.'Link to item')

Visible: =!ThisItem.IsFolder

Width: =49

X: =575

Y: =64

- city_drp_9:

Control: Classic/DropDown@2.3.1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

ChevronBackground: =RGBA(56, 96, 178, 1)

ChevronFill: =RGBA(255, 255, 255, 1)

ChevronHoverBackground: =ColorFade(RGBA(56, 96, 178, 1), -20%)

ChevronHoverFill: =RGBA(255, 255, 255, 1)

Default: =varFolderH

Font: =Font.'Open Sans'

Height: =39

HoverFill: =RGBA(186, 202, 226, 1)

Items: |-

=colFoldersH

//"" &

//ShowColumns( Filter( Documents, 'Folder path'="Shared Documents/Site_Folder/"),Name)

//Split(VarFolders,",")

//Filter( Documents, IsFolder=true)

Items.Value: ={Name}

OnChange: |-

=If(Self.SelectedText.Value="Select",

Set(varFoldersPath,"Shared Documents/Site_Folder/"),

Set(varFoldersPath,"Shared Documents/Site_Folder/" & Self.SelectedText.Value & "/"));ClearCollect(colSubFoldersH, {'{Name}': "Select"});

Collect(colSubFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" ) && IsFolder=true),Name));

Set(varSubFolderH,"Select");

Clear(colSubSubFoldersH);

Set(varSubSubFolderH,"Select");

PressedColor: =RGBA(255, 255, 255, 1)

PressedFill: =RGBA(0, 18, 107, 1)

Reset: |-

=//false

varReset

SelectionColor: =RGBA(255, 255, 255, 1)

SelectionFill: =RGBA(56, 96, 178, 1)

Width: =123

X: =56

Y: =107

- city_drp_10:

Control: Classic/DropDown@2.3.1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

ChevronBackground: =RGBA(56, 96, 178, 1)

ChevronFill: =RGBA(255, 255, 255, 1)

ChevronHoverBackground: =ColorFade(RGBA(56, 96, 178, 1), -20%)

ChevronHoverFill: =RGBA(255, 255, 255, 1)

Default: =varSubFolderH

Font: =Font.'Open Sans'

Height: =39

HoverFill: =RGBA(186, 202, 226, 1)

Items: |-

=colSubFoldersH

//IfError(Split(VarSubFolders,",")," ",Split(VarSubFolders,","))

//Split(VarSubFolders,",")

Items.Value: ={Name}

OnChange: |-

=If(Self.SelectedText.Value="Select",

Set(varFoldersPath,"Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/"),

Set(varFoldersPath,"Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" & Self.SelectedText.Value & "/"));ClearCollect(colSubSubFoldersH, {'{Name}': "Select"});

Set(varSubSubFolderH,"Select");

PressedColor: =RGBA(255, 255, 255, 1)

PressedFill: =RGBA(0, 18, 107, 1)

Reset: |-

=//false

varReset

SelectionColor: =RGBA(255, 255, 255, 1)

SelectionFill: =RGBA(56, 96, 178, 1)

Visible: |-

=//true

CountRows(colSubFoldersH)>1

//CountRows(Self)

Width: =124

X: =179

Y: =108

- Button3_4:

Control: Classic/Button@2.2.0

Properties:

BorderColor: =ColorFade(Self.Fill, -15%)

Color: =RGBA(255, 255, 255, 1)

DisabledBorderColor: =RGBA(166, 166, 166, 1)

Fill: =RGBA(56, 96, 178, 1)

Font: =Font.'Open Sans'

HoverBorderColor: =ColorFade(Self.BorderColor, 20%)

HoverColor: =RGBA(255, 255, 255, 1)

HoverFill: =ColorFade(RGBA(56, 96, 178, 1), -20%)

OnSelect: |-

=//Final including select

ClearCollect(colFoldersH, {'{Name}': "Select"});

Collect(colFoldersH, ShowColumns( Filter( Documents, 'Folder path'=("Shared Documents/Site_Folder/") && IsFolder=true),Name));

Clear(colSubFoldersH);

Clear(colSubSubFoldersH);

Set(varReset,false);

Set(varReset,true);

Set(varFoldersPath,"Shared Documents/Site_Folder/");

Set(varFolderH,"Select");

Set(varSubFolderH,"Select");

Set(varSubSubFolderH,"Select");

ClearCollect(colSample,Table({Title:0, Name:"No files to show", IsFolder:"N/A", 'Link to item':"", 'Full Path':"N/A.N/A", Date:"DD/MM/YYYY", Thumbnail:{Medium: SampleImage}, 'Created By':{DisplayName:""}}));

PressedBorderColor: =Self.Fill

PressedColor: =Self.Fill

PressedFill: =Self.Color

Text: ="OnVisible Code"

X: =427

Y: =106

- city_drp_11:

Control: Classic/DropDown@2.3.1

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

ChevronBackground: =RGBA(56, 96, 178, 1)

ChevronFill: =RGBA(255, 255, 255, 1)

ChevronHoverBackground: =ColorFade(RGBA(56, 96, 178, 1), -20%)

ChevronHoverFill: =RGBA(255, 255, 255, 1)

Default: =varSubSubFolderH

Font: =Font.'Open Sans'

Height: =39

HoverFill: =RGBA(186, 202, 226, 1)

Items: |-

=colSubSubFoldersH

//IfError(Split(VarSubFolders,",")," ",Split(VarSubFolders,","))

//Split(VarSubFolders,",")

Items.Value: ={Name}

OnChange: |-

=If(Self.SelectedText.Value="Select",

Set(varFoldersPath,"Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" & city_drp_10.SelectedText.Value & "/"),

Set(varFoldersPath,"Shared Documents/Site_Folder/" & city_drp_9.SelectedText.Value & "/" & city_drp_10.SelectedText.Value & "/" & Self.SelectedText.Value & "/"))

PressedColor: =RGBA(255, 255, 255, 1)

PressedFill: =RGBA(0, 18, 107, 1)

Reset: |-

=//false

varReset

SelectionColor: =RGBA(255, 255, 255, 1)

SelectionFill: =RGBA(56, 96, 178, 1)

Visible: |-

=//true

CountRows(colSubFoldersH)>1 && CountRows(colSubSubFoldersH)>1

//CountRows(Self)

Width: =124

X: =303

Y: =108

- TextInputSearch_1:

Control: Classic/TextInput@2.3.2

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Default: =

Font: =Font.'Open Sans'

HintText: ="Search here"

HoverBorderColor: =RGBA(0, 18, 107, 1)

HoverFill: =RGBA(186, 202, 226, 1)

X: =58

Y: =57

- DatePickerTo_1:

Control: Classic/DatePicker@2.6.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

DefaultDate: =

Font: =Font.'Open Sans'

IconBackground: =RGBA(56, 96, 178, 1)

IconFill: =RGBA(255, 255, 255, 1)

Reset: =varReset

Width: =168

X: =565

Y: =57

- Icon3_1:

Control: Classic/Icon@2.5.0

Properties:

BorderColor: =RGBA(0, 18, 107, 1)

Color: =RGBA(0, 18, 107, 1)

Height: =40

Icon: =Icon.Reset

OnSelect: |-

=Set(varReset, true);

Set(varReset, false);

Width: =38

X: =747

Y: =57