How to filter items from a collection in a gallery with a checkbox?

[Gzabala]

Hi!

I am building an app that takes employees inputs, stores it on SharePoint, then there is a gallery that shows the information stored on SharePoint and on the Browsescreen1 there is a button connected to a flow that allows users to export the gallery to a CVS file.

I want to allow users to export a single record from the gallery and not all of them, I have included a Checkbox 1 on the gallery but I haven't found a way to get it to work.

This is the code on the export button: 

Clear(colEndUserOnboarding);

ForAll(

    BrowseGallery1.AllItems As GalData,

  Collect(

        colEndUserOnboarding,

        {

            Country: GalData.Country,

            City: GalData.City,

            'Name 1': GalData.'Name 1',

            'Search Term 1': GalData.'Search Term 1',

            'Street 1':GalData.'Street 1',

            'Country Key':GalData.'Country Key',

            Language:GalData.Language,

            Telephone:GalData.Telephone,

            'Name 2':GalData.'Name 2',

            'Search Term 2':GalData.'Search Term 2',

            'Street 2':GalData.'Street 2',

            State:GalData.State,

            'PO Box Postal Codel':GalData.'PO Box Postal Codel',

            'Train Station':GalData.'Train Station',

            'Contact Person':GalData.'Contact Person',

            'Old Customer Code':GalData.'Old Customer Code',

            'Customer Code':GalData.'Customer Code'

        }

    )

);

Set(

    JSONFile,

    JSON(

        colEndUserOnboarding,

        JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IncludeBinaryData

    )

);

Launch(

    EXPORT.Run(

        JSONFile,

        fileInput_Ctrl.Text

    ).sharepoint_file_link

)

This is the code on the Oncheck checkbox property: 

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

This is the code on the OnUncheck checkbox property:

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

[WasimS]

If you want to export only single record, then you can give a icon/button in gallery for each item to export that particular record. 

Formula to write on button/Icon OnSelect property 

Collect(COl_1,Gallery1.Selected);

Set(
    JSONFile,
    JSON(
        COl_1,
        JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IncludeBinaryData
    )
);
Launch(
    EXPORT.Run(
        JSONFile,
        fileInput_Ctrl.Text
    ).sharepoint_file_link
)

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks & Regards,

Wasim Shaikh

[Prabhakar_S]

Hi @Gzabala ,

To filter items from a collection in a gallery based on whether a checkbox is checked (chosen) by the user, you'll need to modify your approach slightly. The key is to update a property (e.g., "IsChosen") in each item of your collection when the user interacts with the checkbox. Then, when exporting, you can filter the collection based on this property to include only the chosen items.

Update Checkbox Interaction:
Make sure you have a checkbox (let's call it "Checkbox1") bound to a Boolean field (e.g., "IsChosen") in your data source. The Checked property of the checkbox should be bound to the IsChosen field of each item in the gallery.

- OnCheck Property of the checkbox:

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

- OnUncheck Property of the checkbox:

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

Export Button:
Modify your export button logic to filter the collection ('colEndUserOnboarding') based on the 'IsChosen' field before generating the CSV file.

Clear(colSelectedRecords);

ForAll(
Filter(colEndUserOnboarding, IsChosen = true),
Collect(
colSelectedRecords,
{
Country: Country,
City: City,
'Name 1': 'Name 1',
'Search Term 1': 'Search Term 1',
'Street 1': 'Street 1',
'Country Key': 'Country Key',
Language: Language,
Telephone: Telephone,
'Name 2': 'Name 2',
'Search Term 2': 'Search Term 2',
'Street 2': 'Street 2',
State: State,
'PO Box Postal Codel': 'PO Box Postal Codel',
'Train Station': 'Train Station',
'Contact Person': 'Contact Person',
'Old Customer Code': 'Old Customer Code',
'Customer Code': 'Customer Code'
}
)
);

Set(
JSONFile,
JSON(
colSelectedRecords,
JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IncludeBinaryData
)
);

Launch(
EXPORT.Run(
JSONFile,
fileInput_Ctrl.Text
).sharepoint_file_link
);

In the above code:
- We use the 'Filter' function to include only the records where 'IsChosen' is true.
- We then collect the filtered records into a new collection ('colSelectedRecords').
- The rest of your export logic remains unchanged, but now it operates on 'colSelectedRecords' instead of 'colEndUserOnboarding'.

Adjust the field names and collection names as per your actual data source and requirements.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Gzabala]

Thanks a lot for your comment. I have adapted the formula and included the filter function as mentioned on your message but now I'm getting multiple error messages: 

The checkboxes have been added in each item of the gallery with the

- OnCheck Property of the checkbox:

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

- OnUncheck Property of the checkbox:

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

Any leads where is the issue? much appreciated

[Prabhakar_S]

Hi @Gzabala,

Based on the information provided, it seems like the errors might be related to the column values in the formula used for collecting the data. 

1. Column Values in Collection:
Ensure that the column names and the equivalent column values used in the 'Collect' function match the actual column names and values in your data source 'colSelectedRecords'. 

2. Collection Creation and Patching:
Verify that the collection ('colEndUserOnboarding') is properly created and patched to the 'colEndUserOnboarding' collection. Ensure that the patching is done correctly to reflect the changes made by the checkbox interactions.

By addressing these points and ensuring consistency in the column names and values in collection handling, you should be able to resolve the errors you're encountering.

Adjust the field names and values in the collection as per your actual data source and requirements.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Gzabala]

Thank you I really appreciate it.

The problem I have is that the "IsChosen" is not recognized

I have set the OnCheck porperties to:

- OnCheck Property of the checkbox:

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

- OnUncheck Property of the checkbox:

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

[Prabhakar_S]

Hi @Gzabala ,

I see, if "IsChosen" is not recognized, it might be due to a couple of reasons,

Column Name Mismatch: Ensure that "IsChosen" is indeed the name of the column in your data source ('colEndUserOnboarding'). Double-check the spelling and capitalization to ensure consistency.

Data Source Refresh: If you recently added the "IsChosen" column to your data source, make sure to refresh the data source in PowerApps to reflect the changes.

Try the Collect function instead of Patch in the OnCheck and OnUncheck properties of the checkbox. 

- OnCheck Property of the checkbox:

Collect(colEndUserOnboarding, { ID: ThisItem.ID, IsChosen: true })

- OnUncheck Property of the checkbox:

Collect(colEndUserOnboarding, { ID: ThisItem.ID, IsChosen: false })

This way, you're collecting the updated item with the "IsChosen" property set to true or false directly into the "colEndUserOnboarding" collection. Make sure to include the "ID" field (or any other unique identifier) to uniquely identify the item being modified.

Feel free to give this a try and let me know if you have any further questions!

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Gzabala]

Hi Wasim, Thank you for your help but with this approach I'm still exporting the whole gallery. Any other way to go about it?