Power Platform Community Forum Thread Details

Export Gallery Data to CSV (item limit issue)

Hi all,

I'm a bit of newbie to Power Apps, so am hoping someone can help me resolve an issue I'm having.

I have an app that includes a gallery linked to a SharePoint list data source. The SP list currently contains around 400 items, but will eventually contain approximately 5000 items.

I have an 'Export to CSV' button on my gallery page to allow users to export either the full data set, or a filtered view of the data (by utilising search and filter controls on the gallery). The export is working fine, but I can't get it to export more than 100 items. I understand the gallery only displays the first 100 items from the list, until you scroll to show more items. I can't expect users to understand that they need to do that before exporting though, so need to find a way of making the export include more than 100 items.

I've attached the code from the OnSelect property of my 'Export to CSV' button. If anyone can help me tweak it to allow exports of more than 100 items, that would be great.

// Create a collection of the required columns
Clear(col_galleryData);
ForAll(
    'Name of Gallery'.AllItems As galData,
    Collect(
        col_galleryData,
        {
            Name: galData.activityName,
            Organiser: galData.activityOrganiser,
            Description: galData.briefDescription,
            Frequency: galData.dataSubmissionFrequency.Value,
            Attendee: galData.colleagueName.DisplayName,
            Email: galData.colleagueEmail,
            Division: galData.colleagueDivision.Value,
            BusinessUnit: galData.colleagueBusinessUnit,
            OtherColleaguesInvolved: Concat(galData.otherColleaguesInvolved,DisplayName, ", "), 
            CompetitionTeamApproval: galData.competitionTeamApproval.Value,
            StartDate: galData.firstSubmissionDate,
            EndDate: galData.benchmarkingEndDate,
            ActivityInactive: galData.benchmarkingInactive.Value,
            GuidelinesReviewed: galData.guidelinesAwareness
        }
    )
);

//Set JSON file
Set(
    _JSONFile,
    JSON(col_galleryData,JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes)
);

//Show notification
Notify("Export process started.",NotificationType.Success);

//Launch Power Automate flow
Launch(
'BenchmarkingActivityRegister-Flow4'.Run(
    _JSONFile,
    $"{User().FullName}{Now()}.csv").sharepointfilelink
);

Categories:

Using Apps Using Formulas

Quick Links