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.
Solved! Go to Solution.
Hello @CN_05,
Sorry for my late reply. Unfortunately I don't know why it doesn't populate any data in your case. I haven't done anything other than what I've already shown in the photos. Maybe you could share some photos of how you've set up the tables/relationship and the formula, and I can try to help?
I did the same technique but the sort capability is greyed out. We need the ability to sort and filter by shelter name. Any ideas on how to accomplish this?
I am still stuck on this step. I've set up the columns like you suggested, but still can't get them to populate. I need to get this done so I can move on from the model driven app. The only reason I can find that this isn't working, is that my tables keep coming in with a different publisher name. Does anyone know how I can remove the default "pu"?
Do you think that is the issue?
Hi @jhwilliams,
The publisher's name should not interfere with the columns. The publisher's name is essentially the digital ID of the solution developer. You can read the official documentation on this here: Solution publisher.
You are not able to delete a 'Publisher' but you can edit and existing or create a new, but these options won't resolve your issue of your Shelter Names not populating.
Below are some examples and guidance on things you can check to ensure you have setup your columns correctly.
For comparison, here is a screenshot of my 'Initial Shelter' column in my 'Animal Table'.
The formula in your 'Shelter Name' column should be the following:
'Initial Shelter'.ShelterName
The 'Data type' for this column should be 'Single line of text fx'
Here is a screenshot of my column.
Make sure to adjust your naming conventions to suit your solution.
Hi! I've followed your steps, but the column with the fx formula ends with no records on it...:
Table animals has a lookup column called initial shelter
Table Shelter has a column name text data type called Shelter Name (as it was in the original xlsx file)
Table animals has a newly created column called Animal Shelter Name (with the power fx formula). initial shelter. sheltername.
And then in the app I cannot see the information...
Any idea to solve it? . thanks in advance!
Hey Ignacio-G, After messing around with trying to just import the excel files. I started from scratch, creating every column for my tables, with lookups and formulas. Once I did that, I did the basic import (which has an added step of updating your date columns to "Use Local". English (United States) using the .xlsx file. This brought everything in after some time. Just make sure you get all of your choice entries correct (There is a random Cow in there that doesn't have a shelter that takes cows.). Hopefully that helps. I know it was a lot more work that I originally planned.
Good Luck!
Thats good to know @jhwilliams ! Congrats ! I found an easy way to import files, from the app but importing them as a XML sheet 2003 version. That way i didn't encounter any issue.
Right now i am struggling to get data using the lookups as @StineN did... i really dont know why i cant.
Thanks!!
Well... finally I could mapped the field Shelter Name using the lookup Initial Shelter, without @StineN method... I find it strange because at first it didn't work. So , in the end, only with the lookup you should be able to search a particular field in other table without doing extra work... ideally haha.
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!
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.
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.