Display the correct row of a Sharepoint list for a specific user in Power Apps

(0) Share

Report

Posted on by Hii_iii

691

Hello,
I have two Sharepoint lists: An "Notes de frais" list and a "Cagnottes" list.

In Power Apps, on this screen I display a line from the "Note de frais" list for a user and below I display the line from the "Cagnottes" list corresponding to this user.

But when I look at the other screens corresponding to other users, I can see the line of the "Note de frais" list which is dedicated to them, but it does not display the correct line of the "Cagnottes" list.

For example :

Here for Romain it displays the first line of my "Cagnottes" list, but not the line dedicated to him according to his name / email.

The correct line to display is the one surrounded :

Can you help me please? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

Hello,

Can you try to user the Lower function in your filter to get something like Lower('Nom Prenom'.Email = Lower(User().Email)

Best regards,
Alaa

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Hello @alaabitar,
It's doesn't work 😞

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
@s44 ,

First of all please identify the control from Details Form where the Nom Prenom is showed ( in my example I named it NomPrenomControlNameFromFirstForm control).

Then in item property of the second form, lookup in Cagnottes list for a record with the same email on 'Nom Prenom' (i suppose it is a person type column):

LookUp(Cagnottes,'Nom Prenom'.Email=NomPrenomControlNameFromFirstForm.Selected.Email)

or, because you have already a column email in Cagnottes list (from my point of view it is useless because you have the data stored in it) you can use:

LookUp(Cagnottes,Email=NomPrenomControlNameFromFirstForm.Selected.Email)

Hope it helps !

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Thank you for your help @gabibalaban , but I don't know where to find the control from Details Form where is the Name Surname is showed. It's here ? 😮 :

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@s44 ,

This is what are we looking for. Most probably is a combobox control.

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

Hello,

Sorry I missplaced the ")" it should look like
Lower('Nom Prenom'.Email) = Lower(User().Email)

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (1)

Report
@gabibalaban Oh ok, it's this for me^^ :

Can I write the formula like this ? :

LookUp(Cagnottes,'Nom Prenom'.Email=DataCardValue2.Selected.Email)

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

@gabibalaban I still have the same problem. For example it is not the right line of the "Cagnottes" list that is displayed for noemie :

The correct line to display is this:

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
@s44 ,

Hmm ... in this case check the item property of DetailForm and use it, as it is, inside our formula:

LookUp(Cagnottes,'Nom Prenom'.Email=ItemFromDetailForm.'Nom Prenom'.Email)

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

The formula doesn't work 😞 @gabibalaban

Was this reply helpful? Yes No