Datatable displaying wrong data

[MortenBak]

Hello everyone,

I'm trying to have a datatable display certain columns in a Sharepoint list, and it displays data that belongs in those columns, but for a different record.

I've already tried with a Gallery1.Selected, and the column "children" having ThisItem.<Column name I want displayed>, and here is no data shown.

I've since then tried with

Search(<Datasource>; Gallery1.Selected.Title; "Title")

And this is where it wants to display some data, but it's belonging to the wrong record.

Any help is much appreciated! 

[MortenBak]

Hello Qi,

I get the "No data was found at this moment" error.

Could it be because I have multiple records that use the same Title? I've made my Patch so it uses the Customers Name in the Title column, and then it goes and displays logins in the following columns

[v-qiaqi-msft]

Hi @MortenBak，

To tell you the truth, no sample data, no words.

Here is I imagine of the customer list:

Title	Dept
Customer1	HR
Customer2	IT

Here is I imagine of the Login list:

Title	Login
Customer1	A
Customer1	B
Customer2	C

If you have the same Title with multi records, you could always display multi records in the DataTable based on Gallery selected.

Not sure if I get what you want to express.

[MortenBak]

Hello Qi,

It's the actual data I'm sitting with, so the list is already populated with a bunch of data. 

ListA boiled down looks like this:

CustomerNameA	NAV/BC Version	HowToConnect	Other Information
CustomerNameB	NAV/BC Version	HowToConnect	Other Information

And ListB looks like this: 

CustomerNameA	Username	Password
CustomerNameB	Username	Password

I can get it to display data when I set the Items property to simply <LoginListName>, but then it obviously displays every login to every customer.

[v-qiaqi-msft · Accepted solution]

Hi @MortenBak,

Have you checked the previous reply I posted a moment ago?

I am confused that if you have tried the Search() function, how could the DataTable not display the correct records corresponding to the Gallery selected customer.

[MortenBak]

Hello Qi,

I have checked it out, tested out the syntax as well, and I still get the error.
You're not alone in being confused, I am as well. That's what lead me to make the post in the first place. 
Thank you very much for trying though! 🙂 

[v-qiaqi-msft]

Hi @MortenBak,

Ahahahaha😂, I don't give up, let's investigate it.

You mean the error, "No data was found at this moment"?

Add a lable, and set its Text property as Gallery.Selected.Title, check if it could display the correct Title from the List A.

In addition, check the fields of the DataTable to make sure you have added the correct fields from the List B.

Could you please hover the mouse cursor shining behind the whole Search() function to see if there is a filtered table as below: 

Sorry I am going to be out of my office, just leave message if there is anything updates on your issue.

I will follow up on time tomorrow morning.

Good luck.

[MortenBak]

Hello Qi,

Good to hear! 

Yes, that's the error I'm talking about, it was a rough translation of the error message.

The way the app is set up, is you start out at a gallery, where you select the customer you want to look at, then it takes you to another screen. All the information is actually already displayed by labels, and they change just fine.

The fields I've set in the datatable is the UserName, Password, and a remarks column, so they are all okay.

Last but not least, when I hover over the function, there is no errors, just a delegationwarning on the "Title", it looks like the one you have pictured.

[v-qiaqi-msft]

Hi @MortenBak,

Morning.

How many records existing in your list B, more than 500 or 2000?

Could this be a delegation issue?

If the records in your List B are more than 500 but less than 2000, we could go to settings and change the limit to 2000.

In addition, you mentioned once you select a user in the Gallery, it will navigate you to another screen, could you make sure that Gallery.Selected has successfully been passed to the screen where the DataTable control exists?

Or we could do an experiment to test if this is a standalone issue.

1). Create two collections just like the list A and list B

2). Add a Gallery to populate with the list A and add a DataTable in another screen populated with the Search() function

3). Make sure both of the collections have 3-4 records

If the above experiment display as you expect, then I think your issue is a delegation issue.

[MortenBak]

Goodmorning Qi,

I only have ~70 entries, so delegation wont be an issue for a while. Good thinking though.

I believe the gallery.selected gets passed over, since all the labels displaying customer info changes every time i select a new customer. 

I tried setting a variable with the customers name, and now the first entry pops up in the datatable, so I'm going to spend some time today playing with that, and see if I can't get some more data out into the datatable, somehow.

[v-qiaqi-msft]

Hi @MortenBak,

Could you please show me a screenshot about your data table, remember to hide some private info.

I am so curious that how could the DataTable not display records based on the selected Title from the Gallery.

What about the Filter() function?

Filter(LoginList,Title=Gallery1.Selected.Title)

Some screenshots could be great if it is convenient for you