Create a list Lookup using site pages

‌ - 

Where are you getting the data to populate the page? 

I would recommend looking up the data from the source, not from the page. Unless the page is required for something else, it seems like an extra step. Data gets pulled into the page, and then you are attempting to pull it into a form. Just got straight to the source

Hope this helps!

Good day Jose,

In your Source list field you are pointing the list to look at the sitepages which will not work.  You have to point this lookup list to the list that is being displayed on the page.  Although you can see the department list on the department.aspx page, it is probably just a webpart added that is pointing to the real department list.  In the source list you should be selecting the department list.  

In the source view field you should specify only the view name that was created on the list...usually there is an all items but you can create your own view and use that but without the .aspx at the end. And finally I see that you specified the BaseDescription which is correct...just check the spelling...I'm still on Sharepoint 2010 and I have to have capitals where there are capitals and lower case where it is lower case and the actual column name seems to baseDescription.   

If you are still not coming right, please send us a screenshot of the all site content lists as well as the department list's settings. 

Let me know. 

Thanks for your response
To create a list of departments, I followed this example

https://www.codeproject.com/articles/673547/how-to-use-secure-store-service-in-an-external-con

Top Page: http://intra/phurchase/_layouts/15/start.aspx#/

Name of page: Department

URL of page: http://intra/phurchase/_Layouts/15/start.aspx#/SitePages/Department.aspx

Nome of Webpart:Departments_List

Good day Jose, 

This is still creating an external datalist on the page. In the example he is pulling in the Employee list on the employeedetail page. 

Where you are setting up your lookup droplist action to give a lost, you should specify the table on the page as the sourcelsit.  Open the department page and click on the heading of the department  list. This should open the list that you want to display in the source view list. 

Hi Jose,

Any luck with this?

I solved the problem by installing sharepoint server and created a list through sharepoint design using external content types