Unanswered

Dropdown with 2 sources,concatenate unique results

(0) Share

Report

Posted on by alexcasas

Hi, I have a dropdown reading data from 2 diferent lists. On both lists there are items that are the same, but i need to only show one of them (it doesnt matter which one). The dropdown looks for the ID column of the user executing the app. T

This is working, the only thing is that is showing duplicated items when they exists on both lists (and i tried to add a distinct at the very beginning but can't make it work).

Concatenate(
 Distinct(
 Filter(
 List_1; EMAIL = User().Email); ID);
 Distinct( 
 Filter( 
 List_2; EMAIL = User().Email);ID))

Any help is welcome.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Devvj 1,132 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
does it work with something like this?
Distinct( Concatenate( Filter(List_1; EMAIL = User().Email);ID); Filter(List_2; EMAIL = User().Email);ID) ) )
alexcasas 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for taking your time withh this...

Unfortunately it didn't work, it says:
"Error: Invalid number of arguments. Received 3, expected 2"