Unanswered

Trouble Adding a Column to a Collection with a SharePoint Online List datasource

(0) Share

Report

Posted on by boom_powerapps

101

I created a gallery using Database A that contained one column called Employee Name. In the gallery, I then manually a column that performs a count of how many times the Employee name is found in database B.

Example:

Sally Jo 8

Billy John 10

David Joseph 12

Whenever I add a chart to my PowerApps and use the gallery as the data source, my number column is never available as an option.

Then, I tried to create a collection, but I kept getting errors:

Collect(SVMLeadChartData, AddColumns(SVMLeadChart.AllItems, "Total", Value(SVMLeadCount.Text) ) ) - For Total, I get the Expected Identifier Name error.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @boom_powerapps ,

Please try to use

AddColumns(SVMLeadChart.AllItems, Total, Value(SVMLeadCount.Text) )

instead of using

AddColumns(SVMLeadChart.AllItems, "Total", Value(SVMLeadCount.Text) )

Best Regards,

Wearsky
Cat Schneider 488 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
How did you add the count value to the records of the Gallery exactly? Is it in the Items property? Or is it with a control like a label that's doing a row count?

The easiest way to do this would most likely be to use the AddColumns() function with the CountIf() function...

You can either do so with a Collection or directly in the Gallery Items property, but it would look something like:
AddColumns( DataSourceA As a, countFromB, CountIf( DataSourceB As b, a.Name = b.EmployeeName ) )

Let me know if that helps, or if you are still encountering issues.
boom_powerapps 101 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft This worked perfectly!!

I created a button with the following code:

Collect(SVMLeadTracker, AddColumns(SVMLeadChart.AllItems, Total, Value(SVMLeadCount.Text) ,
SVMLead, SVMTeamMember.Text & " " & Value(SVMLeadCount.Text) ) );

//Create Row for Dummy User
ClearCollect(SVMLeadDummy,
{SVMLead: "No SVM Leads" & " " & CountIf(SVMRequests, IsBlank('SVM Lead')),
Total: CountIf(SVMRequests, IsBlank('SVM Lead'))}
);

//Insert new dummy row
ClearCollect(SVMLeadTracker2, SVMLeadTracker);
Collect(SVMLeadTracker2, SVMLeadDummy);
Set(ShowSVMLeadChartContainer, true)

The code works perfectly in the portal studio (below).

But when I publish the app, the FIRST time users click on the button that displays the graph, they see this (below):

When the user closes the graph and then opens it again, the information is displayed correctly.

The number 42 is a total for one person; each other person has their own totals as shown in the first screenshot. Any idea how to make sure the collection is run correctly outside of the app studio the first time?
MalryTech 79 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm facing the same "Expected identifier name" error. Here is my code:

App, OnStart:
ClearCollect(
ActiveContacts,
Filter(Contacts, Active = true)
);

ClearCollect(
FinalFilteredContacts,
Filter(
ActiveContacts,
!IsBlank('Mailing Street') && NewWorksite = galWorksites.Selected.'SF ID 18'
)
);

Items: AddColumns(FinalFilteredContacts, "FullAddr", 'Mailing Street' & ", " & 'Mailing City' & ", CA " & Zip5)

ItemsAddress: "FullAddr" --obviously this part isn't working yet.

Please advise. Thanks.
MalryTech 79 on at

Like
a
(1)

Report
Copy link

Link copied!

My apologies. I found an article which pointed out you do not need double quotes anymore when doing AddColumns.