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 |
---|---|
43 | |
26 | |
23 | |
14 | |
12 |