Answered

Create a profiling with Power Apps

(0) Share

Report

Posted on by SeguM

Hello everyone,

I am trying to create a profile in power apps through the team user, it will be the one obtained with the User() function and the Email.

I have two sharepoint list, a general one with the fields Field1 that are colors and Field2 that are Names.

Field1	Fiel2
red	Rick
blue	Daryl
yellow	Morgan
white	Maggie
red	Negan

In the second list there is only the user and the color.

profile	Field1
user	red
user	white

The first table displays the data in a gallery and what I need is for it to display only the computer user information that matches list2, for example, two colors would be displayed, red and white.

the goal is that the gallery only shows the data of those that are in list2.

I have tried with lookup (but it only brings me a record).

Any ideas??.

Thank you so much

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Segu1 @ - it appears you want to filter a list by another list. You could try something like:

ClearCollect( col_Example, Filter(col_SP_List1, Field1 in col_SP_List2.Field1) )

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(0)

Report
Copy link

Link copied!

hello Amik,
Thank you very much for your answer. However, my database is quite large and with the "in" function I am having delegation issues and the same is happening with collections.
Thank you so much

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(0)

Report
Copy link

Link copied!
For example, I have tried this: I have created a variable that brings me the elements of the list2

Set( myprofile; LookUp(DDBB; profile= User().Email) );;

and with that value make the comparison in the gallery, In items:

Filter( DDBB; myprofile.field1=field1;

but since lookup only returns the first value it finds, it does not filter all the elements.
That's my problem

Was this reply helpful? Yes No
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Your data source might be large, but do you expect the returned results which match List2 to still be below 2000 records?

If yes, you could use a collection or alternatively use the With function to create a grouping of each category. I am sure there are many other methods, but I tend to use patterns like these:

With:

With( { wRed: Filter( 'Your Data', Colour = "Red" ), wBlue: Filter( 'Your Data', Colour = "Blue" ), wGreen: Filter( 'Your Data', Colour = "Green" ), wYellow: Filter( 'Your Data', Colour = "Yellow" ) }, ClearCollect( colMyCol, wRed, wBlue, wGreen, wYellow ) )

Collection:

Filter( col_first_list, 'Color' in col_second_list.colors )

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Amik,

Thanks for the answer, it has been very useful. Best regards.

Was this reply helpful? Yes No