Answered

Issue pulling collection data

(0) Share

Report

Posted on by lokdawg78

Hey all, I'm noticing some odd behavior when trying to pull info from a SharePoint list connected gallery into a collection. The SP list contains contacts. The columns are Employee ID, Last Name, First Name, Group, Status and Cell phone number. Right now there are only 72 rows. I'm trying to create collections based on whether or not a user is a Field employee or Office employee. Users check a checkbox and the oncheck is set to:

ForAll(Gallery_Contacts.AllItems, 
 If((TI_Group.Text = "Field"),
 Collect(FieldCellNumber, {Employee: TI_LastName.Text & ", " & TI_FirstName.Text, Cell: TI_Cell.Text })
 ))

The problem I am running into is that the Collection doesn't full populate. It seems to get part way through the gallery before it stops collecting data. There have been a few times where I was able to get it to fully populate after refreshing the data source several times, but that won't really fly when I want to publish this. Am I making a mistake in the Collect portion or should I be doing this some other way?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lokdawg78 ,

Could you tell me what is TI_Group?

Is it a group name or the check box for Field's name?

Actually, we not use Checkboxname.Text to justify whether a check box is checked. We use checkboxname.Value to check.

If the check box 's Value is true, then it is checked.

If the check box 's Value is false, then it is unchecked.

If TI_Group is the check box for Field's name, try this:

1)set Field check box's OnCheck:

ForAll(Gallery_Contacts.AllItems, If(TI_Group.Value, Collect(FieldCellNumber, {Employee: TI_LastName.Text & ", " & TI_FirstName.Text, Cell: TI_Cell.Text }) ))

2)set Office check box's OnCheck:

ForAll(Gallery_Contacts.AllItems, If(officecheckboxname.Value, Collect(OfficeCellNumber, {Employee: TI_LastName.Text & ", " & TI_FirstName.Text, Cell: TI_Cell.Text }) ))

What's more, the data in collection is just a kind of temporary data. It will clear all the data automatically every time you shut down the app.

You could set the app's OnStart to create collection every time you start the app.

Best regards,

Was this reply helpful? Yes No
Verified answer

lokdawg78 28 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the reply Phoebe. I was actually able to get it working by using Filter instead of ForAll. I have a gallery connected to a SharePoint list. The fields in the gallery are all text inputs for the SharePoint list columns.

What I ended up doing was Filtering the SharePoint list with the OnStart for the app and just leaving the gallery for patching/editing the SharePoint list.

ClearCollect(FieldCellNumber, ShowColumns( SortByColumns( Filter(Contacts, Group= "Field"), "Last_x0020_Name", Ascending ), "Last_x0020_Name", "First_x0020_Name", "Cell_x0023_", "Group" ) );

Was this reply helpful? Yes No