cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Geno
New Member

Dataverse Table Uploading as Text

Please I need help with the fields in the dataverse table appearing as text rather than a combo box. This means there is no dropdown menu to choose options from. Thank you!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
BCBuizer
Multi Super User
Multi Super User

Hi @Geno ,

 

No problem. 

 

First select the form and then click on Fields in the property pane on the right. After you found the field you wish to change, under Control type, select Allowed values:

BCBuizer_0-1716335704639.png

Please ignore the identifiers in the above screenshot since they do not relate to the Power Up challenge.

 

After you made the change, unlock the DataCard by selecting it, going to the Advanced tab in the properties pane and selecting Unlock to change properties:

BCBuizer_2-1716335892798.png

 

When you have unlocked the DataCard, select the dropdown control inside it and set its' Items property to the name of you Animals table. Under the Advanced tab in the properties pane you may have to set the Value property (under Items) to display the Animal Name column.

 

Now you have ended up with a field in your form where you can select an animal from all of the available animals in the Animals table.

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

BCBuizer
Multi Super User
Multi Super User

Hi @Geno ,

Has this issue been resolved? If so, please mark the post that was key to the solution by pressing the "Accept as Solution" button so it's easier to find for other members of the community.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

7 REPLIES 7
BCBuizer
Multi Super User
Multi Super User

Hi @Geno ,

 

Can you please share which columns you are talking about and confirm their type (text, choice, lookup, etc.)?

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Geno
New Member

I am uploading the column for the animal name from the dataverse table into the canvas app. The type is text (text area)

BCBuizer
Multi Super User
Multi Super User

Hi @Geno ,

 

Please change the type of column for the Animal names to (Single line of) Text, rather than Text area to prevent issues down the line.

 

As I understand you would like to have a combo box from where users can select the names of the animals. Should this be in the context of a form?



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Geno
New Member

Yes, that is correct. During the tutorials, there was the option of being able to choose a book for loan from a dropdown menu of the list of available books. I am unable to recreate that so that and I'm lost as to what could be the problem. 

BCBuizer
Multi Super User
Multi Super User

Hi @Geno ,

 

No problem. 

 

First select the form and then click on Fields in the property pane on the right. After you found the field you wish to change, under Control type, select Allowed values:

BCBuizer_0-1716335704639.png

Please ignore the identifiers in the above screenshot since they do not relate to the Power Up challenge.

 

After you made the change, unlock the DataCard by selecting it, going to the Advanced tab in the properties pane and selecting Unlock to change properties:

BCBuizer_2-1716335892798.png

 

When you have unlocked the DataCard, select the dropdown control inside it and set its' Items property to the name of you Animals table. Under the Advanced tab in the properties pane you may have to set the Value property (under Items) to display the Animal Name column.

 

Now you have ended up with a field in your form where you can select an animal from all of the available animals in the Animals table.

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Geno
New Member

Thank you so much. This helped.

BCBuizer
Multi Super User
Multi Super User

Hi @Geno ,

Has this issue been resolved? If so, please mark the post that was key to the solution by pressing the "Accept as Solution" button so it's easier to find for other members of the community.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

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.

Users online (870)