When an empty SharePoint list is used as a data source, it fails with the message
Expression.Error: The column 'ID' of the table wasn't found.
Details:
ID
This issue seems tied to the age of the SharePoint list. I created a new list by copying an existing list and it fails on the navigation step (when you choose the table). I get the error immediately when I select the list name.
However, when I create a new blank SharePoint list, I don't have the problem.
If someone could please let me know how we could change the old list to make it work, that would be wonderful. I really don't want to spend hours recreating every list and I don't want to disrupt ongoing activities.
3 Comments
Hi Taryn
What if it's an the old list with data ? Do you get an error reported when you connect to that list?
Best Regards,
Community Support Team _ Ailsa TaoHi @v-yetao1-msft,
An old list with data loads fine. It's just the empty list that fails.
I am facing same issue after updating data into Sharepoint list.
