I am connected to an Access Webapp as an SQL Server data source (Access is set to allow read/write etc). In access I have a table setup with "hole types" recorded and in the main "holes" table the "hole type" is set to lookup the "hole types" table values.
But in Powerapps no Allowed Values are shown and I have the error shown in the screenshot below:
I am new to powerapps and totally stumped, any help would be much appreciated, thanks.