Gallery not showing the Collection table

Like (1) Share

Report

Posted on 5 Jul 2024 03:18:38 by Seth18

117

Hello Everyone!

Currently, I am building the company expense claim app where I have 2 screens. Screen 1 is for just the basic information and screen 2 is the detailed information. On screen 2 there a save button where i want the user to click on the button first then it will store in collection table so that they can view or edit before clicking submit to submit those requests to the SharePoint list. The code for the onselect property of the button is like this:

Collect(Information, {CategoryGroup: DataCardValue69.Selected.Value,

CategoryName: DataCardValue70.Selected.Value,

InvoiceDate: DataCardValue74.SelectedDate,

InvoiceName: DataCardValue57.Text,

TypeOfClaim: DataCardValue78.Selected.Value,

Amount: DataCardValue45.Text,

Description: DataCardValue50.Text,

GLLocalAccount: DataCardValue53.Text,

'BU/GLAccount': DataCardValue46.Text,

TotalKM: DataCardValue64.Text,

Vehicle: DataCardValue79.Selected.Value,

RateOfKM: DataCardValue59.Text,

AllowanceType: DataCardValue68.Selected.Value,

Country: DataCardValue49.Text,

GoogleMapURL: DataCardValue54.Text,

StandbyFrom: DataCardValue75.SelectedDate,

StandbyTo: DataCardValue76.SelectedDate,

StandbyInHours: DataCardValue61.Text,

From: DataCardValue72.SelectedDate,

To: DataCardValue77.SelectedDate,

RateOfAllowance: DataCardValue58.Text,

TotalStandbyAllowance: DataCardValue65.Text,

InternalPersonInvolved: DataCardValue73.Selected.DisplayName,

ExternalPersonInvolved: DataCardValue71.Selected.DisplayName,

CreatedBy: User().Email})

and for the gallery on the left i want it to show the user request queue when they clicked save button above. But somehow it not showing the data on the right when i tested submit it just said no item to display. How can i make sure that when the user click on their request on the left when they saved it will also appear the collection table? How can i make the gallery to show that information? And how can i also make it editable for user before they submit the form to the SharePoint as well? I’ve been struggling on this.

Categories:

Connectors

Connecting to Data

General Questions

All responses (14)

Answers (0)

Seth18 117 on 05 Jul 2024 at 15:18:11

Like (1)

Report

Re: Gallery not showing the Collection table

This is what is in the datasource property. It all the sharepoint that i will be working on.
Michael E. Gernaey 41,193 Super User 2025 Season 1 on 05 Jul 2024 at 13:34:51

Like (1)

Report

Re: Gallery not showing the Collection table

What is in the DataSource property show that
Seth18 117 on 05 Jul 2024 at 12:41:46

Like (1)

Report

Re: Gallery not showing the Collection table

Hi @FLMike
It seems we might have a miscommunication somewhere let restart. Based on my screenshot above what i mean is that in the item property that you have mentioned to put Gallery4.Selected i did do the same as that but it error as the image below.
Michael E. Gernaey 41,193 Super User 2025 Season 1 on 05 Jul 2024 at 05:27:33

Like (1)

Report

Re: Gallery not showing the Collection table

I don't know what you are doing. I said just put Gallery4.Selected in the Item property not the datasource property.

Oye.. sorry man I gotta hit the bed you are leaving out so much information and i cant seem to get it from you.

I will say it again. You must set the DataSource, of the Form, to be something that has the data in it, that you want.

Then the item property will the Query OR Record that you want to display.

Do you want to Display the Data thats in the Collection? If so, then in the DataSource, put the Collection name and put the Gallery4.Selected in the ITem property and now you will see it.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Seth18 117 on 05 Jul 2024 at 05:20:08

Like (1)

Report

Re: Gallery not showing the Collection table

Hi @FLMike

Thank you so much for your clarification on this. As followed, it still require me for a datasource while the datasource would just be from the column of the form.
Michael E. Gernaey 41,193 Super User 2025 Season 1 on 05 Jul 2024 at 05:10:15

Like (1)

Report

Re: Gallery not showing the Collection table

Hi @Seth18

That is become your Item property is blank

for a Test set it to

GalleryName.Selected, where GalleryName is the name of your gallery, and make sure you select a row in the Gallery Don't click the arrow you have etc, just click the row.

As long as the Form has the Same datasource as the Gallery, it will load that data in it.

Thats why you dont see it, you haven't assigned any data to it.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Seth18 117 on 05 Jul 2024 at 05:08:01

Like (1)

Report

Re: Gallery not showing the Collection table

Hi @FLMike
Below is the item property of the gallery in which show the collection
while for the form as below does not have any data on it
And yes the gallery is setup to have multiple rows as long as the user click on the save button as there are different type of claims in which user can claim.
Michael E. Gernaey 41,193 Super User 2025 Season 1 on 05 Jul 2024 at 05:00:53

Like (1)

Report

Re: Gallery not showing the Collection table

Hi @Seth18

Please provide the other questions, show me the Items Property of the Gallery itself and the Form.

If the Gallery is selected (which I don't see anything selected), so I cannot tell what you selected. I am guessing those Arrows you have on each Row, is supposed to make it display that record on the Form???

Validate the code in the Arrow

Also, on the Form, please Check the DataSource and the Item property. Because thats the only things left to look at.

Please copy an image of the datasource and Item property please of the form. thanks

I see that you have 2 rows in the Gallery, not 1. Is the gallery setup to have multiple rows? If so I would expect to see them all, I see none.
Seth18 117 on 05 Jul 2024 at 04:52:04

Like (1)

Report

Re: Gallery not showing the Collection table

okay my bad on this but on the problem as above how can we fix it or make it display? Since the Gallery Items property are populated with the proper Collection already yet it not showing!
Michael E. Gernaey 41,193 Super User 2025 Season 1 on 05 Jul 2024 at 04:48:20

Like (1)

Report

Re: Gallery not showing the Collection table

The steps I gave you are not for Desktop its for web.. why do you think its on desktop?

Please go do the steps and come back with the answers.