This is the first draft of or data model. Started looking at the Harry Potter Dataset and discussed in detail among us Wizards how the data should look like.
Pasted the tables below and this description into the Power Platform Plan Designer In our Ulrikke Potters Play Chamber environment – this environment is a play environment, because we do not want to use a preview feature in our other environments.
“Hello, we are building a way for wizards to collect Ingredients, and with the Ingredients they can make potions. When they make potions the wizards can go up levels, and spells gets available for them to use aswell. They will use a canvas app to scan the environment on spawn instances that will be created with power automate. The Ingredients will have a 3d model URL that will be used for the spawns. Could you please help me make the data model, below is what we have come up with.”
We also
Lets see what the plan designer comes up with – Scroll to the bottom of the tables.
Table: Contact(users) – Custom columns
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Level | Number |
Table: Ingredient Inventory
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Ingredient | Lookup | Table: Ingredient | (1:N) |
| Quantity | Number | ||
| Contact | Lookup | Table: Contact |
Table: Potion Inventory
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Potion | Lookup | Table: Potion | (1:N) |
| Quantity | Number | ||
| Contact | Lookup | Table: Contact |
Table: Spell Inventory
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Spell | Lookup | Table: Spells | (1:N) |
| Mastered | yes/no | ||
| Contact | Lookup | Table: Contact | |
Table: Potion
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Potion | string | Main column | |
| Ingredient | Lookup | Table: Ingredients | (N:N) |
| Effect | Text | Singe line | |
| Characteristics | Text | Single line | |
| Required Level | Number | ||
| image column | img | Primary image column |
Table: Ingredient
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Ingredient | string | Main column | |
| Rarity | Choice | ||
| Image column | img | Primary image column | |
| Model Url | Test | Single line |
Table: Spell
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Spell | string | Main column | |
| Rarity | Number | ||
| Required Level | Number |
Table: Spawn Instance
| Field Name | Data type | Data type specification | |
|---|---|---|---|
| Ingredient | Lookup | Table: Ingredients | |
| Spawn Point | text/lookup? | – Hva AI builder produserer |
Accepted the user stories
The data model that came out of the plan designer – before doing changes.
The contact table should be used as the “wizard” table:
IT made a Contact table, a custom one. So that is a big big fail from the Planner.
Did not want any data in the tables. I asked the planner to remove the data, but it made the tables with the data anyways.
Another thing it did wrong, was to make an image column – it made it an URL column. I stated that it should be a primary image column. – So needed to do a clean up of the image columns in two tables.
Many to many relationship on potion to ingredients was not made
Added a model driven app to configure the Ingredients the potion needs to be made.
NEXT step – Export the solution out of the play environment and get it into or DEV environment.
Ok, so after import to the DEV environment – an unmanaged solution. We saw more problems with the data model. So we decided to Export a managed solution form the play environment and import that into the dev – delete, and do the process again.
Ok. So it does not work the way i want it to. It is almost there, but it can NOT change a URL column to an image column. And it can not use the standard contact table.
So decided to make it manually.