Hi guys, i'm trying to pull a value on an action based on the UserEmail trick posted by @MultiTech.
Besides the Users Table, this action is based on other two tables (Orders and Drivers) and its a grouped action that (images bellow:
I tried this formula:
LOOKUP(ANY(Users[UserEmail]),"Drivers","Email","Driver ID")
When i run the action the form view opens without the Driver ID filled. I tried other approaches but without success.
Does anybody know what is going on? I'm desperate 🤣🤣
Solved! Go to Solution.
Your expression looks fine to me. Whenever an expression seemingly isn't working how you think it should, break it apart into smaller sections and test them within appropriate contexts however you can. For example, try to run the ANY(Users[UserEmail]) by itself in the same context, and make sure it returns what you expect it to.
Try
LOOKUP(USEREMAIL(),"Drivers","Email","Driver ID")
Your expression looks fine to me. Whenever an expression seemingly isn't working how you think it should, break it apart into smaller sections and test them within appropriate contexts however you can. For example, try to run the ANY(Users[UserEmail]) by itself in the same context, and make sure it returns what you expect it to.
Hey guys. I figure out what was happening, the specific user i was testing wasn't invited 🙃
Thank u all guys. Everything is working fine
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |