cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s44
Post Patron
Post Patron

View data from on PowerApps

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.

s44_0-1640078859434.pngs44_1-1640078900887.png


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

s44_2-1640078965936.png

 

 

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 !

7 REPLIES 7
CNT
Super User
Super User

@s44 

when I invoke my "Cagnottes" list on my page on Power Apps....

Where and how are you doing this? Please share some formulas.

s44
Post Patron
Post Patron

@CNT I do this here : 

s44_0-1640096991266.png

 

CNT
Super User
Super User

@s44 great! You have added both the lists as data source. Now show me where in the App u r showing the data. Share the formulas you have in the Gallery and Form. 

s44
Post Patron
Post Patron

I want to show the data here : 

s44_1-1640102028869.png

 

At the top you can see the content of my Sharepoint "Note de frais" list and at the bottom my "Cagnottes" list, but there is no data displayed for the fields concerned of the "Cagnottes" list.

 

I tested this formula which you could see in my screenshot for "Items" but it doesn't work. 😞

CNT
Super User
Super User

@s44 is that an EditForm? Can you paste that formula in the chat. 

s44
Post Patron
Post Patron

@CNT  It's a DetailScreen. The formul is : Filter( Cagnottes, SearchInput.Text in Nom Prenom )
My "Nom Prenom" field is of type "Person"

CNT
Super User
Super User

@s44 

Please try the following,

LookUp(Cagnottes, SearchInput.Text in 'Nom Prenom'.DisplayName)

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,951)