Announcements
Hi everyone,
I’m currently building a model-driven app in PowerApps that involves three primary tables: Audit, Findings, and Recommendations. Each audit record has an "Owner" (assigned automatically based on the creator of the audit). My goal is to display this audit owner information within the Findings table, specifically in the Findings form, so that the user responsible for the audit is easily visible when working on related findings.
Relationships and Lookups:
audittra_finding
) that links it to the Audit table (audittra_audit
). The lookup field in the Findings table is called Audit ID
.Attempted Calculated Field:
[audittra_AuditID].[ownerid]
. Unfortunately, I encountered an error stating "The formula contains an invalid reference: audittra_AuditID.ownerid."Exploration of Other Methods:
ownerid
fields directly.ownerid
).audittra_AuditID
) linking Findings to Audit.ownerid
reference.ownerid
field from a related record in a calculated field or through another automated process.ownerid
reference and potential workarounds.Any guidance or suggestions from the community would be greatly appreciated! I’ve been following all the best practices I know of, but I’ve hit a roadblock with this specific issue.
Thank you!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.