Відео

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

Wow, thank you! Glad you liked it! - Jochen

Thanks, glad you liked it! 👌😊

Added to the list of ideas, thanks! 👌

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.<thatColumn>? If you have, it will be hard to spot the error from here I'm afraid, sorry... - Jochen

Hi Yaroslav! Eventually we decided to not save the items at all for this series, so only the "header" information is saved in the OrderHeader-list on SharePoint. Hope that helps! - Jochen

Thanks, glad you enjoy it! - Jochen

Glad it was helpful! Thanks! - Jochen

Hi! Please use the contact form on our website to get in touch: www.cegeka.com/en/solutions/dynamics365/technology/power-platform . Thanks! - Jochen

Glad it was helpful! - Jochen

Thanks, I'll take it! :-) - Jochen

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

Thanks! Good suggestions, they are added to the list for possible future content. :-) - Jochen

Look forward for coming tutorials …

Nice, keep it up! - Jochen

Glad I could help! I don't have any data to share, but the setup for the simple SharePoint lists that I used is at the end of every video description. Hope that helps! - Jochen

Hi! Not directly on here, but the contact link for our company is in the video description, feel free to reach out. - Jochen

Thanks! :-) Maybe not another course, but there will be more content in the future. - Jochen

Thanks, glad you liked it! - Jochen

Hi! Virtual Entities are cross company supported by default. Which means that if a user has access in multiple companies, they will also receive the data from those companies. You can then filter by using a default field like Company(mserp_dataareaid). If you want to do a Create(s) in a specific company, you will have to fill in that field to specify the company you want to use. Hope this helps!

Hi Dawn, and thanks! :-) We don't have a video on this, but take a look at this to get inspired: learn.microsoft.com/en-us/power-apps/guidance/patterns/approval-pattern . Hope this helps! - Jochen

Yes, thanks for the suggestion!

Glad you liked it, thanks! :-) - Jochen

Oh thanks, that a really nice thing to say! Glad you liked it! :-) - Jochen

Great to hear! You are very welcome! :-) - Jochen

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! Good idea, added to the list for possible future content. :-) - Jochen

Thank you so much, glad you liked it!! :-) - Jochen

Hi! I'm not sure what you mean by " a fillable PDF form", but maybe this link could be helpful: learn.microsoft.com/en-us/power-apps/maker/canvas-apps/how-to/pdf-function . Hope it helps! - Jochen

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

Thanks! I appreciate the feedback as well, noted! - Jochen

Thanks, much appreciated! - Jochen

Thanks! Glad it was helpful! - Jochen

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 Roy! You can share an app with "external" people but you have to be aware of 2 main things: 1. They will need a PowerApps license to access the app. 2. They will also need direct access to the data sources used in the app, e.g. SharePoint lists. Here is a helpful link, check it out: www.matthewdevaney.com/a-fool-proof-way-to-share-power-apps-with-external-users/ Hope this helps! - Jochen

During the calls to F&O, Dataverse provides the identity of the user in Dataverse who is invoking the action. The CDSVirtualEntityAdapterService web API looks up the associated user in F&O and runs the query in the context of that user. So indeed, a user in Dataverse that needs to view data in F&O needs to be present in F&O as well. An application user can also be used to call into virtual entities. For this kind of integration, the application user must be set up in System administration > Setup > Configure Azure Active Directory Applications. This allows for applications to integrate with F&O using virtual entities. Hope this helps!

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

We are facing the same challenge. Please share if you find a solution. Thanks

During the calls to F&O, Dataverse provides the identity of the user in Dataverse who is invoking the action. The CDSVirtualEntityAdapterService web API looks up the associated user in F&O and runs the query in the context of that user. So indeed, a user in Dataverse that needs to view data in F&O needs to be present in F&O as well. An application user can also be used to call into virtual entities. For this kind of integration, the application user must be set up in System administration > Setup > Configure Azure Active Directory Applications. This allows for applications to integrate with F&O using virtual entities. Hope this helps!

Thanks, and you're welcome! 😎

Thanks, glad I could help! There won't be a video 6 on that, since we have eventually decided to leave that out of the scope for this course. But in short you will need to add an extra formula as the first line of code in the OnSuccess-property for the form. Because if the OnSuccess is triggered, that means that you will have the LastSubmit.ID-value that you can use. It's maybe not 100% accurate, but the extra code you would need as that first line in the OnSuccess-property would be something like ForAll(colShoppingBasket, Patch(OrderLines, Defaults(OrderLines), {OrderID: formConfirmation_NOS.LastSubmit.ID, ItemID: 123, ItemName: ThisRecord.ItemName, Price: ThisRecord.Price})) Note that if you have followed the videos, you won't have the ItemID-field in the shopping basket, that's why I just added 123 as a dummy value in this formula. Once you add ItemID as a field to the Collect-fuction in the OnSelect of that Order-button, you can change the formula to ForAll(colShoppingBasket, Patch(OrderLines, Defaults(OrderLines), {OrderID: formConfirmation_NOS.LastSubmit.ID, ItemID: ThisRecord.ItemID, ItemName: ThisRecord.ItemName, Price: ThisRecord.Price})) Hope this helps! - Jochen

Good job, and thanks! 😀 On your question: check the "Default mode" property of your form, in the right side properties pane. It will most likely still be set to "Edit" for you, change that to "New". That, in combination with the NewForm(...) and ResetForm(...) functions in the video, should solve your problem. Hope this helps! - Jochen

Thanks, glad you liked it! - Jochen

Oh thanks, much appreciated! 😀 - Jochen

Thanks! Use this formula in the OnSelect-property for your button: Navigate( ....... , ScreenTransition.Cover) This should work, just make sure that you replace the ..... with the name of your screen. Hope this helps! - Jochen

You're very welcome! 😎 - Jochen

Glad you liked it, thanks Jason! 👍

Hi, thanks for the kind words! I can't offer you a direct connect session, but maybe you can briefly explain what you want to do? Then I will try and help you here. - Jochen

Thanks, glad you liked it! 👍😀 - Jochen