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
Just double checking⦠which column do you have set as the role in the User Profile general settings?
Iāve successfully set the RowID as role so Iām wondering if there is a bug I donāt see or if there is something in your app that needs attention.
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.