Unanswered

View data from on PowerApps

(0) Share

Report

Posted on by Hii_iii

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 !

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@s44

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

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

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

@CNT I do this here :

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@s44

Please try the following,

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

Was this reply helpful? Yes No