You’re offline. This is a read only version of the page.
Hi,
When using the Forall(Gal_session.Allitems, it doesn't seem to collect all that is there. There are about 22 rows for it to collect so the gallery can't show that many rows unless you start scrolling down. The problem that is happening is when hitting the submit button it only collet half the data, but if I scroll down and then hit the submit button it then collects the full set. I'm trying to prepare for just in case the user hits the submit button without scrolling down, making sure it collects all the data. Not sure if everyone else has had this problem.
My code is below. There is also an export at the bottom to transfer this data into an excel file, but I don't think that would be the issue since if i scroll down it collects the data fine.
Clear(colUsersession)
;
ForAll(
Gal_session.AllItems,
Collect(
colUsersession,
{
ID_Number: ID_number.Text,
Location: Location.Text,
Access_Clear: Access_clear.Selected.Value,
ID_TAG: ID_TAG.Selected.Value,
EW_Flow: EW_Flow.Selected.Value
}
)
);
ExporttoExcel.Run(JSON(colUsersession,JSONFormat.IgnoreBinaryData))
Hi I was able to figure the problem out. Looks like during the submit I need to have it selected all the rows and make sure it reads them before putting them into a collecting 🙂 There aren't many rows so its not even a performance hinder.
Gave this a try but only selects one row still. It needs to loop through all the rows in the gallery the Gallery.allitems is working just it's not grabbing all the data in the gallery section unless I scroll down. It just not putting all the data in the collection part. This is the data in an excel file i'm putting it in. It's grabbing all the way down for the first two rows just the other rows are not being captured unless I scroll down
I've tried this to see what result I would get but it only captures one row if I do this method. I'm needing it to capture all rows no
Clear(colUsersession)
;
Collect(
colUsersession,
{
ID_Number: ID_number.Text,
Location: Location_Sasol.Text,
Access_Clear: Access_clear.Selected.Value,
ID_TAG: ID_TAG.Selected.Value,
EW_Flow: EW_Flow.Selected.Value
}
);
Does this work?
I apologies, the ones with drop down boxes do have property values as well.
So, this is the values that would be for each name. I was looking at the wrong selection when clicking on them.
ID_Number: Thisitem.Title
Location_sasol: Thisitem.Location
Acess_Clear: Thisitem.Access_clear
ID_TAG: Thisitem.ID_TAG
EW_Flow: Thisitem.EW_Flow
Technically only two have item properties.
This data is being pulled from a List.
ID Number: ThisItem.Title
Location: ThisItem.Location
The rest of the boxes are drop down selected values as shown below.
Here is the properties forgot to post them
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (