Dear Microsoft Team

Question

I created on project list in site content that content the several hundreds contracts in a column,I want use the this column link to another table call service management. 

Since I used lookup (looking values already in another column) in service management table to create a new item regards to this contact, It drop-down all records, so I cannot find the one I want to pick it up. It does not support prediction to narrow down the item I want to looking for to fill in new item in service management table.

Please advise me how can I solve my issue?

Thank you so much,

Dang Tran

Answer 1

Hi Dang,

Sorry for your invonvenience and I’ll help you solve this.

According to your description, I have tested on my side, here are the steps and results:

1. I created a new list with a column in the site content, and I added some items to the column.
2. Then I went to Access > created a new database > External Data > New data Source > From Online Services > SharePoint List
3. I select “Link to the data source by creating a linked table” and linked the test list.
4. All the items I added in SharePoint are displayed in the newly created table.
5. Then I added a new column “Lookup & Relationship” > selected “I want the lookup field to get the values from another table or query”
6. Its drop-down box did show all the items I added.
7. Whether the items I added from SharePoint or Access, when I refreshed it, all items, including the newly added ones, can be found.

Please try refreshing the table and the site after adding items, you can check if there are any differences based on my operation.

If the problem is still not resolved or the above steps are not applicable to you, please provide detailed steps and screenshots.

PS: Please note to mark or remove all private information in your screenshots.

In addition, I noticed that there are hundreds of items in your list. The items you can't find are those that existed before or are added later?

Please provide the above information and I will help you further.

Hope the above information can help you and look forward to your feedback.

Regards,

Arck

Dear Arck,

Thank you so much for helping me.

I am sorry since i was too rush in describing problem that became not clear for you.

I did solve it through customize with PowerApps by generate form with Edit mutiselect instead of view multiselect, now i can easily find the item i am looking for.

Sincerely,

Dang

Answer 2

Hi Dang,

I’m so glad that you solved the problem by your own, we're always happy to help you anyway.

Thank you again for choosing to come to this community, if you have any questions in the future, please feel free to come back again for help.

Have a nice day!

Regards,

Arck

Answer 3

Hi Dang,

Sorry for your invonvenience and I’ll help you solve this.

According to your description, I have tested on my side, here are the steps and results:

1. I created a new list with a column in the site content, and I added some items to the column.
2. Then I went to Access > created a new database > External Data > New data Source > From Online Services > SharePoint List
3. I select “Link to the data source by creating a linked table” and linked the test list.
4. All the items I added in SharePoint are displayed in the newly created table.
5. Then I added a new column “Lookup & Relationship” > selected “I want the lookup field to get the values from another table or query”
6. Its drop-down box did show all the items I added.
7. Whether the items I added from SharePoint or Access, when I refreshed it, all items, including the newly added ones, can be found.

Please try refreshing the table and the site after adding items, you can check if there are any differences based on my operation.

If the problem is still not resolved or the above steps are not applicable to you, please provide detailed steps and screenshots.

PS: Please note to mark or remove all private information in your screenshots.

In addition, I noticed that there are hundreds of items in your list. The items you can't find are those that existed before or are added later?

Please provide the above information and I will help you further.

Hope the above information can help you and look forward to your feedback.

Regards,

Arck