I used this in one of my Apps just this week for allocating multiple roles per user, and it works perfectly. It was the last thing I needed to start decoupling Google Sheets altogether from some of my Apps
I’m running into this error trying to display rows using multiple texts as row owners. List displays fine when not using multiple texts as row owners but displays this error when using it.
Until now I had always stayed clear from assigning multiple roles to a user because it required Google Sheets. Now I can definitely start working with these multiple role columns in the data editor and a loop in the workflow editor
Thank you for this report! We will log this as something that is incompatible as of now. To @Darren_Murphy’s point, I would have the Users hold multiple roles and then have multiple separate columns as row owners
Maybe it’s working. Try adding a column with values in your second table to see the results. I notice in my table, the RowID column is not highlighted (or highlighted less?), even though the user has access. Other columns are highlighted though.