Power Apps Model-Driven Apps: Table Columns Tutorial

[@LisaCrosbie]

Cupcake Ipsum is available here: www.cupcakeipsum.com/

[@johnsolo8933]

Just wanted to drop a note to say thank you for doing this series of videos. I run a small business. I just started switching my work flow from notion to Microsoft. I gravitated towards Microsoft lists and power automate, but I hit a wall with forcing that into what I really need: a relational database. I then started to explore Access, but that comes with its own issues. Then I stumbled upon the Dataverse. It seemed like it had everything I needed, but... It was a bit overwhelming. Enter YOU and your fantastic beginner videos. THANK YOU SO MUCH!!! You have saved me weeks of frustration

[@yeraldo05]

Thanks for the overall introduction to the type of columns Lisa!!!

[@LisaCrosbie]

Thanks for watching Yeriel

[@Paul_yd_]

You are amazing, I really appreciate all the enthusiasm and effort that you put into teaching. By far the only instructor that doesn't make me want to hit the pillow.

[@LisaCrosbie]

Thanks so much!

[@busyshah]

Concise, comprehensive and well put together. Max learning curve.

[@LisaCrosbie]

Thanks!

[@vasudevbethamcherla3001]

Thank you so much Lisa. This series has been really useful for a complete beginner like me.

[@LisaCrosbie]

Excellent, thank you, so glad to know it helped

[@mikesmith2315]

Thankyou for this great presentation

[@LisaCrosbie]

Glad you enjoyed it!

[@anninguyen7772]

Thank you so much Lisa!

[@kevinklas4281]

