Hey everyone, I just ran into an issue and hope that someone can help me.
This is the first project I'm doing with an onPremise SharePoint 2016 using the data gateway. As usual I add my connection and select the lists I need - no problems here.
I have a list which has 4 Choice-Columns (multiple selection allowed) and I can't add or select them anywhere in PowerApps. They are not showing up in the Forms (Add field), I also can't add them using the Custom Data Card option.
If I create a simple collection for the whole list, the fields are missing. I can't add them anywhere using "ListName"."ColumnName" as PowerApps tells me that there is no such column.
Then I tried creating a simple choice column (multiple selection NOT allowed) which shows up in PowerApps for selection.
Is there a know limitation caused by the OnPremise Data Gateway? Or is this a bug?
Looking through this, this definitely seems like some odd behavior. I don't see anything obvious that might be causing the issue. I would recommend creating a ticket with Microsoft Support to help take a look into this. Unless another communities member might know, feel free to pitch in. I'll include a link below; if you would like to go down that route.