Unanswered

Create a collection from gallery in powerapps

(0) Share

Report

Posted on by michael156

Hi. I'm really new to powerapps so could be doing something stupid!

I have a gallery called Projected_Balances_1 which contains text fields pulled from an excel sheet datasource, as well as 'projected balance' column that is a calculated number.

I want to add all the items in the gallery to a collection, which I can use with a power automate flow to download a CSV file.

In my app, I have a download button, with the onselect set to:

ForAll(Projected_Balances_1.AllItems,
Collect(CSVBalanceData, Projected_Balances_1.AllItems));

Set(ExportToCSVData,Concat(CSVBalanceData, ","&Char(10)));

//Call flow
Set(ResponseFromFlow,'PowerApp->Createfile,RespondtoaPowerApporflow'.Run(Text(varProvision)&"_Report_"&Text(varMonth)&"_"&Text(DateAdd(Now(),TimeZoneOffset(Now())))

,"Cost Code, Starting Budget, Projected Balance, Provision" & Char(10) &ExportToCSVData

));

What I can see though, is Projected_Balances_1.AllItems and CSVBalanceData coming back as a table of [control], and then ExportToCSVData is just a text of ',,,,,,,,,,,,,,,,'.

When the CSV file downloads, it just has the headers in there "Cost Code, Starting Budget, Projected Balance, Provision" without any other content.

Can anyone help work out what I'm doing wrong? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

SebS 4,603 Moderator on at

Like (0)

Report
You are using ForAll and basically You create a table in a Table
just use

Collect(CSVBalanceData, Projected_Balances_1.AllItems)

that will collect all

Was this reply helpful? Yes No
michael156 20 on at

Like (0)

Report

Thanks @SebS. I've changed the code now

Collect(CSVBalanceData, Projected_Balances_1.AllItems);
Set(ExportToCSVData,Concat(CSVBalanceData, ","&Char(10)));
//Call flow
Set(ResponseFromFlow,'PowerApp->Createfile,RespondtoaPowerApporflow'.Run(Text(varProvision)&"_Report_"&Text(varMonth)&"_"&Text(DateAdd(Now(),TimeZoneOffset(Now())))
,"Cost Code, Starting Budget, Projected Balance, Provision" & Char(10) &ExportToCSVData
));

But just getting the same result. ExportToCSData is just ,,,,,,,,,, with the CSV only containing the headers 🤔

Was this reply helpful? Yes No
michael156 20 on at

Like (0)

Report

Thanks @SebS. I've changed the code now

Collect(CSVBalanceData, Projected_Balances_1.AllItems);
Set(ExportToCSVData,Concat(CSVBalanceData, ","&Char(10)));
//Call flow
Set(ResponseFromFlow,'PowerApp->Createfile,RespondtoaPowerApporflow'.Run(Text(varProvision)&"_Report_"&Text(varMonth)&"_"&Text(DateAdd(Now(),TimeZoneOffset(Now())))
,"Cost Code, Starting Budget, Projected Balance, Provision" & Char(10) &ExportToCSVData
));

But just getting the same result. ExportToCSData is just ,,,,,,,,,, with the CSV only containing the headers 🤔

Was this reply helpful? Yes No
SebS 4,603 Moderator on at

Like (0)

Report

but what do you see in the collection now? is there a data

Was this reply helpful? Yes No
michael156 20 on at

Like (0)

Report

Its like it collects the cost centre column but everything else just shows [control]

Was this reply helpful? Yes No
SebS 4,603 Moderator on at

Like (0)

Report

@michael156

I'm not sure here it's looks like it's Your gallery or data what populate it create the issue, but I may be wrong.

What is the code You using to populate the gallery?

Was this reply helpful? Yes No
michael156 20 on at

Like (0)

Report

So it gets a bit complicated here...I have 12 excel tables (one per month) of budget information. I have a screen in the power app, which has onvisible set to:
ClearCollect(colFullYearData, April, May, June, July, August, September, October, November, December, January, February, March);
The gallery then is populated from
Distinct(Filter(colFullYearData, Provision = Text(varProvision)), 'Cost Code') with the fields selected for 'Cost Code' (which is the one column that looks to be right in the collection), as well as 'Provision' straight from the data source, but also 'Starting budget' and 'Projected Balance' which are calculations based on the datasource.

For starting budget, it just checks what month has been selected on the screen (varMonth) and then picks out a value.
If(varMonth = "April",
Text(Value(0.00 + LookUp(April, 'Cost Code' = ThisItem.Result && Provision = varProvision, Budget)) ,"£#,###.00"),

The one for Projected Balance remaining is a pretty massive formula but just takes the starting budget and subtracts values for different salary's in the datasource

The data is getting shown correct in the gallery, so I thought it was OK at that point.

Was this reply helpful? Yes No
michael156 20 on at

Like (1)

Report

After a lot of trial and error, changed the code to:
ClearCollect(GalleryItems,ShowColumns(AddColumns(Projected_Balances_1.AllItems,"Cost Code",CostCodeLabel_4.Text,"Starting Budget",StartingBudgetLbl_1.Text,"Projected Balance",CurrentMonthProjectedBalance.Text, "Provision",ProvisionLabel_3.Text),"Cost Code","Starting Budget","Projected Balance", "Provision"));
Set(ExportToCSVData, Concat(GalleryItems, 'Cost Code'&","&'Starting Budget'&","&'Projected Balance'&","&Provision&Char(10)));

Seems to be working now 🙂

Was this reply helpful? Yes No