Announcements
Hello everyone, can someone explain to me why this dropdown is not getting populated by the distinct approvers ("Approver Name")? Each row only has a single approver. I am getting the same issue with both of these formulas, the values are just showing as blank. Thanks!
First try putting .Result at the end of your Distinct() function. It returns a single-column table with the .Result column name.
Hope that helps,
Bryan
Unfortunately its not even giving me the option. Could you give an example of what the code should look like? Something like this?
Distinct('Policy Approvers Backup 2',ApproverName.Result)
Yes, try this syntax instead:
Distinct('Policy Approvers Backup 2', ApproverName.DisplayName).Result // Distinct returns a single column named 'Result'
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 393 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 278 Most Valuable Professional
