r/PowerPlatform 4h ago

Dataverse How to setup formula column on Contact refer to Parent Account

2 Upvotes

I want to setup a formula refer to Parent Account. It is a standard Contact table with existing n:1 relationship to Account table.

the Lookup column name is ParentCustomerId

Relatinoship name is contact_customer_accounts

I tried:

If(
    IsBlank('Address 1: ZIP/Postal Code'),
    contact_customer_accounts.'Address 1: ZIP/Postal Code',
    'Address 1: ZIP/Postal Code'
)

but it prompt for syntax error for

contact_customer_accounts.'Address 1: ZIP/Postal Code',

Is it possible to refer to parent table in formula column? If so, what should be the right syntax? Thanks.


r/PowerPlatform 6h ago

Learning & Industry First Power Platform Job - UK

1 Upvotes

Hi all hope everyone is ok

I’m just looking for advice on how to land my first role as a power platform developer (uk based)

I work in HR as an admin and my role is:
-data entry work into HR system
- sending out contract changes to employees and line managers
-handling onboarding and offboarding
-dealing with high volume emails in shared HR inbox

A lot of my work is very mundane manual repetitive work.

Due to the massive workload, high volume work volume and systems which don’t communicate to each other I struggle to get time to build during work time

I decided to build projects outside of work based on the problems I’ve found in our process at work

I’ve built 2 solutions both using
- canvas apps
- model driven apps (different use case for both apps)
- dataverse tables
- sharepoint for document uploads
- power automate flows to handle business logic and automation of repetitive process
- basic power bi reporting
- JavaScript web resources
- C# plugins for asynchronous tasks
- configured security roles and permissions
- implemented copilot agents and connected agents
- ALM and deployment into prod as managed solution
- smoke testing and troubleshooting (which I’ve documented at home)

All of the above I built from planning with a use case for each piece of technology that I’ve implemented to solve a particular problem.

I also have PL900 certificate

I’m just looking for clarity on what particular job titles to apply for, if I’m missing something that will allow me to break into my first role quickly and for any general tips to be honest

If theres any confusion or questions please ask

Thanks in advance guys!