Bubble does not show 2nd Item in the list of Users

[Victorylaps]

Issue description (Latest Bubble version):

1. I have a data table called “users” which have all the users with First Name and email ID.
2. I have a data table called “conversations”. In that I have a column called “Participants”. This column is of type “users” and is a ‘list’. So I have two users in every record of this field (Example: naresh@gmail.com , crazy@gmail.com)
3. Now In a repeating group, I am trying to access First names of these two users. So I created a text box inside the repeating group and entered dynamic field like this “current cell’s conversation’s users:each item’s First Name”.
4. However, my output is coming as "Naresh, ". So the first name of the other user is blank. Why?
5. Irony is, when I do this “current cell’s conversation’s users:each item’s unique id”, I am getting two unique IDs as output (1691642678302x489805214277095400, 1691644039455x288243052176857540). Also when I do this "“current cell’s conversation’s users:count”, I am getting 2. So there are 2 users for sure, but First Name or any other attribute is coming as blank. I checked First Name in the Users database and it is not empty.

Update: What I understood is Bubble is taking only logged In user from the list. How do I fix it?

I created an app only for this issue. Here are the 5 steps I used:

Thank you!

[preagos]

What are you referring your text element ? Current cells conversion what exactly ?

[Victorylaps]

You can see on the left side of the image what exactly I am referring to. It is “current cell’s conversations’s Participants:each item’s First Name”. So it should get two names with a comma separator.

[preagos]

Oh sorry I didn’t see that image. To confirm that the second user is effectively In your database try the :last item instead of each item and tell me what you get

[mikeloc]

As with all issues like the one you are describing, it certainly can’t hurt to check your privacy rules. Do you have any rules in place on the User data type (maybe the default rule), and if so, are those rules getting in the way?

[preagos]

If you can only see the data of the logged in user then it has to do with your privacy rule on the User. To confirm that try removing first your privacy rule and test. If you can display all the data then it will confirm that it has to do with the privacy rules

[Victorylaps]

Awesome! Thanks @preagos and @mikeloc . It’s the issue with privacy rules. Wow! I have spent hours on this!

[preagos]

You’re welcome