Answered

Select All checkbox

(0) Share

Report

Posted on by amyharkus86

726

I have a gallery that lists all the items, this can be filtered by date created with to and from range and then exported to CSV, At the moment the user need to tick each checkbox, but I'd like to add a select all button that would only select those visible from the filtered option.

Gallery Items

Sort(Filter(
 colDWB,
 (Due_x0020_Date >= DatePicker1.SelectedDate) && (Due_x0020_Date <= DatePicker2.SelectedDate)), ID, Descending)

Refresh button - OnSelect

ClearCollect(colDWB, AddColumns('Dont Walk By', "IsChosen", false))

Export to CSV button

Set(varDrop, DropColumns(Filter(colDWB, IsChosen), "Author", "Assigned_x0020_to", "Category", "Editor", "Manager", "Priority", "joim" , "{Thumbnail}", "Related_x0020_Issues"));
Set(varFormattedJSON, JSON(varDrop, JSONFormat.IndentFour)); 


ExportToCSV_Email.Run(varFormattedJSON)

OnCheck on checkbox

Patch(colDWB, ThisItem, {IsChosen: true})

OnUncheck of checkbox

Patch(colDWB, ThisItem, {IsChosen: false})

This works great each item that ticked can then be exported, but id like to add a select all option

Not sure who to do this without removing my already working and required export function.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

if you want to export all the filtered results currently displayed in the gallery, why to add extra effort to use a select all checkbox? I think, in that case, you can just add the code in your Export to CSV button along with a condition to export the items displayed in the gallery (you already have code for export).

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!
@JamesYumnam The filter is used to date range a month or whatever but not always is every item in that filtered needed to be exported, for example if the status is closed we wouldn't need to export the item, althogh in my example above all items would be, within the filtered month there could be 20 items but only 10 of those would need to be exported.

In regards to adding a filter on the export button

Set(varDrop, DropColumns(Filter(colDWB, IsChosen), "Author", "Assigned_x0020_to", "Category", "Editor", "Manager", "Priority", "joim" , "{Thumbnail}", "Related_x0020_Issues")); Set(varFormattedJSON, JSON(varDrop, JSONFormat.IndentFour)); ExportToCSV_Email.Run(varFormattedJSON)

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!
sorry that was suppose to say , could i do this?
if i just wanted to export the filtered month?

Set(varDrop, DropColumns(Filter(colDWB, Due_x0020_Date >= DatePicker1_1.SelectedDate && Due_x0020_Date <= DatePicker2_1.SelectedDate ), "Author", "Assigned_x0020_to", "Category", "Editor", "Manager", "Priority", "joim" , "{Thumbnail}", "Related_x0020_Issues")); Set(varFormattedJSON, JSON(varDrop, JSONFormat.IndentFour)); ExportToCSV_Email.Run(varFormattedJSON)

Was this reply helpful? Yes No
Verified answer

JamesYumnam on at

Like (0)

Report
Copy link

Link copied!
@amyharkus86 if i understand correctly, your gallery has the result after applying certain filters.
and with this result, you have got two requirements:
to be able to export selected items from the gallery
to be able to export all the items in the gallery (because those are filtered already).
Now, your requirement 1 is fulfilled as you are able to select few items and then export them.
for requirement 2, you just need to export all the items in the gallery in the following manner.
In Export to CSV button, use an If condition.
If the count of selected items in the gallery > 0,
then export selected items only from the gallery.
else, export all the items in the gallery.
Please let me know if got your requirements correctly, then i may be able to help you out.

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!
@JamesYumnam thankyou for your reply, after discussing further with the department this is for its been decided that they wish to export all items in a view, so i have done as you suggested and export based on the filter, no need for tick boxes

Set(varDrop, DropColumns(Filter(colDWB, Due_x0020_Date >= DatePicker1_1.SelectedDate && Due_x0020_Date <= DatePicker2_1.SelectedDate ), "Author", "Assigned_x0020_to", "Category", "Editor", "Manager", "Priority", "joim" , "{Thumbnail}", "Related_x0020_Issues")); Set(varFormattedJSON, JSON(varDrop, JSONFormat.IndentFour)); ExportToCSV_Email.Run(varFormattedJSON)

Was this reply helpful? Yes No