Hi,
Apologies if this has been resolved elsewhere - I've looked but can't find anything that matches my query.
I have a Power App with 2 Sharepoint Lists. For simplicity I'll say they comprise the following:
1. Audits: With the following fields - Title (text), Auditor (People Picker), Audit Date (Date and Time)
2. People: Name (People Picker), Auditor's Peer (People Picker)
I have a form called 'Audit Information'. On that screen are the fields: Title, Auditor, Audit Date, and Auditor's Peer.
Title, Auditor, and Audit Date come from the Audits list.
Auditor's Peer is just a text label field with a default of Lookup(People, Auditor.Selected.Email = Name.Email, 'Auditor's Peer'.Email).
All of this works fine, except:
If the actual Auditor's Peer changes (which happens quite a lot) then I want the text label field to update to match the new information. It does for new Audit Information records, and if I go into the relevant page on existing Audit Information records and save/ submit (to effectively refresh the info), but my lists run to hundreds of records each and I'd really rather it updated automatically.
I wondered if I could get round it by setting a variable for the OnStart properties of the app, and then setting the default value for the text label field to the variable - so that it would at least refresh/ update when the app was started, but I had no joy
(I tried Set(varap, Lookup(People, Auditor.Selected.Email = Name.Email, 'Auditor's Peer'.Email)) - but that just kept coming up with a blank result). Then I tried setting a local variable in the OnSelect properties of the Auditor field, and again setting the text label default to be the variable - this, again, worked for new or manually refreshed records, but doesn't update automatically on existing records).
Feel I'm close (maybe I'm not!), but am definitely now at the limit of my knowledge.
Any help would be much appreciated.
Thanks
