Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

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.


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 !

Super User
Super User


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

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

@CNT I do this here : 



@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. 

I want to show the data here : 



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. 😞

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

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


Please try the following,

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

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,022)