Hi Lisa, do you have any idea if it`s possible to set the "Display Name of a new self-added column" in different languages? For Example, like, English and German or even more languages like Spanish, French! So, it would be if there are multiple Users in a model-driven-app that using different languages, that each user can chose (or it will be done automatically) his preferred language to use the model-driven-app. Thanks so much for all your videos, I really like them! 🙂

[@LisaCrosbie]

Yes, here’s how it works learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/translate-localizable-text

[@judevilingston3344]

Hi, good content. I have a query - is there a way to add a new column to a linked external table (sharepoint list). It's disabled by default to try in power apps

[@andersonm6241]

Hello, first of all I want to say that I really like your videos and I have learned a lot. I have a question, I have a lookup column in a table A, I want that when I select the record of the table B (Table in which the lookup column is searching), the value that appears in the lookup column, is another column outside the main column of the table B. I also want that by selecting the record, automatically in other columns of my table A, several values of the selected record are entered (values of the selected record from the table B), this means filling several columns of my table A, with the different values in table B of the selected record in my lookup column. how can I do this?

[@LisaCrosbie]

The lookup column will only ever show the Primary Name of the table you are looking up, but you can use a different view in the lookup so that the user sees additional information from table B when searching. To display more columns from table B after you have done the lookup you can use a Quick View Form - video tutorial here - kzbin.info/www/bejne/ioach6ePabGNgs0 If you want to actually fill columns on Table A with values from Table B after the lookup is selected then you can build a flow in Power Automate to add those values.

[@starry-traveler]

Hi Lisa, awesome video. Just watched you from the Virtual Training earlier today. Question though, how do you add multiple users in one column? I'm guessing using Lookup -> AAD user. But there's no option there to have multiple selections. TIA

[@LisaCrosbie]

Hi Denisse, thanks for joining the session, we had so many more questions there than we could get to! You're right, lookup doesn't allow for multiple selections. You need to create multiple lookup columns. Otherwise you can use another option called connections (from the Innovation app that's what they use for a list of internal stakeholders /users) What's the use case/requirement that needs more than one user in a lookup?

[@starry-traveler]

@@LisaCrosbie Hi Lisa, thanks for the reply. I'll try the connections that you mentioned. We have a column named "Interviewees" and it require multiple users.

[@espencer2151]

I have a question in regard to the Yes/No data type. The datatype is "shown" as a toggle in the table editor, but when it comes to using it in the PowerApps form (as you presented), it shows up as a Drop Down. How do we change that to show as a toggle (or better yet, a Checkbox). I have been trying to figure this out for weeks, and cannot seem to get it to work.

[@LisaCrosbie]

On the form designer there is an option in the bottom right called “components” and you’ll find the toggle switch there. Haven’t done a video on it yet.

[@LG-mv8sj]

Great tutorial! love your work. Wondering it is possible to have choice/choices column to pull its choices from a different table's items or from a SharePoint list item. for example, I have a list of active projects in a dataverse table, or in a SharePoint list and I want the choices to be the project names in that table or the list. if you already have a video, could you please respond with it? I prefer SP list as I already have a canvas app used for a different purpose and I need the project names from the SP list as the choice column data within this model driven app. I haven't seen all your videos yet, sorry it its already there. :)

[@LisaCrosbie]

Thanks so much. In answer to your question - no, it doesn't work that way. The choices column can't be connected to another table in Dataverse or SharePoint, it needs to be set up as its own object (although then that same list of choices can be used in multiple tables). Getting the values from your SharePoint list into a table in Dataverse will be easier than trying to apply it to a choice column, so if you can use a lookup to another Dataverse table instead that may be a better option. You could build a Power Automate flow that adds a value to the table in Dataverse each time a new project is added to the SharePoint list.

[@LG-mv8sj]

@@LisaCrosbie I am getting a hang of it, thanks to you again. I watched your order placement app. but i am not sure how to place one order with multiple items. do you have a guide for it? I am building a safety app where it has forms and need repeating tables within each form so people can fill one form for multiple safety issue rather than submitting multiple forms. looking forward for your response!

[@philopenshaw541]

Hi Lisa, thanks for sharing, but as a novice user I am struggling to convert a template text column to autonumber. I am getting an error column type cannot be changed because it is currently being indexed. Doesn't appear to be an option to delete and start again. Thanks Phil

[@LisaCrosbie]

Sorry, I haven't come across that error before. You might want to post the question in the Power Apps Community Forum (if waiting a while and trying again hasn't solved it)

[@karenrees7370]

Another really useful explantion Lisa, thank you. As a beginner your videos are quickly becoming my 'go to' for Power Apps learning insights! I'm trying to create a date only column suitable for DOB but unsure how to set a parameter more useful to selecting a DOB rather than current date. Is this possible do you know? Thanks again

[@LisaCrosbie]

Hi Karen, thank you. Unfortunately you can’t get a date type column without the year. The best way to do this is create 2 whole number columns, one for day and one for month, or a choice column for each. Using numbers also means you can run automation to find today’s birthdays or upcoming birthdays. I’ll do a video on that.

[@karenrees7370]

@@LisaCrosbie Many thanks Lisa, I will need the year also, so look fowward to your video!

[@masgitz]

Hey Lisa. I used an entity as lookup but can't get it to search with correct column. Looks like it wants to search primary column, but I didn't change this to anything useful. Anyway to change that?

[@LisaCrosbie]

You can change that by configuring the "Lookup View" for the table. Put in the columns you want to include in the lookup search.

[@jumanamahmoud2349]

Hello, Please can you help me in this case: I have model driven data verse platform and I need to make chioce field depend on yes or no field value

[@LisaCrosbie]

Can you tell me more about what you are trying to do? What will the dependency be? Do you want the choice field to show/hide based on a yes/no? Or do you want it to be mandatory? Or something else?

[@morganmetzger5832]

Do you know a way to create a column that counts the number of choices? Like here you picked gold and silver, but there's no calculated or roll up field that can say this record has 2 choices. How would you approach this? Hard for me being newbie to see its logic. Thanks for the series.

[@LisaCrosbie]

Hi Morgan, not that I know of and to be honest I’ve never heard anyone ask for that before. Can you give me an example of why you would want that, there might be another solution if I understand the use case or problem you are trying to solve?

[@morganmetzger5832]

@@LisaCrosbie In a word, gamification. A scoreboard with an easy import/export method based on 100 people inputting "choices" fields that define their representative work under contacts. I can do this by using a canvas app inside a model driven app, but the load time and licensing costs aren't really ideal.

[@rockstarsetsuna]

Hello Lisa , i work for a company with more than 100 service technicians and i am looking at a option to automate our Service reports which are currently being manually filled by our technicians at the clients location. i was wondering will Power Apps help me in building such a tool that can be utilised across our network.. we use Microsoft 365 suite company wide. Your suggestions would greatly help me .. Note : I will deep dive into your playlist , it's indeed a treasure trove of knowledge.

[@LisaCrosbie]

Absolutely, yes, replacing paper based forms is a common use case for Power Apps. You would most likely want to build a canvas app (see my tutorial here - studio.kzbin.infoq2gOaI7EtOc/edit ) and then you need to decide on a suitable data source - if you are working with substantial amounts of data and you want security, permissions and analytics, then a model-driven app built on Dataverse (as shown in this video) will serve you well. For a smaller and more basic data set you can work on SharePoint. Hope that helps and best of luck.

[@321jasie]

Hi Lisa, thanks for these tutorials - finding them really useful and your teaching style makes them easy to follow. Question about the file column kzbin.info/www/bejne/Z6LOeaObd9etaLM You mention using Sharepoint Integration for large files, something I would have to do with what I have in mind. Question is how would I go about this?

[@LisaCrosbie]

Hi Jason, I'll make a video on this shortly, thanks, stay tuned!