Share
Report
2,339Hello,
I have a canvas app with SQL as the data source. One of the tables has columns with spaces in the names.
I built an app with a gallery that when selected, sets a variable like Set(variable,ThisItem) and elsewhere in the app I show text labels with the data by referencing the variable, such as variable.'customer name'
This was fine up until today. Now it looks like I have to change the formulas in the app to replace the spaces with _x0020_ like a SharePoint internal column name, e.g what was variable.'customer name' now throws an error "Name isn't valid. The identifier isn't recognized." and the correct reference is now variable.customer_x0020_name.
Why has this just suddenly happened? I removed and re-added the data source at some point but I can't remember whether it was before this issue occurred and caused it, or I did it to try and resolve the problem.
In any case it's going to be a lot of work to fix it, and how do I know it won't switch back at some point? Is there a setting I can use to force the connector to work one way or the other?
All responses (
Answers (
