Have you managed to visualize your data? Let us know down in the comments! Feel free to contact us at www.cegeka.com/en/be/solutions/dynamics365/contact !
You started off your tutorial so well from scratch in episode 1,was surprised how you didn't think it was necessary to include how you created your sharepoint lists considering how detailed of a person you have been.
Correct! We decided last minute to not use that list in this series, so it's okay if you don't have that one because you won't need it in the app. Sorry for the confusion. Hope this helps! - Jochen
Thanks! Sorry I don't have a dataset to share, but at the end of the video description you can find how to set up the SharePoint lists. Hope that helps! - Jochen
your lecture is so good for beginners and i am very impress with you because in your video sound quality,video quality,and your technique all are good but i think for this project you can share a data.
Thank you for the kind words, much appreciated! I don't have any data to share, but you can find the setup for the SharePoint lists in the video description. Hope this helps! - Jochen
Hi, @CegekaBusiness Solutions, I have a gallery form that is really long. Do you have a video that instructs how to break the form up into smaller buckets? Perhaps tabs across the top that segments the form's content?
Hi Monica! Not 100% sure what you mean by "gallery form", but maybe this can help: www.matthewdevaney.com/power-apps-tabbed-form-with-an-awesome-looking-design/ Hope this helps! - Jochen
Hi Jochen, I have learned many things about power apps thanks to you.🌼🌼 I have a question about SharePoint list. In your video at 10:58, I see in the left-hand side many different lists and you can navigate between them, I created a list but I want to make categories like you, but I couldn't do it, I have checked video's description, but I couldn't see how you create these categories. Could you please help me 🌻🌻
Hi! Please check out this support website: support.microsoft.com/en-au/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083 The actual lists and fields you need to create for this app are in the video description. I do think it's possible to block users from creating lists on a SharePoint-site, so make sure you have the necessary permissions to do that on the site where you are trying to create them. Hope this helps! - Jochen
@CgekaBusinessSolutions : I appreciate the clarifications you can provide on these topics. Your expertise will be valuable in helping me navigate these aspects effectively. Actually, a SharePoint license is required to store the data. Can I store data in SharePoint without a license?
Hi! You need a SharePoint license indeed. Check out this link for some more info: www.microsoft.com/en-us/microsoft-365/sharepoint/compare-sharepoint-plans Hope this helps!
Your videos are very helpful for the beginners but could you please share the SharePoint list or data with us to practice and connect the data, which you have used in this video? Thanks
Thanks! You can find the setup for the SharePoint-lists in the video description. I don't have any data to share with you, but you can just fill the lists with your own data once you have created them. Hope this helps! - Jochen
On the existing order screen you jumped all the steps and can you show us how you inserted your data to the vertical gallery and also how you created a column above
Hi! The "column headings" are just Text labels that I added there, they are not connected to the Gallery in any way. So instert Text labels for all column headings that you want to see, and set the Text-property for each label accordingly with "ID", "Date", "#Items",... The fields inside the vertical gallery in that screen are also just Text labels that I added INSIDE of the Gallery's element (just like we did in the other Galleries on the New Order Screen). Then set the Text-property for each field to ThisItem.Title, ThisItem.OrderDate, ThisItem.Status.Value, ... depending on which data you want to see in the Gallery. Hope this helps! - Jochen
Hi Jochen, how do we make sure that the Orderheader sharepoint list gets all the information from the app? Is there some kind of connection that has to be done?
Hi! If you establish the connection that I start explaining around 2:20 in the video, that's enough for now. In the final video (episode 5) we will make sure that our order is properly saved to that SharePoint-list. Hope that helps! - Jochen
Hi, thanks! 😀 I don't have dummy data to share with you, but check the video description for the complete setup of the SharePoint lists. Hope this helps! - Jochen
The tutorial is really helpful just that I got lost or could not get it clear the SharePoint creation method you only showed an existing SharePoint that I have no idea of how it was created
Hi! At the end of the video description you can find how to set up the SharePoint lists that I used in the video. I don't have any data to share, so feel free to fill the lists you create with some dummy data yourself. Hope that helps! - Jochen
Hello, as an Access developer, I really appreciate Power Apps as it seems to be "Access in the cloud". An application creation system, just like Access. Being an Access developer, I am really frustrated by the glossing over how your tables are created. I get it that you had them prepared before hand, problem is, I don't. I am trying to create them according to your notes below, but how do you create the ID fields? Are they an Autonumber equivalent? How do you make that? Did you just import a list from an excel workbook?
Hi! The ID fields are just a number field in SharePoint that I have filled manually, but you could say that those are the unique identifier numbers for each record. I happened to mimic an auto-incrementing number sequence for both lists, but it's not necessary really since real life item numbers would probably also not be like that I guess. So I just manually filled both SharePoint lists with data, no Excel import. Feel free to create your own items and categories, as long as you use the same field types and names, it doesn't really matter. Hope that helps! - Jochen
@@CegekaBusinessSolutions Thats Great. I can create my own items, but how do I ensure my data integrity across the different tables? In Access an autonumber field is used to create relationships between the different tables. How does that work here? Do I create a field for numbering the records or can I use a built in GUID or is there a way to create an autonumber? I have been trying to figure that part out as duplicating my previous Access applications is why I am learning Power Apps.
Hi! To create a relational database within SharePoint, you would probably need a combination of the default ID-field, maybe a "calculated" field, and some Lookup-columns. Hopefully these links can provide more clarity on that: support.microsoft.com/en-us/office/create-list-relationships-by-using-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632 techcommunity.microsoft.com/t5/sharepoint/auto-increment-number-field-in-a-sharepoint-list/m-p/1141477 crmtipoftheday.com/1402/why-you-should-not-use-microsoft-lists-sharepoint-lists-for-business-critical-power-apps/ Disclaimer: I haven't used any of those in my training scenario, since the focus was purely on PowerApps design and not on the data structure - Jochen
Hi Jochen, great video. Thank you for this! One trivial question for you. I am wondering how do you store date "from the app" to the "OrderHeader" list ('1, "45)? Can you develop on this, please? Thank you
How did you get that data (OfficeOrderingSite) in SharePoint? I'm performing the practical but now I'm stuck on that point. Please tell me as soon as possible. :)
Hi! The full setup for the SharePoint data lists is in the video description. After creating it I just manually filled the lists with some data and images. Hope this helps! - Jochen
I like your videos. I follow the video to the letter, but when I add the images from CategotyImage no images appear. Text from Title is displayed. What am I doing wrong?
Thanks! Maybe you have added a Label control instead of an Image control, since you see a Text property? If so, delete that Label control, add an Image control instead and in the Image property put ThisItem.CategoryImage. Hope that helps! - Jochen
@@CegekaBusinessSolutions Hello again I expressed myself a little wrong here. The title field appears in the text field. but not the image control, it's blank
Is there an actual image in that column on SharePoint? And have you set the Image-property of the Image-control to ThisItem.? If you have, it will be hard to spot the error from here I'm afraid, sorry... - Jochen
Hello,I'm struggling to replicate what you did on the existing order screen,the part where you snapped your fingers and said "magic" with no explanation on the workings,personally I've added the columns (ID,Date,Items etc),My issue is now the vertical gallery,how exactly did you fill in those properties within the V. gallery ?
Hi! I copied the vertical gallery from the template screen and just resized it a little bit to fit the screen. The value for the Items-property of the vertical gallery is shown in the video when I explain about the toggle I used, since that toggle's value is used as a filter in that Items-formula. Inside the gallery's element are all just text label controls with the Text-property set to ThisItem.ID, ThisItem.OrderDate, ThisItem.Status.Value, ... and so on (depending on which fields you want to see there). That's all there is to explain really, hope that helps! - Jochen
Hi! That is not a default option you can choose no, but maybe you can create something like that from scratch with a so-called "custom component" That's a somewhat more advanced topic, but feel free to google it, maybe someone already create something like that and you can re-use it! - Jochen
Sir, Could you also please give the instructions to create the list "OrderLines" which is not there in the sharepoint database create instructions. please help
Hi! Sorry for the confusion, but in the end we decided to leave that list out of scope for this video series, so you won't need it to follow along with the videos since it will not be used for anything at all.👍 - Jochen
Hi! Yes you could, but the csv file would be "inside" of the app's internal memory. That will make it harder to maintain if the data itself changes (new records, updated records, ...). The image-file might also be a challenge to implement when using a csv-file but it's not impossible I think. The advantage of using SharePoint for example, is that the "database" is completely outside of the app, so maintaining the data is super easy. Hope this helps! - Jochen
Hi Sunita, we didn't use excel sheets in this demo, only Sharepoint lists. Since they were set up within a temporary demo environment, they have all been deleted by now... so there is nothing to share. However, we used very simple Sharepoint lists , so it's really easy to set up yourself!
Hi! We have just added the setup at the bottom of the video description, so now you can create the exact same SharePoint site and lists yourself if you want to follow along! 👍
I am getting an error . Under NOS , I selected the whole V gallery the after try to code on its TamplateFill with "If(ThisItem.IsSelected,RGBA(168,0,0,0.25),Transparent)"
Hi! The formula seems to be correct, but instead of "Transparent" try "Color.Transparent", hope that fixes the issue. So "If(ThisItem.IsSelected, RGBA(168,0,0,0.25), Color.Transparent)" would be the formula to use. They have changed it a while ago, so that you HAVE to use Color. first now. Instead of just using "Red" in a formula, you now have to use "Color.Red". Same goes for all other enumerations, like for example the Displaymode property: instead of just using "Disabled" when using it in a formula, you have to use "DisplayMode.Disabled". Hope that helps! - Jochen
All great content, but for some reason, the TemplateFill function doesnt work no matter what I do in more than 1 Gallery.... it just doesn't highlight the items selected and I dont know why!
Thanks! Hmmm, not sure what could cause that. If you for example just put the formula "If(ThisItem.IsSelected, Color.Yellow, Color.Transparent)" in the TemplateFill-property's formula for the Categories-gallery, it should work when you go into preview-mode and select a category. Hope this helps! - Jochen
Hi Jochen @CegekaBusinessSolutions and thanks for your prompt reply. It worked in the end With the ColorTransparent code with a grey color i used "If(ThisItem.IsSelected, RGBA(105, 112, 122, 0.25), Color.Transparent) " I have another question though as I'm trying to build a Products and Services request application inspired on your app tutorial. 1) Is it possible to create the Category gallery with some sort of tab or toggle so that the users can switch between Products or Services, then the Items list would also show the Products Items and Services items respectively? 2) If not, then I'm continuing to build it with a 2nd screen for Service request orders similar to the products, however, I would like the Existing Requests screen to show all products and Services combined in the list before submitting.... Is this doable?
Nice, good that it works now! Depending on which control you are going to use, you will also have to update the filter in your Items-property for the Items-gallery of course. If you use a radio button called radChoice, you can use radChoice.Selected.Value in your filter for example. So if you have decided which control you want to use to have the user select Products and/or Services, just do a Google search on how that control works and how you can use its selected value in a gallery filter. Hope this helps! - Jochen
Hi! Since there are possibly more than 1 items you want to save at the same time, you will need a ForAll(...) + Patch(...) construction. Check out this link to get you started: www.matthewdevaney.com/patch-multiple-records-in-power-apps-10x-faster/ It will be something like this: ForAll(colShoppingBasket, Patch(OrderLines, {OrderId: , ItemId: ThisRecord.ItemId, Price: ThisItem.ItemPrice}));. Hope that helps! - Jochen
Hi Amy! This is just one example of how these data sources could be set up, but the same thing can definitely be accomplished with other setups as well. 👍
Not if you want to keep your data efficiently and without duplication and errors. Normalization is part of creating a database. A typical excel "database" for people would include a city column. If I had a list of 100s of people who all live in Chilliwack, but one of those cities for one of those people was spelt wrong, Chiliwack, I would end up missing that person in a mailing list for Chilliwack. In fact that one person might never get anything because the city is spelt wrong. A people table with just the information for that person with a column indicating which row to look at in my City table allows me to enter Chilliwack once and never make the mistake of spelling it wrong because I would pick it from a list when adding a new person who lives in Chilliwack. Relational databases break information into groupings of related data, this is normalization. There is a lot more to it, but those are the basics.
Good point, data structure is a major part of every development! However, just like "boolean logic", "basic coding statements", "how to use SharePoint", ... it was deliberately not included in the scope of this series. - Jochen
Hi! Just to make sure: you actually have orders in the SharePoint-list already with your email in the Email column, right? If so, please paste the code here that you have for the Items-property of that gallery. - Jochen
Can you type in the code manually maybe? And also let me know what the actual error message is that you get. Otherwise it will be hard to pinpoint the issue from here. - Jochen
Hi! I have put that logic on the "Clear shopping basket button" on the New Order Screen, and it is automatically selected when that screen becomes visible by using Select(btnClearShoppingBasket_NOS) as the code in the OnVisible-property for that screen. If I recall correctly, I show that in Episode 3 of this series. Hope this helps! - Jochen
Hi! We have just added the setup at the bottom of the video description, so now you can create the exact same SharePoint site and lists yourself if you want to follow along! 👍
Hi! We don't have anything to "share" really, but check the video description (at the bottom) for the very simple setup of the Sharepoint data. Hope this helps!
Hi! In this series I use SharePoint Online, not an on-premise SharePoint. That's also a possibility though, if you Google "powerapps sharepoint on premise" you will find some tutorials on that as well. Hope this helps! - Jochen
1410: Something is off here. When I hover over the "User" portion of the formula, it shows a Record, instead of Text, and doesn't show my email address (even though it's in the list).. hmmm?
The User() function returns a record indeed, with a couple of fields IN it. So most of the time you won't want to use the entire record, but just one of those fields. To get the field values, you have to use User().Email or User().FullName in your formules for example. Hope that helps!
08:24 - Nothing happens here. The top item doesn't turn red, and either way, I can't select any of the items in the gallery when I Preview. Any idea what I did wrong?
You are always selecting an item when you click inside of a gallery in preview mode, that's how they have developed it. You just can't 'see' it by default, that's why we need that formula. Make sure you put the If(ThisItem.IsSelected, ...) formula inside the correct property, it should work. (TemplateFill property on the Gallery control) Hope this helps!
Everything fine until Order header .. why are you not talking about sharepoint lists in detail.. this video is complete only when you cover that...I am struggling inbetween
is there a way to do this without the use of SharePoint and using excel i tried but its not working when i used Thisitem.CategoriesImage it didn't bring anything
Hi! To be honest, I don't know if you can add an "Image"-column in Excel like you can in Sharepoint, so that might already block you from using it in a similar way. A possible workaround would be to store the image as a Base64-text in the Excel column, and then try and "decode" that Base64-text back to an image inside of the PowerApps-gallery where you are showing it. Google "PowerApps show base64 image" or something like that and you will probably find some info that will get you there. Hope this helps! - Jochen
@@CegekaBusinessSolutions Actually i did solve it by adding it as an Image link and i did the same thing as you did it worked just perfectly just imported the tables from the excel file thank you so much
is Collection feature not available on the free version of power apps? the formula clearcollectiions or colcategories seems to not work for me is there any work around for this?
Collections and their formulas are always available, so I would double check if you have put the correct formula in the correct property. ClearCollect(colCategories, Categories) should work if 'Categories' is in fact the name of your external data source. Hope this helps! - Jochen
Hi! I'm not sure I understand the problem, but can you try ThisItem.Status.Value in the Text-property of the label you are displaying? (instead of just ThisItem.Status) Hope this helps! - Jochen
Have you managed to visualize your data? Let us know down in the comments! Feel free to contact us at www.cegeka.com/en/be/solutions/dynamics365/contact !
You started off your tutorial so well from scratch in episode 1,was surprised how you didn't think it was necessary to include how you created your sharepoint lists considering how detailed of a person you have been.
Hi! Instructions for the SharePoint lists setup are in the video descriptions. Hope that helps! - Jochen
@@CegekaBusinessSolutions OrderLines list is not in the instructions
Correct! We decided last minute to not use that list in this series, so it's okay if you don't have that one because you won't need it in the app. Sorry for the confusion. Hope this helps! - Jochen
This series is the best Microsoft POWER APPS tutorial on RUclips...and anywhere else!
Thanks, glad you liked it! - Jochen
By far, this series is the best👍 (Microsoft POWER APPS) tutorial I have found,
Please, we need a lot more about it😊👋
Thanks! 😎
Best tutorials i got on Power Apps, thank you so much.
Great to hear! You are very welcome! :-) - Jochen
Excellent video with step by step clarity. Just struggling with existing order could you please guide or make vdo?
Thanks, glad you liked it! What is it exactly that you are struggling with on the Existing Orders Screen? - Jochen
Great Video for someone just trying to do hands-on powerapps...do you have a dataset in Excel file which I can use to import in SharePoint?
Thanks! Sorry I don't have a dataset to share, but at the end of the video description you can find how to set up the SharePoint lists. Hope that helps! - Jochen
Very helpful!! Thanks for posting this tutorial.
Glad it was helpful, thanks!
your lecture is so good for beginners and i am very impress with you because in your video sound quality,video quality,and your technique all are good but i think for this project you can share a data.
Thank you for the kind words, much appreciated! I don't have any data to share, but you can find the setup for the SharePoint lists in the video description. Hope this helps! - Jochen
Hi, @CegekaBusiness Solutions, I have a gallery form that is really long. Do you have a video that instructs how to break the form up into smaller buckets? Perhaps tabs across the top that segments the form's content?
Hi Monica! Not 100% sure what you mean by "gallery form", but maybe this can help: www.matthewdevaney.com/power-apps-tabbed-form-with-an-awesome-looking-design/
Hope this helps! - Jochen
Hi Jochen, I have learned many things about power apps thanks to you.🌼🌼 I have a question about SharePoint list. In your video at 10:58, I see in the left-hand side many different lists and you can navigate between them, I created a list but I want to make categories like you, but I couldn't do it, I have checked video's description, but I couldn't see how you create these categories. Could you please help me 🌻🌻
Hi! Please check out this support website: support.microsoft.com/en-au/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083 The actual lists and fields you need to create for this app are in the video description.
I do think it's possible to block users from creating lists on a SharePoint-site, so make sure you have the necessary permissions to do that on the site where you are trying to create them. Hope this helps! - Jochen
amazing video. thank you.
Glad you liked it, thanks Jason! 👍
@CgekaBusinessSolutions : I appreciate the clarifications you can provide on these topics. Your expertise will be valuable in helping me navigate these aspects effectively. Actually, a SharePoint license is required to store the data. Can I store data in SharePoint without a license?
Hi! You need a SharePoint license indeed. Check out this link for some more info: www.microsoft.com/en-us/microsoft-365/sharepoint/compare-sharepoint-plans Hope this helps!
Thank. Looks super useful and was fun learning
Thanks, glad you enjoyed it! - Jochen
Your videos are very helpful for the beginners but could you please share the SharePoint list or data with us to practice and connect the data, which you have used in this video? Thanks
Thanks! You can find the setup for the SharePoint-lists in the video description. I don't have any data to share with you, but you can just fill the lists with your own data once you have created them. Hope this helps! - Jochen
On the existing order screen you jumped all the steps and can you show us how you inserted your data to the vertical gallery and also how you created a column above
Hi! The "column headings" are just Text labels that I added there, they are not connected to the Gallery in any way. So instert Text labels for all column headings that you want to see, and set the Text-property for each label accordingly with "ID", "Date", "#Items",...
The fields inside the vertical gallery in that screen are also just Text labels that I added INSIDE of the Gallery's element (just like we did in the other Galleries on the New Order Screen). Then set the Text-property for each field to ThisItem.Title, ThisItem.OrderDate, ThisItem.Status.Value, ... depending on which data you want to see in the Gallery.
Hope this helps! - Jochen
Superb. You make PowerApps look so simple. Thank you so much!
You are welcome! ☺️👌
Hi Jochen, how do we make sure that the Orderheader sharepoint list gets all the information from the app? Is there some kind of connection that has to be done?
Hi! If you establish the connection that I start explaining around 2:20 in the video, that's enough for now. In the final video (episode 5) we will make sure that our order is properly saved to that SharePoint-list. Hope that helps! - Jochen
Hi, great video.
Can you please give or where i get this dummy data tables that you show in sharepoint
Hi, thanks! 😀 I don't have dummy data to share with you, but check the video description for the complete setup of the SharePoint lists. Hope this helps! - Jochen
How about a Power Pages tutorial! Love your work!
Thanks! Power Pages might be a future topic yes, thanks for the suggestion! 😎 - Jochen
The tutorial is really helpful just that I got lost or could not get it clear the SharePoint creation method you only showed an existing SharePoint that I have no idea of how it was created
Hi! At the end of the video description you can find how to set up the SharePoint lists that I used in the video. I don't have any data to share, so feel free to fill the lists you create with some dummy data yourself. Hope that helps! - Jochen
Thank You for this :)
You're welcome! Hope we could help.
Hello, as an Access developer, I really appreciate Power Apps as it seems to be "Access in the cloud". An application creation system, just like Access.
Being an Access developer, I am really frustrated by the glossing over how your tables are created. I get it that you had them prepared before hand, problem is, I don't. I am trying to create them according to your notes below, but how do you create the ID fields? Are they an Autonumber equivalent? How do you make that? Did you just import a list from an excel workbook?
Hi! The ID fields are just a number field in SharePoint that I have filled manually, but you could say that those are the unique identifier numbers for each record. I happened to mimic an auto-incrementing number sequence for both lists, but it's not necessary really since real life item numbers would probably also not be like that I guess. So I just manually filled both SharePoint lists with data, no Excel import. Feel free to create your own items and categories, as long as you use the same field types and names, it doesn't really matter. Hope that helps! - Jochen
@@CegekaBusinessSolutions Thats Great. I can create my own items, but how do I ensure my data integrity across the different tables? In Access an autonumber field is used to create relationships between the different tables. How does that work here? Do I create a field for numbering the records or can I use a built in GUID or is there a way to create an autonumber? I have been trying to figure that part out as duplicating my previous Access applications is why I am learning Power Apps.
Hi! To create a relational database within SharePoint, you would probably need a combination of the default ID-field, maybe a "calculated" field, and some Lookup-columns. Hopefully these links can provide more clarity on that:
support.microsoft.com/en-us/office/create-list-relationships-by-using-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632
techcommunity.microsoft.com/t5/sharepoint/auto-increment-number-field-in-a-sharepoint-list/m-p/1141477
crmtipoftheday.com/1402/why-you-should-not-use-microsoft-lists-sharepoint-lists-for-business-critical-power-apps/
Disclaimer: I haven't used any of those in my training scenario, since the focus was purely on PowerApps design and not on the data structure - Jochen
@@CegekaBusinessSolutions I found another RUclips video to help me with that. Thanks for your help.
No worries! 👍
Hi Jochen, great video. Thank you for this! One trivial question for you. I am wondering how do you store date "from the app" to the "OrderHeader" list ('1, "45)? Can you develop on this, please? Thank you
Hi, thanks! Keep watching the playlist, that data push is covered in the very last episode! - Jochen
How did you get that data (OfficeOrderingSite) in SharePoint? I'm performing the practical but now I'm stuck on that point. Please tell me as soon as possible. :)
Hi! The full setup for the SharePoint data lists is in the video description. After creating it I just manually filled the lists with some data and images. Hope this helps! - Jochen
I like your videos. I follow the video to the letter, but when I add the images from CategotyImage no images appear. Text from Title is displayed. What am I doing wrong?
Thanks! Maybe you have added a Label control instead of an Image control, since you see a Text property? If so, delete that Label control, add an Image control instead and in the Image property put ThisItem.CategoryImage. Hope that helps! - Jochen
@@CegekaBusinessSolutions Hello again
I expressed myself a little wrong here.
The title field appears in the text field. but not the image control, it's blank
Is there an actual image in that column on SharePoint? And have you set the Image-property of the Image-control to ThisItem.? If you have, it will be hard to spot the error from here I'm afraid, sorry... - Jochen
Hello,I'm struggling to replicate what you did on the existing order screen,the part where you snapped your fingers and said "magic" with no explanation on the workings,personally I've added the columns (ID,Date,Items etc),My issue is now the vertical gallery,how exactly did you fill in those properties within the V. gallery ?
Hi! I copied the vertical gallery from the template screen and just resized it a little bit to fit the screen. The value for the Items-property of the vertical gallery is shown in the video when I explain about the toggle I used, since that toggle's value is used as a filter in that Items-formula. Inside the gallery's element are all just text label controls with the Text-property set to ThisItem.ID, ThisItem.OrderDate, ThisItem.Status.Value, ... and so on (depending on which fields you want to see there). That's all there is to explain really, hope that helps! - Jochen
Are there no galleries that are both horizontal and vertical, or would that not be useful?
Hi! That is not a default option you can choose no, but maybe you can create something like that from scratch with a so-called "custom component" That's a somewhat more advanced topic, but feel free to google it, maybe someone already create something like that and you can re-use it! - Jochen
Sir, Could you also please give the instructions to create the list "OrderLines" which is not there in the sharepoint database create instructions. please help
Hi! Sorry for the confusion, but in the end we decided to leave that list out of scope for this video series, so you won't need it to follow along with the videos since it will not be used for anything at all.👍 - Jochen
Sir many thanks@@CegekaBusinessSolutions
You are welcome! 👍 - Jochen
Can we do the same using csv file as a source data?
Hi! Yes you could, but the csv file would be "inside" of the app's internal memory. That will make it harder to maintain if the data itself changes (new records, updated records, ...). The image-file might also be a challenge to implement when using a csv-file but it's not impossible I think. The advantage of using SharePoint for example, is that the "database" is completely outside of the app, so maintaining the data is super easy. Hope this helps! - Jochen
This is amazing.. Could you please share the excel sheet?
Hi Sunita, we didn't use excel sheets in this demo, only Sharepoint lists. Since they were set up within a temporary demo environment, they have all been deleted by now... so there is nothing to share. However, we used very simple Sharepoint lists , so it's really easy to set up yourself!
Hi! We have just added the setup at the bottom of the video description, so now you can create the exact same SharePoint site and lists yourself if you want to follow along! 👍
I am getting an error .
Under NOS , I selected the whole V gallery the after try to code on its TamplateFill with "If(ThisItem.IsSelected,RGBA(168,0,0,0.25),Transparent)"
Hi! The formula seems to be correct, but instead of "Transparent" try "Color.Transparent", hope that fixes the issue. So "If(ThisItem.IsSelected, RGBA(168,0,0,0.25), Color.Transparent)" would be the formula to use.
They have changed it a while ago, so that you HAVE to use Color. first now. Instead of just using "Red" in a formula, you now have to use "Color.Red". Same goes for all other enumerations, like for example the Displaymode property: instead of just using "Disabled" when using it in a formula, you have to use "DisplayMode.Disabled".
Hope that helps! - Jochen
All great content, but for some reason, the TemplateFill function doesnt work no matter what I do in more than 1 Gallery.... it just doesn't highlight the items selected and I dont know why!
Thanks! Hmmm, not sure what could cause that. If you for example just put the formula "If(ThisItem.IsSelected, Color.Yellow, Color.Transparent)" in the TemplateFill-property's formula for the Categories-gallery, it should work when you go into preview-mode and select a category. Hope this helps! - Jochen
Hi Jochen @CegekaBusinessSolutions and thanks for your prompt reply. It worked in the end With the ColorTransparent code with a grey color i used "If(ThisItem.IsSelected, RGBA(105, 112, 122, 0.25), Color.Transparent) "
I have another question though as I'm trying to build a Products and Services request application inspired on your app tutorial.
1) Is it possible to create the Category gallery with some sort of tab or toggle so that the users can switch between Products or Services, then the Items list would also show the Products Items and Services items respectively?
2) If not, then I'm continuing to build it with a 2nd screen for Service request orders similar to the products, however, I would like the Existing Requests screen to show all products and Services combined in the list before submitting....
Is this doable?
Nice, good that it works now! Depending on which control you are going to use, you will also have to update the filter in your Items-property for the Items-gallery of course. If you use a radio button called radChoice, you can use radChoice.Selected.Value in your filter for example. So if you have decided which control you want to use to have the user select Products and/or Services, just do a Google search on how that control works and how you can use its selected value in a gallery filter. Hope this helps! - Jochen
how to get the ordering items into Items line share point
Hi! Since there are possibly more than 1 items you want to save at the same time, you will need a ForAll(...) + Patch(...) construction. Check out this link to get you started: www.matthewdevaney.com/patch-multiple-records-in-power-apps-10x-faster/ It will be something like this: ForAll(colShoppingBasket,
Patch(OrderLines, {OrderId: , ItemId: ThisRecord.ItemId, Price: ThisItem.ItemPrice}));. Hope that helps! - Jochen
@@CegekaBusinessSolutions love u master💖
What is the purpose of having to create multiple SharePoint lists? Could this same thing be accomplished with one list?
Hi Amy! This is just one example of how these data sources could be set up, but the same thing can definitely be accomplished with other setups as well. 👍
Not if you want to keep your data efficiently and without duplication and errors. Normalization is part of creating a database. A typical excel "database" for people would include a city column. If I had a list of 100s of people who all live in Chilliwack, but one of those cities for one of those people was spelt wrong, Chiliwack, I would end up missing that person in a mailing list for Chilliwack. In fact that one person might never get anything because the city is spelt wrong. A people table with just the information for that person with a column indicating which row to look at in my City table allows me to enter Chilliwack once and never make the mistake of spelling it wrong because I would pick it from a list when adding a new person who lives in Chilliwack. Relational databases break information into groupings of related data, this is normalization. There is a lot more to it, but those are the basics.
Good point, data structure is a major part of every development! However, just like "boolean logic", "basic coding statements", "how to use SharePoint", ... it was deliberately not included in the scope of this series. - Jochen
I can't seem to get the toggle to display the orders with my Email. Been battling with this all day, please I need your help.
Hi! Just to make sure: you actually have orders in the SharePoint-list already with your email in the Email column, right? If so, please paste the code here that you have for the Items-property of that gallery. - Jochen
@@CegekaBusinessSolutions yes I do already have the email on my sharepoint List.
OK then paste you Items-property code for that gallery here please, otherwise it will be hard to spot the error I'm afraid :-) - Jochen
@@CegekaBusinessSolutions each time I try pasting the code RUclips somehow fails to display it.
Can you type in the code manually maybe? And also let me know what the actual error message is that you get. Otherwise it will be hard to pinpoint the issue from here. - Jochen
How to clear the shopping basket or reset it to 0 once the order form has been submitted to Sharepoint?
Hi! I have put that logic on the "Clear shopping basket button" on the New Order Screen, and it is automatically selected when that screen becomes visible by using Select(btnClearShoppingBasket_NOS) as the code in the OnVisible-property for that screen. If I recall correctly, I show that in Episode 3 of this series. Hope this helps! - Jochen
@@CegekaBusinessSolutions Thank you for your help!
No problem! - Jochen
How can I get the SharePoint list you created?
Hi! We have just added the setup at the bottom of the video description, so now you can create the exact same SharePoint site and lists yourself if you want to follow along! 👍
+1 Please can you enable with sharing of the Sharepoint tables?
Hi! We don't have anything to "share" really, but check the video description (at the bottom) for the very simple setup of the Sharepoint data. Hope this helps!
Thanks
You are very welcome! 👍
Can You Explain How To Install Sharepoint In Windows 10 pro
Hi! In this series I use SharePoint Online, not an on-premise SharePoint. That's also a possibility though, if you Google "powerapps sharepoint on premise" you will find some tutorials on that as well. Hope this helps! - Jochen
1410: Something is off here. When I hover over the "User" portion of the formula, it shows a Record, instead of Text, and doesn't show my email address (even though it's in the list).. hmmm?
The User() function returns a record indeed, with a couple of fields IN it. So most of the time you won't want to use the entire record, but just one of those fields. To get the field values, you have to use User().Email or User().FullName in your formules for example. Hope that helps!
One observation - You can probably replace "= false" in the "if statement" by negating the value.
True! 😀
08:24 - Nothing happens here. The top item doesn't turn red, and either way, I can't select any of the items in the gallery when I Preview. Any idea what I did wrong?
You are always selecting an item when you click inside of a gallery in preview mode, that's how they have developed it. You just can't 'see' it by default, that's why we need that formula. Make sure you put the If(ThisItem.IsSelected, ...) formula inside the correct property, it should work. (TemplateFill property on the Gallery control) Hope this helps!
Everything fine until Order header .. why are you not talking about sharepoint lists in detail.. this video is complete only when you cover that...I am struggling inbetween
Hi! Check the video description for the complete setup of the SharePoint lists. Hope this helps! - Jochen
is there a way to do this without the use of SharePoint and using excel i tried but its not working
when i used Thisitem.CategoriesImage it didn't bring anything
Hi! To be honest, I don't know if you can add an "Image"-column in Excel like you can in Sharepoint, so that might already block you from using it in a similar way.
A possible workaround would be to store the image as a Base64-text in the Excel column, and then try and "decode" that Base64-text back to an image inside of the PowerApps-gallery where you are showing it. Google "PowerApps show base64 image" or something like that and you will probably find some info that will get you there. Hope this helps! - Jochen
@@CegekaBusinessSolutions Actually i did solve it by adding it as an Image link and i did the same thing as you did it worked just perfectly just imported the tables from the excel file
thank you so much
is Collection feature not available on the free version of power apps?
the formula clearcollectiions or colcategories seems to not work for me
is there any work around for this?
Collections and their formulas are always available, so I would double check if you have put the correct formula in the correct property. ClearCollect(colCategories, Categories) should work if 'Categories' is in fact the name of your external data source. Hope this helps! - Jochen
i got an error in EOS saying that expected text value for status🥲🥲
Hi! I'm not sure I understand the problem, but can you try ThisItem.Status.Value in the Text-property of the label you are displaying? (instead of just ThisItem.Status) Hope this helps! - Jochen
@@CegekaBusinessSolutions tq its worked!!
Awesome! 👍😎