PowerApps Cascading Dropdown using SharePoint columns for data, not working

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.



View Reddit by PlummyrView Source

Leave a Reply

Your email address will not be published. Required fields are marked *