When I attempt to use some of my connected data sources in the Remove or Patch function, I get an error that "the first argument of a Remove should be a collection". I am trying to use a valid SQL table that is connected to the app and works fine as a data source for galleries and data tables in the same app.
But when I begin to type the Remove or Patch formula, and the drop-down appears with a listing of available data sources, it only includes a subset of the SQL tables I have connected to the app. When I manually type one of the other table names into the formula, I get the error about needing a collection. How can I fix this? I tried deleting the data source and adding it back but that didn't help.

Report
All responses (
Answers (