I am trying to build some cascading columns to build a more interactive data entry form on a SharePoint list.
All the videos I have seen and tried to replicate only error out. I am trying to pull my data from a SharePoint column, however, using below,
Items = Distinct(‘List’,Column)
in my dropdown box, I get a formula error that says “The property cannot consume the type of Tables that this rule produces, due to incompatible schemas”
What am I doing wrong? I need to keep this data in SharePoint and not pull the forms from excel, as I have to have the data entered appear in the SharePoint list.
Thanks for any help on this.