Hi All,
I Uploaded an existing database from Access to Sharepoint using the wizzard built into Access.
All the lists from the database uploaded successfully, however the main part of the database cannot be edited in the online sharepoint page. when i click "+ New" or click on an item and then click "Edit" on the main list nothing happens. Has anyone got any idea why this is?
Some of the other smaller lists from the database have uploaded and these can be edited or i can creat new records, however on this particular list nothing happens.
When this list was a table on sharepoint, some of the fields were completed by using multiple dropdown boxes in order to filter the data and i'm begining to think that this could be the issue?
I have opened the list settings and checked the Type that is used for each column and they all seem to be OK, except a couple of the records which used data from other tables in access, but in my sharepoint list they are just listed as a "Single line of Text" type rather than a lookup? which i assume would be the correct type?
My issue is that when i click on edit column there doesnt seem to be an option to change the type of column to lookup? I can only change to Single line, multiple line, Choice, Number, Currency or Date and Time.
Is this error in column type likely to be the reason why i cant create a new record or Edit old records? if so, does anyone know how i can edit the columns to the right format? I have tried this using powerapps, but cant find anything n there either.
In fact in powerapps in the form designer i have linked most of the columns correctly to the data, but i'm then getting an error saying (Red circle with a cross in it) "This property expects text values, but this rule produces incompatible Control Values"
Any thoughts?
Please help!