You’re offline. This is a read only version of the page.
Hello,
One doubts over here. I am using 2 data verse table.
1.Vendor Table
| Current Approver | Next Approver |
| 1 | 2 |
| 2 | 3 |
2. Approver Table
| Level | Approver Email |
| 2 | abc@outlook.com |
| 3 | xyz@outlook.com |
Here, keep some points in mind.
NextApprover = CurrentLoginUser/User()
So I want to filter records based on current login user in my gallery[datasource I am using for gallery is vendor table].
How can I achieve this functionality using this 2 tables?
Thanks in Advance!
Hi @__Bansari
It's preferable to have relationships between tables and usually with good database design this can be achieved, but if that is not possible, then you can assign records in the first table to variables and then use those variables as part of a Lookup function to the seond table
Here is my recent blog post that explains how to do this: https://hiredgun.tech/assigning-dataverse-records-to-variables/
@ChrisHarper Thank you for your time.
But we can not make next approver as a lookup column. Next Approver field value update automatically based on previous approver approval.
Hi @__Bansari
Have you created any relationships between the 2 dataverse tables?
Making the 'Vendor Table'.'Next Approver' column a Lookup column (many to one relationship) to the Approver table will make filtering straightforward
Once you have the relationship, to get the Email address you would use:
Filter(Vendor,'Next Approver'=User()).'Approver Email'
I hope that helps
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (