Unanswered

Help to combine / write together two variables

(0) Share

Report

Posted on by NH90

Hi
I have two variables I would like to write together as they have to look at both parts in a dropdown. It gives me an error when I try to insert e.g. "or". How would you write these two together?
The meaning of the field is that only your own registered courses should be displayed when you log into the app

Filter(Attendee7Day;AttendeeAddress=varUserEmail)
and

Sort(Distinct(Course7Day;StartAndLocation);Result; SortOrder.Descending)

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

A combobox/dropdown can only have 1 datasource. You are trying to insert 2 different datasources, it is normal that it gives you an error

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!

Was this reply helpful? Yes No
NH90 3 on at

Like (0)

Report
Copy link

Link copied!

@Nogueira1306

Al right. It make sense. But how can we get around this and fix it so it filters on both parts?
Would like it to only show your own courses. Like currentUser.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The only way that I think of it you creating a collecting that joins both courses.. Like this:

Collect(MyCourses; Filter(Attendee7Day;AttendeeAddress=varUserEmail));;

Collect(MyCourses; Filter(Attendee7Day;AttendeeAddress=varUserEmail));;

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!

Was this reply helpful? Yes No