i want my app to show data only to those who are listed in my Users sheet list (check the image '2'), then i want it to show only the rows that contain the name of that user. i tries this but seems that my logique is wrong
Are you sure that your Users[Email] data type is Email?
After that you can use IN(USERMAIL(), Users[Email])
Hi @Mo396
Maybe you need to check if the USERMAIL is IN() the Users[Email] list.
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |