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 !
@gawdseen153
11 ай бұрын
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.
@CegekaBusinessSolutions
11 ай бұрын
Hi! Instructions for the SharePoint lists setup are in the video descriptions. Hope that helps! - Jochen
@fabio6864
4 ай бұрын
@@CegekaBusinessSolutions OrderLines list is not in the instructions
@CegekaBusinessSolutions
4 ай бұрын
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
@GiDiODev_old
9 ай бұрын
This series is the best Microsoft POWER APPS tutorial on KZitem...and anywhere else!
@CegekaBusinessSolutions
9 ай бұрын
Thanks, glad you liked it! - Jochen
@alsaukh3
Жыл бұрын
By far, this series is the best👍 (Microsoft POWER APPS) tutorial I have found, Please, we need a lot more about it😊👋
@CegekaBusinessSolutions
Жыл бұрын
Thanks! 😎
@MaemuTendani
6 ай бұрын
Best tutorials i got on Power Apps, thank you so much.
@CegekaBusinessSolutions
6 ай бұрын
Great to hear! You are very welcome! :-) - Jochen
@DilipTiwariVlogs
Жыл бұрын
Very helpful!! Thanks for posting this tutorial.
@CegekaBusinessSolutions
Жыл бұрын
Glad it was helpful, thanks!
@user-ls7ld3im9u
Жыл бұрын
Superb. You make PowerApps look so simple. Thank you so much!
@CegekaBusinessSolutions
Жыл бұрын
You are welcome! ☺️👌
@dr.seemitrverma622
Жыл бұрын
Thank. Looks super useful and was fun learning
@CegekaBusinessSolutions
Жыл бұрын
Thanks, glad you enjoyed it! - Jochen
@hassannasir1222
Жыл бұрын
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.
@CegekaBusinessSolutions
Жыл бұрын
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
@jasonblais1667
10 ай бұрын
amazing video. thank you.
@CegekaBusinessSolutions
10 ай бұрын
Glad you liked it, thanks Jason! 👍
@RekikA
Жыл бұрын
Thank You for this :)
@CegekaBusinessSolutions
Жыл бұрын
You're welcome! Hope we could help.
@eriksharma
Ай бұрын
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?
@CegekaBusinessSolutions
Ай бұрын
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
@edjk6278
Жыл бұрын
How about a Power Pages tutorial! Love your work!
@CegekaBusinessSolutions
Жыл бұрын
Thanks! Power Pages might be a future topic yes, thanks for the suggestion! 😎 - Jochen
@vangamohsesay5658
Ай бұрын
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
@CegekaBusinessSolutions
28 күн бұрын
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
@talhashad9089
10 ай бұрын
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
@CegekaBusinessSolutions
10 ай бұрын
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
@rpadeveloper8549
11 ай бұрын
@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?
@CegekaBusinessSolutions
11 ай бұрын
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!
@mervekorkut2470
11 ай бұрын
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 🌻🌻
@CegekaBusinessSolutions
11 ай бұрын
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
@tenagnebereded9625
9 ай бұрын
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
@CegekaBusinessSolutions
8 ай бұрын
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
@alantonn8108
Жыл бұрын
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?
@CegekaBusinessSolutions
Жыл бұрын
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
@alantonn8108
Жыл бұрын
@@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.
@CegekaBusinessSolutions
Жыл бұрын
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
@DawnTreaderPlaysEDO
Жыл бұрын
@@CegekaBusinessSolutions I found another KZitem video to help me with that. Thanks for your help.
@CegekaBusinessSolutions
Жыл бұрын
No worries! 👍
@lethabomokoane1444
5 ай бұрын
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)"
@CegekaBusinessSolutions
4 ай бұрын
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
@WhatkaCo
Жыл бұрын
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
@CegekaBusinessSolutions
Жыл бұрын
Hi, thanks! Keep watching the playlist, that data push is covered in the very last episode! - Jochen
@monicaquiroz1181
10 ай бұрын
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?
@CegekaBusinessSolutions
10 ай бұрын
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
@user-bg9ob8wr4k
Жыл бұрын
Hi, great video. Can you please give or where i get this dummy data tables that you show in sharepoint
@CegekaBusinessSolutions
Жыл бұрын
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
@gawdseen153
8 ай бұрын
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 ?
@CegekaBusinessSolutions
8 ай бұрын
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
@sunitasingh9467
Жыл бұрын
This is amazing.. Could you please share the excel sheet?
@CegekaBusinessSolutions
Жыл бұрын
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!
@CegekaBusinessSolutions
Жыл бұрын
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! 👍
@muhammedsajid3329
Жыл бұрын
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
@CegekaBusinessSolutions
Жыл бұрын
Hi! Check the video description for the complete setup of the SharePoint lists. Hope this helps! - Jochen
@sanoberansari648
9 ай бұрын
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?
@CegekaBusinessSolutions
8 ай бұрын
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
@trondejo
3 ай бұрын
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?
@CegekaBusinessSolutions
3 ай бұрын
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
@trondejo
3 ай бұрын
@@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
@CegekaBusinessSolutions
3 ай бұрын
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
@ziadjadaa6002
10 ай бұрын
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!
@CegekaBusinessSolutions
10 ай бұрын
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
@ziadjadaa6002
10 ай бұрын
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?
@CegekaBusinessSolutions
10 ай бұрын
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
@ronaldwalcott5090
Жыл бұрын
One observation - You can probably replace "= false" in the "if statement" by negating the value.
@CegekaBusinessSolutions
Жыл бұрын
True! 😀
@dhanashreegorane3272
Жыл бұрын
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. :)
@CegekaBusinessSolutions
Жыл бұрын
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
@stenjohannesson
11 ай бұрын
Are there no galleries that are both horizontal and vertical, or would that not be useful?
@CegekaBusinessSolutions
11 ай бұрын
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
@deepinderkaur4309
11 ай бұрын
Can we do the same using csv file as a source data?
@CegekaBusinessSolutions
11 ай бұрын
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
@essential021
Жыл бұрын
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
@CegekaBusinessSolutions
Жыл бұрын
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
@essential021
Жыл бұрын
Sir many thanks@@CegekaBusinessSolutions
@CegekaBusinessSolutions
Жыл бұрын
You are welcome! 👍 - Jochen
@chavonsanders
Жыл бұрын
How to clear the shopping basket or reset it to 0 once the order form has been submitted to Sharepoint?
@CegekaBusinessSolutions
Жыл бұрын
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
@chavonsanders
Жыл бұрын
@@CegekaBusinessSolutions Thank you for your help!
@CegekaBusinessSolutions
Жыл бұрын
No problem! - Jochen
@amygoodrich2529
Жыл бұрын
What is the purpose of having to create multiple SharePoint lists? Could this same thing be accomplished with one list?
@CegekaBusinessSolutions
Жыл бұрын
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. 👍
@alantonn8108
Жыл бұрын
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.
@CegekaBusinessSolutions
Жыл бұрын
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
@mron4161
Жыл бұрын
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?
@CegekaBusinessSolutions
Жыл бұрын
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!
@gandhampawanvamsi4173
Жыл бұрын
Can You Explain How To Install Sharepoint In Windows 10 pro
@CegekaBusinessSolutions
Жыл бұрын
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
@mron4161
Жыл бұрын
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?
@CegekaBusinessSolutions
Жыл бұрын
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!
@asterasrat6295
Жыл бұрын
How can I get the SharePoint list you created?
@CegekaBusinessSolutions
Жыл бұрын
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! 👍
@mrinal5647
Жыл бұрын
+1 Please can you enable with sharing of the Sharepoint tables?
@CegekaBusinessSolutions
Жыл бұрын
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!
@asterasrat6295
Жыл бұрын
Thanks
@CegekaBusinessSolutions
Жыл бұрын
You are very welcome! 👍
@suryaraya3564
Жыл бұрын
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
@CegekaBusinessSolutions
Жыл бұрын
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
@suryaraya3564
Жыл бұрын
@@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
@suryaraya3564
Жыл бұрын
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?
@CegekaBusinessSolutions
Жыл бұрын
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
@afzalrosman8260
Жыл бұрын
i got an error in EOS saying that expected text value for status🥲🥲
@CegekaBusinessSolutions
Жыл бұрын
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
Пікірлер: 112