Filter gallery data.

(0) Share

Report

Posted on by Cr1t

555

Hello,

I am trying to filter a gallery based on the data present in a multiselect lookup column and i have error. Powerapps can't conver text to a table.

I have 2 sharepoint lists.

List 1- Has a multiselect look up column Assigned courses linked to title column of list 2.

List 2 - Has a title all the courses and title column is a single line text.

In gallery i was trying to filter list 2 courses based on the user logged in and display only the courses assigned to users in Assigned courses coulmn, but i get error.

Filter(Training,Title in Filter('[Data]-Competency Assessment',Title = User().Email).'Assigned courses')

Please help. thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-jefferni on at

Like (0)

Report
Hi @Cr1t ,

If you only want the courses assigned to current logged in user, why not filter list 1 directly?

Filter('[Data]-Competency Assessment',Title = User().Email).'Assigned courses'.Value

Best regards,

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (1)

Report
Hi @Cr1t, I'm not sure why you're getting that error but I think what you need here is a Distinct().

// This will return a list of ALL values in a column Filter( Data, ...).Column // This will return a list of unique values in a column Distinct( Data, Column)

Try wrapping your second Filter in a Distinct:
Filter( Training, Title in Distinct( Filter( '[Data]-Competency Assessment', Title = User().Email), 'Assigned courses' ) )

Was this reply helpful? Yes No
Cr1t 555 on at

Like (0)

Report

@v-jefferni
Thank you very much i actually tried it and i get error . value isn't recognized.
If i remove the .value, the output comes as a table and to display table.

Was this reply helpful? Yes No
Cr1t 555 on at

Like (0)

Report

@Chris-D Thanks for replying, still getting the same error.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @Cr1t ,

The error "can't convert data type" is due to the multiple selections LookUp column in list1. If you have unique user Emails in list1 Title column, then the formula is:

LookUp('[Data]-Competency Assessment',Title = User().Email).'Assigned courses'.Value

The formula will output all courses assigned to the specific user.

Best regards,

Was this reply helpful? Yes No
Cr1t 555 on at

Like (0)

Report

@v-jefferni
Thank you, the code you provided works for me.

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (1)

Report
I see what Jeffer Ni was getting at now. I missed that your LookUp was a multi choice column.

Use Jeffer's solution along with your Filter:
Filter( Training, Title in Lookup( '[Data]-Competency Assessment', Title = User().Email).'Assigned courses'.Value )

Was this reply helpful? Yes No