cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Corry
Advocate V
Advocate V

Display Shelter Name - Model-driven app Requirement

Hi everyone,

 

I am stumped on figuring out how to display the name of shelters in my 'Animal' table view.
The first requirement states "View a list of animals displaying name, type, shelter status and shelter name".

 

Shelter name doesn't exist in the 'Animal table final' Excel data but does exist in the 'Shelter table final' Excel data.
I am trying to display the 'Shelter Name' in a new column in the 'Animal' table by checking if the value in my 'Current Locations' column in my 'Animal' table matches the 'ShelterID' from the 'Animal Shelter' table. If it does match 'ShelterID', display the 'ShelterName' from the 'Animal Shelter' table.

I tried this as a PowerFx formular column called 'Shelter Name', but I couldn't get the attributes I need.

I also added the 'ShelterName' column as a related column in the 'Active Animals' table view for the 'Animal' table, but no results appear. See Animal_Table_View_Related_ShelterName_Column.png

 

My 'Current Locations' column is a PowerFx formula column with the following code:

Switch('Shelter Status',
'Shelter Status (Animals)'.'In Shelter','Initial Shelter'.ShelterID,
'Shelter Status (Animals)'.'Ready for Foster','Initial Shelter'.ShelterID,
'Shelter Status (Animals)'.'In Foster Home','Foster Claimer'.FosterID,
'Shelter Status (Animals)'.'Claimed for Adoption','Foster Claimer'.FosterID,
'Shelter Status (Animals)'.'Ready for Adoption','Foster Claimer'.FosterID,
'Shelter Status (Animals)'.Adopted,Blank
())

Although I have followed the learning material, this one has gotten me stuck. I know there is a way, I just can't see it.

I would really appreciate guidance on this so that I can move forward with the other requirements. 

27 REPLIES 27

Hello @StineN 

I am trying this way but I am getting an error when using the formula.  

No problem, I'm glad I could help! I know what you mean about making things more complicated than it needs to be.. been there, done that! 😂 

Hello @CN_05!

What does the error message say? Maybe there's an issue with the lookup column or the relationship between the tables? 

Hello @ Stine

 

I am not even able to finish typing the formula. It does not populate like yours does.  I have started over so many times.  

 

CN_05_0-1715780018510.png

 

Hi @CN_05

 

Not sure if I can help, but are you using the same column names as I've shown in my screenshot? If your columns are named something other than IntitialShelter (in the Animals table) and ShelterName (in the Shelter table), you need to update the formula to use your column names. 

 

That squiggly red line and error message will show up until the formula is working. Does it stop you from typing? In that case, it might be a bug?

Hi @StineN

 

Thanks for this solution but for some reason I'm not able to mirror it in my own table. I don't get an error, but the column returns a blank result. Only change on mine is the is the lookup column is named slightly differently. 

Any help is greatly appreciated 😀

Hello @n1CK_

 

The column InitialShelter1 should be a lookup column to the Shelter table, where it will get the values from ShelterName. If the result returns blank, maybe there could be something wrong with the relationship between the tables Animal and Shelter? Here's a few screenshots of how I've set up my columns, maybe it can be of some help? 

 

InitialShelter lookup column in the Animals table:

StineN_1-1715841905541.png

 

The relationship created between Animals and Shelter tables, using the InitialShelter column: 

StineN_0-1715841866542.png

 

The ShelterName column in the Shelter table (where the formula should get the values from):

StineN_2-1715841979029.png

 

 

Hello @StineN 

 

Yes, my column names are the same just used what was on the tables.  I got it to work but did not populate any data

 

 

 

 

 

JB-Wan_Kenobi
Frequent Visitor

How do I populate the Initial Shelter look up? At the moment it's empty with no Shelter IDs. Is this correct or should I have imported data to this field?

Hello @JB-Wan_Kenobi,

 

The ShelterIDs should be imported when you imported the Shelter table. Set up the primary column as "ShelterID". Then when you create the column InitialShelter in the Animals table, you set it up as a lookup to the Shelter table. When you import the Animals table, the InitialShelter column will be populated with the ShelterIDs from the Shelter table. 

Helpful resources

Announcements

Important Update | Power Up Community READ ONLY July 22 – July 28

Dear Community Members, As you may have read, the Power Platform communities are transitioning to a new platform and to access will be set to READ-ONLY mode during the transition. Key DatesTo ensure current learners have adequate support in the final week of the cohort, the Power Up Program Community will transition to READ-ONLY mode starting July 22nd, the platform will transition to READ-ONLY mode until July 28th. Power Apps, Power Automate, and Power Pages communities will be read-only July 16-22, 2024.During this period, members will not be able to start new threads or Kudo, Comment, or Reply to any posts, but will be able to search and review past threads or solutions. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. Learners will be able to sign in to the new Power Up Program community experience, starting July 29th. If you registered for community using your learnwithpowerup account, you will not receive an email, but should be able to sign in successfully if you are signed in to My hub.  If you need help with your community account, please submit a request at aka.ms/PPCommSupport We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead! 

Learn what to expect in the Power Up Program

Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course.   Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.  

Welcome to the Power Up Program Community

The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate.  As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards.  Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.

Top Solution Authors
Top Kudoed Authors
Users online (4,837)