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
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'. 🙁
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional