So I have about 70 tables ... 69 of them have moved perfectly from Implmentation v1.0 to Implementation v2.0.
Except one table refuses to transition ... I've tried going into the Advanced Editor and changing the Source same as I have the others, but that failed. Then I tried to just connect to it by starting new ... Get Data ... and still get the same message!!
Exceedingly annoying as I've just managed to finish transitioning the other 69 tables ... and this one only has 1500 rows and nothing particularly complicated in the list ... its just an invoice list ... BUT ... it has about 9 Lookups and 4 People lookups.
I can't compromise on the Lookups - they're all required ... so if this is the problem, how do I get around the problem, and why doesn't Implementation v1.0 fail? ALSO, I can't do a default view, because this is used by a team of admin staff on a daily basis.
DataSource.Error: Web.Contents failed to get contents from 'https://xxxxxxxxx.sharepoint.com/sites/MySite/_api/Web/Lists(guid'be8164a0-45e1-4cc8-919b-e09c25d9bf...' (500): Internal Server Error
Details:
DataSourceKind=SharePoint
DataSourcePath=https://xxxxxxxxx.sharepoint.com/sites/MySite
Url=https://xxxxxxxxx.sharepoint.com/sites/MySite/_api/Web/Lists(guid'be8164a0-45e1-4cc8-919b-e09c25d9bf...
LIST SETTINGS HERE ...
Cost Type (ND) Lookup
Cost Category Lookup
Project Lookup
Org-Div Lookup
Work Order Lookup
Invoice Status Lookup
Invoice Number Single line of text
Invoice Headline Single line of text
Period Start Date and Time
Period End Date and Time
Invoice Date Date and Time
Received Date Date and Time
Due Date Date and Time
FinYear Date Date and Time
Vendor Lookup
Services Description Multiple lines of text
Account Number Single line of text
Net Amount Number
Currency Lookup
Exchange Rate Number
GST Applicable Yes/No
Net AU$ Calculated (calculation based on other columns)
GST AU$ Calculated (calculation based on other columns)
Gross AU$ Calculated (calculation based on other columns)
% Split Number
Split Net AU$ Calculated (calculation based on other columns)
Split Gross AU$ Calculated (calculation based on other columns)
Endorsed by Person or Group
Approved by Person or Group
Comments Multiple lines of text
Paid Date Date and Time
Payment Method Choice
Credit Card Owner Person or Group
Override GL Code Single line of text
Dept Code Single line of text
Action Required Yes/No
Invoice Link Hyperlink or Picture
Cost Category: Opex GL Code Lookup
Cost Category: Capex GL Code Lookup
Project:ID Lookup
Modified Date and Time
Created Date and Time
Created By Person or Group
Modified By Person or Group
