Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Lookup values from a SharePoint List and display in a label

(0) ShareShare
ReportReport
Posted on by

Hello,
I have a SharePoint list that contains records that I am adding or editing using Power Apps.
I have an edit form that pulls in the record based on my choice from my gallery on the left.
The fields in the SharePoint list are named Q1 Goal, Q2 Goal, Q3 Goal and Q4 Goal.
When the app loads I want to show the values in those four fields above in four new fields called "Current Q1 Goal", "Current Q2 Goal" and so on. 
Then I can modify the fields on the form called Q1 Goal, Q2 Goal, Q3 Goal and Q4 Goals to new values while the "Current Q1 Goal", 
"Current Q2 Goal"... will retain their values. Does this make sense?
So what I am thinking of doing is a lookup in the Default property of "Current Q1 Goal" and the like to the SharePoint list.

 

ChrisL58_0-1717696851712.png

Current values are lookups and persist
Q1, Q2, Q3 and Q4 can be modified.
The next time the colleague is chosen in the gallery, the values will reflect the change

Categories:
  • Verified answer
    ChrisL58 Profile Picture
    on at
    Re: Lookup values from a SharePoint List and display in a label

    Sorry for posting this as it has a simple answer.
    For each of the "Current Q1, Q2, Q3 and Q4 Goals" I used ThisItem.'Q1 Goal', ThisItem.'Q2 Goal', ThisItem.'Q3 Goal' and ThisItem.'Q4 Goal'. 🙁

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard