5. Create and Import Animal Table in the Dataverse Part 3 (Challenge I) - Remastered 

This video is the remastered version of Create and Load Dataverse Tables III (Challenge 1) with special focus on only the Animal Table!
In this video we:
Continuing following SDLC and continue creating our new Animal Information Table in our Shelter Solution
Create all columns in the Animal Information Table, making sure we set-up the lookup relation between our table and both the Shelter and Foster Family Table correctly, and
Finally walk through step by step importation of all the data from excel into our Animal Information Table in the Dataverse using 'Import data'
Power up Challenge 2024 Walkthrough Series.
1. My Animal Shelter Solution Full Demo - • 1. My Animal Shelter S...
2. Intro - • 2. Animal Shelter Solu...
3. Create and Import Shelter Table in the Dataverse Part 1 (Challenge I) - Remastered - • 3. Create and Import S...
4. Create and Import Foster Family Table in the Dataverse Part 2 (Challenge I) - Remastered - • 4. Create and Import F...
5. Create and Import Animal Table in the Dataverse Part 3 (Challenge I) - Remastered (You are here)
6. Create a Model Driven App I (Challenge 2) - • 6. Create a Model Driv...
7. Add SVG Icons and Logo (Optional Challenge 2) - • 7. Add SVG Icons and L...
8. Create a Canvas App I (Challenge 3) - • 8. Create a Canvas App...
9. Create a Canvas App II (Challenge 3) - • 9. Create a Canvas App...
10. Create a Power Automate Flow (Challenge 4) - • 10. Create a Power Aut...
11. Create a Business Process Flow for My Model Driven App - • 11. Create a Business ...
12. Create a Custom Page for My Model Driven App I - • 12. Create a Custom Pa...
13. Create a Custom Page for My Model Driven App II - • 13. Create a Custom Pa...
14. Create a Custom Page for My Model Driven App III - • 14. Create a Custom Pa...
15. Create a Power BI Report I (Challenge 5) - • 15. Create a Power BI ...
16. Create a Power BI Report II (Challenge 5) - • 16. Create a Power BI ...
17. Create a Power BI Report III (Challenge 5) - • 17. Create a Power BI ...
18. Create a Power BI Report IV (Challenge 5) - • 18. Create a Power BI ...
19. Create a Power BI Report V (Challenge 5) - • 19. Create a Power BI ...
20. My Animal Shelter Solution Full Demo (PRO Version) - • 20. My Animal Shelter ...
New Videos updates Pro - Version
************************************************
21. Create a Workflow in Power App - Medical Passed - isMedicalPassed - • 21. Create a Workflow ...
II. JScript Web Resources (Three Use Cases- hideReturnedSectionDynamically, setFollowUpSixMonthsDOAdoption, and setDateIfEmpty)
III. Customizing app Commands (Copy single & Multiple Records)
IV. Adopt an Animal Approval Process Cloud Flow
V. Embed a Canvas App on a Model-driven Form using the Modern designer (Not Custom Pages)
************************************************
Code;
Current Location =
If(
// First Condition: Check if the animal is adopted and has a foster claimer
!IsBlank('Pet Date of Adoption') && !IsBlank('Pet Foster Claimer'.'Foster ID'),
"", // If both are not blank, return an empty string
// Second Condition: Check if the animal has a foster claimer and an initial shelter
If(
!IsBlank('Pet Foster Claimer'.'Foster ID') && !IsBlank('Pet Initial Shelter'.'Shelter ID'),
'Pet Foster Claimer'.'Foster ID', // If both are not blank, return the Fosterid
// Third Condition: Check if the animal has an initial shelter
If(
!IsBlank('Pet Initial Shelter'.'Shelter ID'),
'Pet Initial Shelter'.'Shelter ID', // If not blank, return the Shelterid
"" // Default value if all conditions are not met
)
)
)