I was amazed on this tutorial as it was explained the steps by steps and enough details to understand, I was only unsatisfied on the the POP-UPs "3-2-1 boom" especially the insertion of basket vertical gallery... ^_^ this is not align on the objective on a beginner lesson... Hoping you can make a separate video to clear things out since there are already a lot of questions on it... thanks a lot for the tutorial, it was great, I was only stuck on the "3-2-1 boom' ^_^
Hi, and thanks! No separate video is coming on this, but the controls in the pop-up are these: - top left Text label has its Text-property set to: "Your shopping basket: " & CountRows(colShoppingBasket) & " - " & Text(varGlobalTotalPrice, "$##,###.00") --> also add an enter/newline after "basket: " to get the label's text on 2 lines - top right Text label is just a plain text for the Text-property: "Please fill out this form and confirm:" - for the gallery, add a blank vertical gallery and set colShoppingBasket as its Items-property. Inside the Gallery's element, add 1 Text label with the Text-property set to: ThisItem.ItemName & " - " Text(ThisItem.Price, "$##,###.00"). Add a Icon to the element as well and set Icon-property to Icon.Cancel . The OnSelect-formula for that icon is explained later on in the video. - for the form add an Edit Form without setting any properties after you have added it, this is tackled in the next video (Episode 5) - the 2 buttons I copied from the template screen and I just changed the Fill, HoverFill, PressedFill & BorderColor properties to green instead of orange/red. The OnSelect-formulas are explained later on in the video and in the next video (Episode 5). Hope this helps! - Jochen
Fantastic and clear video. Thank you. Could I ask how to work your magic on Datacards overlay? So a form, with some datacards, and a way to overlay a datacard with another datacard. For example: Last Modified by.... is one datacard and the other is "Created by..." datacard. Depending on whether I am creating a new record or editing a record, I want the right datacard to appear over (or under) the other. is this possible please?
Hi, and thanks! Well you could make the visibility of the Datacards dynamic, by using a formula instead of true/false in the Visible property. If you then make sure that they are in the correct order in your form, I bet you can make it look as if the one is on top of the other, while in reality it's just about which one is visible and which one isn't. There are more advanced ways to do this as well probably, Google is your friend here :-) Hope this helps! - Jochen
Hello again, Hope all is well. I am back again, needing some assistance with four final requirements of my app. Your videos have been extremely helpful (hence my return). I cannot seem to work these out on my own and have tried connecting with colleagues who are having similar troubles. Here are the requirements I need assistance with. 1. Persona: Line manager - Receives an email when direct report creates an order (testing/using PowerAutomate and approvals) 2. Persona: Line manager - must approve direct reports orders (can use email or app to approve) 3. Persona: Line manager - Can view a dashboard showing direct reports purchases (testing/using PowerBI) 4. Persona: Administrator - Can import stock details through Excel (testing/using Dataverse) Any help you can offer would be greatly appreciated! Thank you and I hope to hear from you soon.
Hi! I can give you a couple of pointers, here it goes: - 1: learn.microsoft.com/en-us/connectors/office365users/#get-manager-(v2) --> I would use that connector + function in the app (or in Power Automate, triggered when the record is created) to send an email to the manager of the user who creates the order - 2: use the same connector + action as in 1, or this might help as well: learn.microsoft.com/en-us/connectors/office365users/#get-direct-reports-(v2) --> this will give you a list of all the users who report directly to a certain user. You could use this in the app to get an overview of all the orders for a manager's team, so he can do some sort of approval action in there. - 3: Assuming your data is on SharePoint: learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list --> use this in combination with the connectors + actions from 1 & 2. If you data is in Dataverse: learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse - 4: if you want to automate this in Power Automate, your data has to be in a table in the Excel-file. The Power Automate can then loop over all the rows in the Excel-table and for each row create a record in your SharePoint or Dataverse database. Check out this link to get you started: office365atwork.com/sharepoint/power-automate-excel-to-sharepoint-list/#:~:text=Use%20Create%20item%20action%20to,like%20to%20get%20during%20conversion Hope this helps! - Jochen
@@CegekaBusinessSolutions one last question really quickly, how would I utilize these functionalities? Do I select On Select property? Something in settings in PowerApps to apply these properties?
That is a broad question because there are multiple ways of implementing all of this. Approvals are mostly done via Power Automate since you can use the Approvals-connector which is free and works pretty well. That being said, you can indeed trigger a Power Automate flow from a button's OnSelect in your PowerApp, check out more info here: learn.microsoft.com/en-us/power-apps/maker/canvas-apps/how-to/trigger-flow#create-the-power-automate-flow My advice would be to first think about the ideal way you would like it to work in the end, and then start Googling that scenario. No doubt you will find a lot of results and examples! Hope this helps! - Jochen
I have almost got this app working. Great great set of videos. Just wondering if you got help with this one thing. When I order the stationary and it goes into the basket and hit the button to confirm, the images do not come across and I get the error that the image doesn't exist, but obviously they do as it works in the ordering screen. Can it not be done or does it have to get added individually when the order is placed?? Thanks Gary
Thanks Gary! You kinda lost me with "the images do not come across"... Do you use/show the images in another place as well then? Because I only used them inside of those galleries on the New Order Screen. So let me know what you want to archieve exactly, maybe then I will understand the question. Thanks! - Jochen
Hi! Make sure you are adding the label to the gallery's ELEMENT by clicking that little pencil icon first when you have the entire gallery selected. To the Text-property of that label, add ThisItem.ItemName & " - " & Text(ThisItem.Price,"$##,###.00") as the value in the formula bar. To properly test it, make sure your shopping basket is not empty because then "ThisItem.ItemName" won't show anything for example, it will always be blank. Hope this helps! 👍
@@CegekaBusinessSolutions one other question for you, when displaying the products on the New Order Screen.. is there a formula I can put in to show the list price of an item and then a 20% discounted price at the same time?
Oh sure, just do something like this in the Text-property of that label: Text(ThisItem.ItemPrice, "$##,###.00") & " - " & Text(ThisItem.ItemPrice * 0.8, "$##,###.00") --> or instead of putting both inside of 1 text label, just use 2 text separate labels so you can give the discount one a different layout with a bold red color or something. 😎 Hope it helps!
Amazing course! Could you please show the formula for lblShoppingBasketContent_NOS in grConfirmationPopup_NOS ? I am trying to combine Item Counter and Total Price in one label but its not working properly. Thanks!
Hi Milosz, and thanks! Just start from this: "Your shopping basket: (" & varLocalItemCounter & " items - " & Text(varGlobalTotalPrice, "$##,###.00") & ")" and then add an enter/newline right before the first ( you see , to start the second line of the label on a new line. Hope that helps!
hi enjoyed you program. i am having a program entering a formal to have one column subtraction from another column and to add to another column. can you help we with this
Hi! It's just like adding any other label to a gallery, so make sure you are adding the label to the gallery's ELEMENT by clicking that little pencil icon first when you have the entire gallery selected. To properly test it, make sure your shopping basket is not empty because then "ThisItem.ItemName" won't show anything because it will always be blank. Hope this helps! 👍
Hi! Depending on how you want to do it, this will require a Premium license, but check out this link for some ideas to get started: www.spguides.com/power-automate-create-pdf/ You can trigger the Power Automate from your app if would like (Google search "trigger power automate from powerapp"), or have it triggered whenever a record is created in the SharePoint list (Google search "trigger power automate when sharepoint record is created"). Hope this helps! - Jochen
@@CegekaBusinessSolutions Thanks a lot, Yes we will use Premium Licence, Can you a make a Tutorial Video showing a button in this order system labeled "Print Order" and on click user to get PDF or HTML version of order with export to PDF Option
I go through the steps for the popup however the final formula gives a true response and not a false/blank one. Can you redirect where I maybe going wrong?
What are I doing wrong? My shopping basket list on my Popup is showing more than what I put in the shopping basket. When I review my Variables Collection is shows what I selected.
If the collection itself shows the correct data, you might want to check the Items-property on the gallery that shows the data in the popup. Hard to tell from here what could be wrong there, but that's the place to start checking I would think. Hope this helps! - Jochen
@@CegekaBusinessSolutions The fields in my Popup shopping basket are not visible in the Gallery, but the Fields list is showing they are link when I check Properties. When I click on each label or rectangle in my galShoppingBasket it show a blank label but "Text" function identifies what is there.
Hi Audrey! I can't really tell where the error would be to be honest... If there are in fact items in your colShoppingBasket-collection, and the gallery's Items-property is set to colShoppingBasket, and a Text label INSIDE of the Gallery has ThisItem.ItemName for example, it should show the values inside of the gallery. Hope this helps! - Jochen
@@CegekaBusinessSolutions I recheck everything referenced and they are in order, but not visible. Would the "layout" in my galShoppingBasket make a difference?
Fancied up your app yet? Let us know down in the comments! Feel free to contact us at www.cegeka.com/en/be/solutions/dynamics365/contact !
By far, this series is the best👍 (Microsoft POWER APPS) tutorial I have found,
Please, we need a lot more about it😊👋
Thanks! 😎
This is so helpful to me. Very detailed and understandable. Thank you
Thank you for the kind words, glad I could help! - Jochen
I was amazed on this tutorial as it was explained the steps by steps and enough details to understand, I was only unsatisfied on the the POP-UPs "3-2-1 boom" especially the insertion of basket vertical gallery... ^_^ this is not align on the objective on a beginner lesson... Hoping you can make a separate video to clear things out since there are already a lot of questions on it... thanks a lot for the tutorial, it was great, I was only stuck on the "3-2-1 boom' ^_^
Hi, and thanks! No separate video is coming on this, but the controls in the pop-up are these:
- top left Text label has its Text-property set to: "Your shopping basket: " & CountRows(colShoppingBasket) & " - " & Text(varGlobalTotalPrice, "$##,###.00") --> also add an enter/newline after "basket: " to get the label's text on 2 lines
- top right Text label is just a plain text for the Text-property: "Please fill out this form and confirm:"
- for the gallery, add a blank vertical gallery and set colShoppingBasket as its Items-property. Inside the Gallery's element, add 1 Text label with the Text-property set to: ThisItem.ItemName & " - " Text(ThisItem.Price, "$##,###.00"). Add a Icon to the element as well and set Icon-property to Icon.Cancel . The OnSelect-formula for that icon is explained later on in the video.
- for the form add an Edit Form without setting any properties after you have added it, this is tackled in the next video (Episode 5)
- the 2 buttons I copied from the template screen and I just changed the Fill, HoverFill, PressedFill & BorderColor properties to green instead of orange/red. The OnSelect-formulas are explained later on in the video and in the next video (Episode 5).
Hope this helps! - Jochen
Fantastic and clear video. Thank you. Could I ask how to work your magic on Datacards overlay? So a form, with some datacards, and a way to overlay a datacard with another datacard. For example: Last Modified by.... is one datacard and the other is "Created by..." datacard. Depending on whether I am creating a new record or editing a record, I want the right datacard to appear over (or under) the other. is this possible please?
Hi, and thanks! Well you could make the visibility of the Datacards dynamic, by using a formula instead of true/false in the Visible property. If you then make sure that they are in the correct order in your form, I bet you can make it look as if the one is on top of the other, while in reality it's just about which one is visible and which one isn't. There are more advanced ways to do this as well probably, Google is your friend here :-) Hope this helps! - Jochen
Hi Cegeka, would you please make a tutorial on dynamic forms?
Added to the list of ideas, thanks! 👌
Hello again,
Hope all is well. I am back again, needing some assistance with four final requirements of my app. Your videos have been extremely helpful (hence my return). I cannot seem to work these out on my own and have tried connecting with colleagues who are having similar troubles.
Here are the requirements I need assistance with.
1. Persona: Line manager - Receives an email when direct report creates an order (testing/using PowerAutomate and approvals)
2. Persona: Line manager - must approve direct reports orders (can use email or app to approve)
3. Persona: Line manager - Can view a dashboard showing direct reports purchases (testing/using PowerBI)
4. Persona: Administrator - Can import stock details through Excel (testing/using Dataverse)
Any help you can offer would be greatly appreciated! Thank you and I hope to hear from you soon.
Hi! I can give you a couple of pointers, here it goes:
- 1: learn.microsoft.com/en-us/connectors/office365users/#get-manager-(v2) --> I would use that connector + function in the app (or in Power Automate, triggered when the record is created) to send an email to the manager of the user who creates the order
- 2: use the same connector + action as in 1, or this might help as well: learn.microsoft.com/en-us/connectors/office365users/#get-direct-reports-(v2) --> this will give you a list of all the users who report directly to a certain user. You could use this in the app to get an overview of all the orders for a manager's team, so he can do some sort of approval action in there.
- 3: Assuming your data is on SharePoint: learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list --> use this in combination with the connectors + actions from 1 & 2. If you data is in Dataverse: learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse
- 4: if you want to automate this in Power Automate, your data has to be in a table in the Excel-file. The Power Automate can then loop over all the rows in the Excel-table and for each row create a record in your SharePoint or Dataverse database. Check out this link to get you started: office365atwork.com/sharepoint/power-automate-excel-to-sharepoint-list/#:~:text=Use%20Create%20item%20action%20to,like%20to%20get%20during%20conversion
Hope this helps! - Jochen
@@CegekaBusinessSolutions THANK YOU!!!
No worries! 👍
@@CegekaBusinessSolutions one last question really quickly, how would I utilize these functionalities? Do I select On Select property? Something in settings in PowerApps to apply these properties?
That is a broad question because there are multiple ways of implementing all of this. Approvals are mostly done via Power Automate since you can use the Approvals-connector which is free and works pretty well.
That being said, you can indeed trigger a Power Automate flow from a button's OnSelect in your PowerApp, check out more info here: learn.microsoft.com/en-us/power-apps/maker/canvas-apps/how-to/trigger-flow#create-the-power-automate-flow
My advice would be to first think about the ideal way you would like it to work in the end, and then start Googling that scenario. No doubt you will find a lot of results and examples!
Hope this helps! - Jochen
I have almost got this app working. Great great set of videos. Just wondering if you got help with this one thing. When I order the stationary and it goes into the basket and hit the button to confirm, the images do not come across and I get the error that the image doesn't exist, but obviously they do as it works in the ordering screen. Can it not be done or does it have to get added individually when the order is placed?? Thanks Gary
Thanks Gary! You kinda lost me with "the images do not come across"... Do you use/show the images in another place as well then? Because I only used them inside of those galleries on the New Order Screen. So let me know what you want to archieve exactly, maybe then I will understand the question. Thanks! - Jochen
Hi. Could you please describe how you got your shopping cart information to populate in the vertical gallery you added at 7:13?
Hi! Make sure you are adding the label to the gallery's ELEMENT by clicking that little pencil icon first when you have the entire gallery selected. To the Text-property of that label, add ThisItem.ItemName & " - " & Text(ThisItem.Price,"$##,###.00") as the value in the formula bar. To properly test it, make sure your shopping basket is not empty because then "ThisItem.ItemName" won't show anything for example, it will always be blank. Hope this helps! 👍
@@CegekaBusinessSolutions it worked! Thank you!!
@@CegekaBusinessSolutions one other question for you, when displaying the products on the New Order Screen.. is there a formula I can put in to show the list price of an item and then a 20% discounted price at the same time?
Oh sure, just do something like this in the Text-property of that label:
Text(ThisItem.ItemPrice, "$##,###.00") & " - " & Text(ThisItem.ItemPrice * 0.8, "$##,###.00")
--> or instead of putting both inside of 1 text label, just use 2 text separate labels so you can give the discount one a different layout with a bold red color or something. 😎 Hope it helps!
@@CegekaBusinessSolutions as always, it worked! haha. Thanks so much.
Amazing course!
Could you please show the formula for lblShoppingBasketContent_NOS in grConfirmationPopup_NOS ? I am trying to combine Item Counter and Total Price in one label but its not working properly. Thanks!
Hi Milosz, and thanks! Just start from this: "Your shopping basket: (" & varLocalItemCounter & " items - " & Text(varGlobalTotalPrice, "$##,###.00") & ")"
and then add an enter/newline right before the first ( you see , to start the second line of the label on a new line. Hope that helps!
Could you please thoroughly explain pop out feature as the formula given for the vertical gallery is not working
Hi! Not sure I understand which formula you are referring to, so if possible: please elaborate on which part doesn't work for you. - Jochen
hi enjoyed you program. i am having a program entering a formal to have one column subtraction from another column and to add to another column. can you help we with this
Hi Rick, and thanks! 😀 I'm not really sure I understand what you want/need to do, can you explain a bit more in detail please?
Can you show how to create a label inside the vertical gallery in the confirmation screen. mine is not working
Hi! It's just like adding any other label to a gallery, so make sure you are adding the label to the gallery's ELEMENT by clicking that little pencil icon first when you have the entire gallery selected. To properly test it, make sure your shopping basket is not empty because then "ThisItem.ItemName" won't show anything because it will always be blank. Hope this helps! 👍
@@CegekaBusinessSolutions its worked!! thank you
Nice! 👌
please show report sample how to print order in pdf or html with export to pdf option
Hi! Depending on how you want to do it, this will require a Premium license, but check out this link for some ideas to get started: www.spguides.com/power-automate-create-pdf/
You can trigger the Power Automate from your app if would like (Google search "trigger power automate from powerapp"), or have it triggered whenever a record is created in the SharePoint list (Google search "trigger power automate when sharepoint record is created").
Hope this helps! - Jochen
@@CegekaBusinessSolutions Thanks a lot, Yes we will use Premium Licence, Can you a make a Tutorial Video showing a button in this order system labeled "Print Order" and on click user to get PDF or HTML version of order with export to PDF Option
Hi! Thanks for the suggestion, we have added it to our list for possible future videos. 👍
I go through the steps for the popup however the final formula gives a true response and not a false/blank one. Can you redirect where I maybe going wrong?
Hi Audrey! I don't think I fully understand the question/problem, which "final formula" are you referring to exactly? - Jochen
@@CegekaBusinessSolutions I figured it out. Thanks!
Nice, good job! 👌
What are I doing wrong? My shopping basket list on my Popup is showing more than what I put in the shopping basket. When I review my Variables Collection is shows what I selected.
If the collection itself shows the correct data, you might want to check the Items-property on the gallery that shows the data in the popup. Hard to tell from here what could be wrong there, but that's the place to start checking I would think. Hope this helps! - Jochen
@@CegekaBusinessSolutions The fields in my Popup shopping basket are not visible in the Gallery, but the Fields list is showing they are link when I check Properties. When I click on each label or rectangle in my galShoppingBasket it show a blank label but "Text" function identifies what is there.
Hi Audrey! I can't really tell where the error would be to be honest... If there are in fact items in your colShoppingBasket-collection, and the gallery's Items-property is set to colShoppingBasket, and a Text label INSIDE of the Gallery has ThisItem.ItemName for example, it should show the values inside of the gallery. Hope this helps! - Jochen
@@CegekaBusinessSolutions I recheck everything referenced and they are in order, but not visible. Would the "layout" in my galShoppingBasket make a difference?
Hi! If it is purely the visibility that's not working as expected, check the Visible-property for that control. - Jochen
It’s a little frustrating when you snap your fingers and create all new lines of texts and code and don’t show how it was done.
Well, if you would tell me where you got stuck, I'm more than happy to help you! 👍 - Jochen