Access web app & Sharepoint online list: lookup fields not showing up in list views

Question

Hi,

I have started a simple web app that contains three tables:

1- tblStates, with two fields: StateID & StateName

2- Active Users, which is a linked table to a sharepoint online list 

3- tblLink , containing three fields that "link" the aforementioned tables as follows:

- LinkID
- State: lookup to tblStates
- User: lookup to "Active users" 

I can see the contents of the table linked to the sharepoint list through its views and the lookup works well. But once I have entered the data, the field coming from the sharepoint list does not show up in the tblLinks list view. If I use a regular table instead of a linked one everything works as expected. 

Please let me know if I am missing something.

Thanks!

O.

Answer 1

Hi O,

>> But once I have entered the data, the field coming from the sharepoint list does not show up in the tblLinks list view

What do you mean by this? Where did you enter the data? I made a test based on your description, and it works at my side. If I enter a new data in the list in the SharePoint site, I could see the new data in dropdown of LookUp filed in tbllink list view.

It would be helpful if you could share us more detailed steps that you got wrong behavior, a screen shot about your issue would be much helpful.

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Hi,

I am trying to post some screenshots but I get the following error:

"body text cannot contain images or links until we are able to verify your account"

I am trying to sort this out so that I can attach screenshots.

Thanks for your help.

O.

 

Answer 3

Hi O,

I think you could upload your screen shot to OneDrive and share us link here by removing "http".

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Hi,

My account has just been verified. I will try to be more precise. I attach a few screenshots about my database. Here goes the structure with the 3 tables: 

This is the structure of the tblState:

And this is the structure of the tblLink:

The "User" lookup field points to the linked sharepoint list and the "State" lookup field points to the tblState. I launch then the access web app and through the browser I enter some records using the tblList default List view. Everything works well (I can use the lookups to choose the values for both fields) but after saving the record the value for the "User" fields simply does not show up in the tbLink list view (there are blanks instead):

To troubleshoot the issue I have tried linking to different sharepoint lists with the same result. On the other hand, if I use a "native" web app table for "Active Users" everything works as expected and the "User" field is displayed properly.

Thank you very much for your help.

O.

Answer 5

Hi O,

>> Everything works well (I can use the lookups to choose the values for both fields) but after saving the record the value for the "User" fields simply does not show up in the tbLink list view

I made a test, but it works at my side. Could you share us a screen shot about User Control like below:

Is this a test database? I am afraid it is difficult to narrow down this issue without reproducing issue. If possible, I would suggest you create a temple account and share us then we could try to make a test with your database.

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 6

Hi Edward,

Thanks for your reply. It is indeed a test database so I will check whether a temple account can be arranged. In the meantime I post a screen shot about the User Control:

By the way while in the list view the User field is displayed blank, in the Datasheet view I can see them:

Best regards,

O.

Answer 7

Hi O1992,

I could reproduce your issue with AutoComplete control, I assume it is an issue related with AutoComplete control and SharePoint list linked table.

As my previous test, the auto generated control is ComboBox and it works. I suggest you make a test with ComboBox, something like my previous image.

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 8

Hi Edward,

Using a ComboBox control instead of an Autocomplete one, as you suggested, takes care of the issue. That's great. The thing is that in my production environment there will be around 1k items to choose from so I am not sure a ComboBox control will be appropriate.

Thank you very much for your help,

O.

Answer 9

Hi,

>>The thing is that in my production environment there will be around 1k items to choose from so I am not sure a ComboBox control will be appropriate.

But, I am afraid there is no better way. Autocomplete control would not show the value. Or, I think you need to convert linked table to local table and use Autocomplete control.

For this issue, I would suggest you submit a feedback in the link below:

http://access.uservoice.com/

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 10

Hi,

I can't convert the linked table to local as I need it to be available from several access web apps. Beside using sharepoint lists, is there any other way to accomplish this?

In any case, thanks for you help.

Regards,

O.

 

Answer 11

Hi,

I have just noticed that using the Combo Box does not fix completely the issue. In the tblSTate list view the user fields are not being displayed (blanks again):

If I click on any of the records I can see then the Users value. 

Best regards,

O.

Answer 12

Hi O,

After checking this at my side, I could get the same result. I am afraid there is no any workaround to resolve this issue. It is more related with Access web app product, and I would suggest you submit a feedback.

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 13

Hi, 

Thanks for your help.

Regards.

Oriol