Unanswered

How can I filter the dataverse user table by business unit?

(0) Share

Report

Posted on by bp3378

114

in canvas, I'm trying to create combo box search for users from the dataverse users table and that works, but im trying to extend it by filtering by a particular business unit. I have tried this expression:

Filter(Users, 'Business Unit' = "BU Name")

Getting error: Incompatible types for comparison: These types can't be compared: Record: Text

I have also tried this:

Filter( 'Business Unit' = LookUp('Business Units', Name = "BT_BU"))

Getting error: Incompatible types for comparison: These types can't be compared: Record: Record

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

gcmfaizan 1,022 on at

Like (1)

Report
@bpw As Bussiness User Column name is LookUp column so to compare with it please try this:
Filter(Users, 'Business Unit'.Name = "BU Name")

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
bp3378 114 on at

Like (0)

Report

Thank you that worked!
Just to clarify, the .Name is the column in the business unit table?

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (1)

Report

@bpw Yes you are right, it's a column name.

Was this reply helpful? Yes No