Answered

View data form on Power Apps

(1) 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.

PS : (The "Nom Prenom" field is of Person type)

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 (8)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes i understand this can be done but i have some questions 🙂
First does everyone have unique first names? - if not we should consider using email
Second are we showing this matching to the current user on the app or are we selecting a user in the app to see?

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

@AJ_Z These are unique first names, and I would like to do this with the current user on the app ^^

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

so for what you are asking for the item on the form should be something like:
LookUp(Cagnottes,First(Split('Nom Prenom'.DisplayName," ")).Result = First(Split(User().FullName," ")).Result)
I do not really recommend the above. I prefer the below:
LookUp(Cagnottes,'Nom Prenom'.Email = User().Email)
see if this one meets your use case.
if you want to go through this on a Teams call let me know or i can continue to answer questions here either works 🙂

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (2)

Report
Copy link

Link copied!

@AJ_Z It tells me an error when I use these formulas, as you can see from the screenshots 😞 (I prefer to continue on this forum rather than Teams if you don't mind >< )

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

No problem at all 🙂

also i realised you are using a version of European powerapps (i am guessing french) change all of my , to ; so it should be:

so for what you are asking for the item on the form should be something like:
LookUp(Cagnottes;First(Split('Nom Prenom'.DisplayName;" ")).Result = First(Split(User().FullName;" ")).Result)
I do not really recommend the above. I prefer the below:
LookUp(Cagnottes;'Nom Prenom'.Email = User().Email)

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much ! It's work 😄 !!

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am delighted to have helped take care and i wish you a Merry Christmas and a Happy New Year 🙂

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (1)

Report
Copy link

Link copied!

Thank you Merry Christmas and Happy New Year to you too! ^^

Was this reply helpful? Yes No