
Announcements
Hi,
Trying to get my head around correct design now that I am using Patch function. The use case is to only update data (although a column may have been empty before but now has data)
My question is: Do I need a variable? & If so where would I put it
Before answering here is the background.
I have 3 sharepoint lists of about 20 columns each, List A, B & C. List C is kind of the main list and the list that ties the other 2 lists together. List C has Lookup columns to both A & B.
On a screen I have a gallery showing List C. On select I set a variable called varformdata (remember that this is only List C but does include some id fields that I can use to lookup data from other lists)
I then go to another screen which is used as a kind of detail screen. Currently I have each field's default to be a Lookup (Lookup(ListA, ID=varformdata.'RefListA:ID'.Id, ColumnC)
Im thinking that all these lookups cant be too efficient
Thanks in advance
Todd