Contents
Go into the List Settings and look at those columns. You will see the values for those drop down items. *Note I’m not sure what kind of list you are using and if there are content types involved with those columns.
If the Customer Name column is a Choice type column in your SP List, please type: Within the Screen2, set the Items property of the Gallery to following: If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How to use a drop down list in canvas?
When using such columns as a field in a canvas app, you can use a drop-down list with choices. To use the choices in a drop-down list, you have to use the function choices.
How can I use lookup columns in SharePoint?
You must have created an app using SharePoint connector that connects to a SharePoint list. The SharePoint list should consist of a lookup column with values from another column. You can use lookup columns in SharePoint that consume values from other lists or libraries.
When you have the SharePoint list open in Access and want to change multiple items in the same way, the quickest method is to run a query. Click on the Query Design button under the CREATE tab in the Access ribbon. Add the list table to the query.
Why is the dropdown box not showing in my list?
I have a list that has a dropdown box as one of its columns. We changed the values in the dropdown box and now some of the items in the list refuse to allow us to blank out that column (so it has no value), the dropdown box doesn’t show the blank value as an option and requires one of the items to be there.
How to delete the default SharePoint list item?
Close or delete the default table. Click on the More button under the EXTERNAL DATA tab in the ribbon and select SharePoint List. In the dialog that opens, paste or write in the path to the site that has the list you want to open in Access. Select the linked table option and click Next.