Hi Everyone, I have moved my recording area to a new room and the sound was a little off because the room was so empty! Working on it, sound issues should be fixed by next week!
@14:36 I guess I did a mistake by creating sharepoint lists with all sorts of column types and my patch function is not working properly. For the same topic I have a question: Which data type should I use for foreign keys from other sharepoint lists? Or which data types should I use in juction tables to solve many to many relationships?
Hi Murat, it is still possible to do it with different data types, but it may just become more difficult to maintain in the future. Sometimes I might prefer a choice field instead of a single line text. This part is just preference. And maybe even a Power BI/Data Scientist may disagree with my preference. But the data type for foreign keys from other sharepoint lists should probably most likely be a number type, and you could match that up with the SharePoint ID. Many to Many relationships gets much more difficult because SharePoint is not really a relational database. I will designing more and more and we may go to Dataverse for Teams or even Dataverse/SQL for real relational databases.
Great videos @andrewhess123. How do you add multiple selections? I want the combo box to have only a limited number of choices, but when I cannot figure out what the update properties are.
Help!! Hi Andrew, I’ve been watching some of your videos but I still haven’t managed to fix my issue! I think I’m very lost.. basically I’m Trying to capture some information in a power app and then using a flow, translate this information into a Microsoft word template. I just can’t seem to link it all together, I have the relevant combo boxes in the power app and also the developer text boxes within the word doc. I have also created a flow but can’t seem to trigger it, I have a submit button at the end of the power app, is there a way to connect this button to the flow? I can’t seem to get the code correct in the formula bar. Any help is appreciated 😊 thanks
Hi Matt, so in order to trigger your flow in Power Apps you need to call on your Flow. ua-cam.com/video/Z6ecHW51U5k/v-deo.htmlsi=r9jP5Iy--lz9WLzE&t=337 You can see in this link where I call the flow, in this video the flow is called FavoriteForPowerApps, then you do .Run with the parameters between the ().
@@andrewhess123 thanks! I have the flow working now, however I’m struggling with my combo boxes and Drop down boxes. In your video you have the selected.value option, I don’t? Any ideas on why?
@@matthewshimmin764 Theres a few reasons to why, it could be the difference between modern or classic, or the difference between dropdowns or comboboxes. But if you convert it to a variable and pass it you should be able to get it. Also, it could be more and more complex like if you have a multi-select.
@@andrewhess123 hi Andrew, how does one convert it to a variable? My formula box looks like this at the moment: ‘test’.run(FullName2.value, FullName1.value, DropdownCanvas1. ? )
Sorry. Frustrated powerapp beginner here. Why do all these videos of all these fantastic forms work? Because they use Sharepoint Lists. I have yet to see a successful video or explanation on how to achieve the same results using SQL Server. And yes I did everything I could find - primary key on my table, user with full read write access (owner actually), and yet I still cannot get these damn edit forms to edit anything! They are all "stuck" as display only forms. Arrgh!
Hey LatinoTropico, so I have done a few apps with SQL Server on-premise. (so its possible) Actually my first ever production power apps used SQL.. but I guess the main reason is the cost of SQL and it being more difficult to demo. Also SQL requires Power Apps premium for every user who uses it. Usually if people go Power Apps Premium they go straight to Dataverse instead of SQL. I do agree that SQL is actually the most secure way to store the data. My suggestion before I can make a video is start very very very simple. Do a Patch(dbo.yourdatabase,Defaults(),{title:title.text}). Start super simple, then go from there. You can probably find a blog on a simple patch statement for SQL. Also Darren Neese does LIVE demos of using SQL: ua-cam.com/video/o3GXEnLBgPU/v-deo.html
@@andrewhess123 hey thanks for taking my huff and puff. Patch(). I saw glimpses of this during my battles in middle earth, like glints of diamonds in the trough. Lol... Yeah will look at them again this time. And thanks for the suggestions. Cheers from down under.
@@LatinoTropico Yeah Microsoft pushes Dataverse more, but some people are more comfortable in SQL. SQL in my opinion is just a little bit more secure than Dataverse. I would say whichever you prefer is best. Dataverse isn't as hard to learn while SQL could have a larger learning curve.
Hi Everyone, I have moved my recording area to a new room and the sound was a little off because the room was so empty! Working on it, sound issues should be fixed by next week!
Thanks for this video, Andrew. Your training style is so easy to follow along with.
Appreciate it so much! Thank you Wendy!
Cool. Can't wait to see how you fix the 2k delegation thing.
Check out the newest video, we crush delegation 😆ua-cam.com/video/sVJPqC6h5-o/v-deo.html
hi thank you for you video. When i am using combobox to enter data, column of table which is used Combobox is showing me unknown code. How i fix it?
@14:36 I guess I did a mistake by creating sharepoint lists with all sorts of column types and my patch function is not working properly. For the same topic I have a question: Which data type should I use for foreign keys from other sharepoint lists? Or which data types should I use in juction tables to solve many to many relationships?
Hi Murat, it is still possible to do it with different data types, but it may just become more difficult to maintain in the future. Sometimes I might prefer a choice field instead of a single line text. This part is just preference. And maybe even a Power BI/Data Scientist may disagree with my preference.
But the data type for foreign keys from other sharepoint lists should probably most likely be a number type, and you could match that up with the SharePoint ID. Many to Many relationships gets much more difficult because SharePoint is not really a relational database.
I will designing more and more and we may go to Dataverse for Teams or even Dataverse/SQL for real relational databases.
Great videos @andrewhess123. How do you add multiple selections? I want the combo box to have only a limited number of choices, but when I cannot figure out what the update properties are.
I was literally just going nuts trying to fix defaults in Forms... Ha
Perfect, my new video on Monday goes over it even more!
Help!! Hi Andrew, I’ve been watching some of your videos but I still haven’t managed to fix my issue! I think I’m very lost.. basically I’m Trying to capture some information in a power app and then using a flow, translate this information into a Microsoft word template. I just can’t seem to link it all together, I have the relevant combo boxes in the power app and also the developer text boxes within the word doc. I have also created a flow but can’t seem to trigger it, I have a submit button at the end of the power app, is there a way to connect this button to the flow? I can’t seem to get the code correct in the formula bar. Any help is appreciated 😊 thanks
Hi Matt, so in order to trigger your flow in Power Apps you need to call on your Flow. ua-cam.com/video/Z6ecHW51U5k/v-deo.htmlsi=r9jP5Iy--lz9WLzE&t=337
You can see in this link where I call the flow, in this video the flow is called FavoriteForPowerApps, then you do .Run with the parameters between the ().
Let me know if that helps? But that whole video uses the new Power Apps V2 trigger in Power Automate to start the flow in Power Apps 😀
@@andrewhess123 thanks! I have the flow working now, however I’m struggling with my combo boxes and Drop down boxes. In your video you have the selected.value option, I don’t? Any ideas on why?
@@matthewshimmin764 Theres a few reasons to why, it could be the difference between modern or classic, or the difference between dropdowns or comboboxes. But if you convert it to a variable and pass it you should be able to get it. Also, it could be more and more complex like if you have a multi-select.
@@andrewhess123 hi Andrew, how does one convert it to a variable? My formula box looks like this at the moment:
‘test’.run(FullName2.value, FullName1.value, DropdownCanvas1. ? )
Sorry. Frustrated powerapp beginner here. Why do all these videos of all these fantastic forms work? Because they use Sharepoint Lists. I have yet to see a successful video or explanation on how to achieve the same results using SQL Server. And yes I did everything I could find - primary key on my table, user with full read write access (owner actually), and yet I still cannot get these damn edit forms to edit anything! They are all "stuck" as display only forms. Arrgh!
Hey LatinoTropico, so I have done a few apps with SQL Server on-premise. (so its possible) Actually my first ever production power apps used SQL.. but I guess the main reason is the cost of SQL and it being more difficult to demo. Also SQL requires Power Apps premium for every user who uses it. Usually if people go Power Apps Premium they go straight to Dataverse instead of SQL.
I do agree that SQL is actually the most secure way to store the data.
My suggestion before I can make a video is start very very very simple. Do a Patch(dbo.yourdatabase,Defaults(),{title:title.text}). Start super simple, then go from there. You can probably find a blog on a simple patch statement for SQL.
Also Darren Neese does LIVE demos of using SQL: ua-cam.com/video/o3GXEnLBgPU/v-deo.html
@@andrewhess123 hey thanks for taking my huff and puff. Patch(). I saw glimpses of this during my battles in middle earth, like glints of diamonds in the trough. Lol... Yeah will look at them again this time. And thanks for the suggestions. Cheers from down under.
Also... Why not go straight to Dataverse? Isn't that the preferred method as per all the docs? IE... security, yada yada?
@@LatinoTropico Yeah Microsoft pushes Dataverse more, but some people are more comfortable in SQL. SQL in my opinion is just a little bit more secure than Dataverse. I would say whichever you prefer is best. Dataverse isn't as hard to learn while SQL could have a larger learning curve.