Unanswered

Display data from a second Sharepoint list on a PowerApps page based on a person's first and last name

(0) Share

Report

Posted on by s44

691

Hello, I am creating an application with "Power App" and I would like to display 2 lists from SharePoint on my page. The "Note de frais" list and the "Cagnottes" list.

But when I invoke my "Cagnottes" list on my page on Power Apps, the list does not contain any data.

I would like to be able to display the data of the "Cagnottes" list according to the Name/First Name (Nom-Prénom) of a person.

For example if here I display Sarah's expense report (Note de frais), I would like it to also display money pot (Cagnotte) of Sarah.

Do you understand what I'm trying to explain ><?

Thank you in advance for your help !

All responses (2)

Answers (0)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report

Re: Display data from a second Sharepoint list on a PowerApps page based on a person's first and last name

Is this the same as my other suggestion on a similar post from you :
LookUp(Cagnottes;'Nom Prenom'.Email = User().Email)
is what you actually wanted? or is this a different question. If this is what you wanted click accept it as the solution.
BCLS776 8,988 Super User 2025 Season 1 on at

Like (0)

Report
Re: Display data from a second Sharepoint list on a PowerApps page based on a person's first and last name

It sounds like you want to have a gallery display your main list "Cagnottes", and then be able to browse to a specific record by selecting the item in the gallery. If so, here are the basic steps:

Insert a gallery control (assume it is named Gallery1) and set its Items property to Cagnottes

In the OnSelect property of the gallery frame, put Select(Parent); If you need a second screen for Step 3, you will also need to add an appropriate Navigate() function here.

Add a form control to your app and set its Item property to LookUp('Note de frais', 'Nom Prenom' = Gallery1.Selected.'Nom Prenom')

Does that do what you are after?

Bryan