web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Reference a form field...

Power Apps

Unanswered

Reference a form field outside of the form

(0) Share

Report

Report

Posted on by mjhritz

I have two Sharepoint online lists, Contacts and Incidents. They are linked by the Contacts phone number, i.e., there is a master Contact record with a phone number and it is related to multiple Incidents records by the phone number in each Incidents record. When I save a new Incidents record I want to record the date of the new Incident (which will usually be Today()) in the LastIncidentDate field in the associated Contacts record. I can't determine the correct formula to do this. Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mjhritz

You should be able to update your Contacts record by calling the UpdateIf after you save your Incident record.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-update-updateif

The formula would look something like this

UpdateIf(Contacts, PhoneNumber = "ThePhoneNumberForTheRecordToUpdate", {LastIncidentDate:Today()} )

Was this reply helpful? Yes No

Join the conversation