I want to build a Power App that allows users to create Interview Plans and Offer Plans for a Job.
In a relational database, I'd have three tables.
- Job Definition
- Interview Plans
- Offer Plans
Job Definition would have a one-to-many relationship with the other tables
Job Definition 1:N Interview Plans
Job Definition 1:N Offer Plans
In a relational database, each row in Job Definition has a Job ID (unique value), therefore, I would create a foreign key Job Id in both the Interview Plans and Offer Plans tables.
However, I cannot figure out how to implement this in Dataverse as custom tables. I looked at Dataverse table relationships, but it creates something called a LookUp field.
The workflow is
create a Job Definition record that has columns such as (w example values)
job_id 4947003
job_name "Chief Designer"
job_location "Irvine, CA"
client "Perfect Purpouse"
status "open"
Then create multiple records in Interview Plans and Offer Plans tables, and each record has the Job Id so can associate the Job Definition with Interviews Plans and Offer Plans.
Interview Plan records
"job_id": 4947003,
"name": "Hiring Manager Conversation",
"position": 1,
"duration": 30,
"coordinated_by": "client",
"description": "Meet & greet, general: culture/ team dynamics fit, DF opp/role fit, lite process",
"job_id": 4947003,
"name": "Portfolio Review and Behavioral Interview",
"position": 2,
"duration": 60,
"coordinated_by": "client",
"description": Discipline peer",
Offer Plan records
"name": "Client Offer Decision Date",
"position": 1,
"description": "Exact date client decides to move to offer stage.."
"name": "Candidate Receives Client Offer Date",
"position": 2,
"description": "Extact date candidate actually receives the offer from client."
Any help would be greatly appreciated.
We first modeled this using attached JSON file.
