Solved: Lookup values from a SharePoint List and display in a label

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.

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:

General Questions