This is still an issue and no one from support is helping. They suggested I use another data source…
"You should be able to add data from One Drive sources, I am trying to contact one of our developers about this specific condition to see if we have a remedy on our end. "
Even after I explained I can only use SharePoint… and they left it at that. What?!
I find AppSheet support to be less that average in their attitude and best practices. They should have kept me up to date with what will happen with a set period of time: I’ll get back to you within 1 hour, I’ll have some else get in touch because I don’t know, because I’m going home… anything actually helpful.
Can anyone at AppSheet help since support seems as helpful as wet tissue on a rainy day in the this occasion.