
Announcements
Hello
I have an excel online table hosted on Sharepoint. I have a button that when pressed updates this table based on a collection.
This works fine for me when the table is hosted on onedrive, but when hosted on sharepoint I get the following message:
“Incompatible type. The column in the data source you’re expecting expects a text type and you’re using a number type.”
I have ensured the column is a number type and the message still appears.
Please can anyone explain why it is not working in Sharepoint as it works fine in Onedrive.
Thanks
Hi @SG1990-2
Unfortunately, the Excel Online Business connector doesn't support numeric data types. I have a post in the ideas forum that you can vote for here.