Deactivating Dynamics 365 records in PowerApps Canvas App

Free PowerApps Dynamics 365 Training Guide:

Deactivating Dynamics 365 records in PowerApps Canvas App

You can try this possible solution here

If you want to try to do it from the Canvas App directly and not from a Flow:

Try Patch from PowerApps Canvas with the values it expects for "statecode" attribute of the entity.*

Remember it’s not called Active or Inactive in Dynamics. You may need to actually patch a number of zero or one.

Example: Account Entity Reference:

Dynamics 365 PowerApps Canvas App Training

NOTE: This may or may not work to Patch the statecode from PowerApps to the Common Data Service record, it may depend onthe circumstances and it may depend on some caveats, and due to those circumstances it is best to try it yourself now with a grain of salt – this may or may not work. If you need help you can contact us for more info

Also NOTE: If the above doesn’t work with Dynamics 365 data source- try the above instead using the Common Data Service data source. You are able to use Common Data Service source while using Dynamics 365 – in fact we recommend you use Common Data Service over Dynamics 365 in all Flows (especially Power Automate or Flow because you can set the "Current" environment as the scope in all the Flow Actions, making the solution more portable), as well as PowerApps Canvas Apps.

If it works, you can deactivate Dynamics 365 record without even using a Flow and by using PowerApps Canvas App directly!

See more Dynamics 365 PowerApps Canvas App Training

PowerApps Transfer Data From One Screen To Another Screen

PowerApps Transfer Data From One Screen To Another Screen.

In this case, your question is about transferring content from one screen to another. For example, suppose you want to transfer data from screen 1 to screen 3 or something like this.

That is not how PowerApps works to our understanding. You do not generally transfer things from one screen to another screen. Even the controls that are displayed on one screen, actually can be referenced from another screen from another control for instance.

So in your case, you should instead choose one of these two options for your scenario:

  1. Set a Variable / Use a Variable, or

  2. use a collection.

Let’s give example with Set a Variable / Use a Variable. Let’s suppose it is Text value (be sure to be consistent with the type).

On App Start and On Screen 1 OnVisible use this statement:


Elsewhere in Screen 1, set the real value

Set(MyArbitraryVariable001,"My Text Value")

In Screen 3, try to use the value, e.g. in a Label text

On a Label, Parameter Text, put this as the contents: MyArbitraryVariable001

There you go.

You can also use ClearCollect, Update, Patch, etc.

To our understanding, a PowerApps Collection is interpreted (or can be used as ) a type of "data source" – so a Collection can be used if you want to use data source or collection related functions instead and depending on your scenario.

Variables and Collection can be used across any of the screens to our understanding as well. This is because a Variable and Collection is scoped to whole app.

PowerApps Portals App In A Day Training Courses

Dynamics Edge’s PowerApps Portals App In A Day Training Courses encourage you to construct a Portal in only a single day.

We ordinarily feel like PowerApps Portals Training takes about two days to get through though. So we currently offer our custom two day PowerApps Portals training course. for enrollment.

We do offer a one-day course, but as of 12-17-2019 we might not have a specific page for the course – if you really want this course please click here, then fill out and submit the form to request a PowerApps Portals App In A Day Training Course

PowerApps Portals App In A Day Training Dynamics Edge

Get your groove on with Microsoft PowerApps Portals Training by Dynamics Edge.

PowerApps UpdateContext Function Not Working

Issue: Microsoft PowerApps UpdateContext Function Not Working.

Suppose that you are trying to use a PowerApps Canvas App button in order to update a DataCardValue in a particular new form inside of your PowerApp such as your Canvas PowerApp. However something you may run into is that the UpdateContext function may not seem to be working for your use case. Suppose you want to take an existing value of a particular DataCardValue, and, say, do something simple like increase it by 1 when a button is pressed.

PowerApps UpdateContext Not Working Possible Solutions

You may have tried:

UpdateContext({DataCardValueSubject77: DataCardValue77.Text + 1})

*note – pseudocode – not intended to be exact or accurate – just to illustrate the general idea

Maybe you tried leaving out the .Text part but without much success in that regard. Maybe you went wild and even tried something like using the Sum function with another label like AddPlusOne label, so you might end up with something like the following:

UpdateContext({DataCardValueSubject77: Sum(DataCardValue77.Text, AddPlusOne.Text)})

*note – pseudocode – not intended to be exact or accurate – just to illustrate the general idea

You may be dealing with a variety of DataCardValue values that could be either empty or that end up having a zero (0) inside of these card values. You may have considered it being OK to put in zeroes (0’s) as a potential default value in your case and that this may have been fine with you just to get it to work.

Even if you got very far, you may end up getting the following issue as well:

"Incompatible type. We can’t evaluate your formula because the context variable types are incompatible with the types of values in other places in your app."

We can help with the above issue as well. Please continue reading for the actual solutions to your PowerApps problems so you can become more productive with Power Platform and PowerApps.

PowerApps UpdateContext Not Working Actual Solution

We have actual solutions for your issue where you encountered "PowerApps UpdateContext Not Working" for your case. We have two options for you that are available right now, with Option 2 probably being better for you:

WRK1008 Power Apps AI Builder

WRK1008 Microsoft Power Apps: Hands on with AI Builder, a new capability that makes artificial intelligence easy to add within the Microsoft Power Platform. Get hands-on with AI Builder to easily add AI to the Power Platform PowerApps over the Common Data Service (CDS). Learn how to bring the power of Microsoft AI at your fingertips without requiring coding skills or data science skills. During this workshop, create several AI Builder models (Binary Classification, Text Classification, Object Detection, Form Scanning) in Power Apps and use those models directly in Power Apps or flows.

BRK2224 Power Apps top 10 PowerApps Low Code

BRK2224 Power Apps top 10: Major new capabilities that are shaping the future of low code.The truth is that low-code app development is evolving very fast. Microsoft Power Apps (PowerApps from Power Platform) is leading the way in the market. There is an incredible momentum in the platform – with top new features recently released that are already expanding what’s possible for citizen developers and professional developers as well. Whether this is starting from AI spanning through PowerApps Portals, you can learn the major innovation areas that are happening now in Power Apps (PowerApps) as well as how you can utilize these features to transfrom your digital organization today.

Microsoft PowerApps Flow Stored Procedure Training Courses

We offer Custom Microsoft PowerApps Flow Stored Procedure Training Courses right here, right now, at Dynamics Edge, the official Microsoft partner you can trust.

Click this link right now in order to check out all the Microsoft PowerApps Flow Stored Procedure Training Courses offered by Dynamics Edge, the official Microsoft Partner you can trust.

Microsoft PowerApps Flow Stored Procedure Training SQL Dynamics Edge

Here is one reason you may need custom Microsoft PowerApps and Flow Training from Dynamics Edge. Let’s suppose this scenario.
Let’s say you need Microsoft PowerApps Flow Training because you had trouble passing parameters to Flow for executing a particular SQL server stored procedure. You may run into an issue with how Flow passes these parameters. You might think that this stored procedure takes in quite a few parameters (about 17 to twenty of them, all varchar value types of different sizes in this example). You might have tested the Stored Procedure a lot yourself outside of Flow with manual test case scenarios and have confirmed that it works correctly there. However, when looking at the issues generated you may notice that similar values which have been passed to Microsoft Flow are used distinctly in the different manual test case scenarios outside of Flow and even those work OK. The issues become obvious elsewhere. For instance you might get a Code 400 issue (otherwise known as a Bad Request) indicating that your SQL statements could be invalid. This might indicate that the parameter values are not being passed correctly but you’re not sure yet.

Here’s a rough pseudocode example of what you might have :

If(varcharfilterSOALevel && “0” in lstHomeSOALevel.SelectedItems.Value,”0″,”~”),
If(varcharfilterSOALevel && “1” in lstHomeSOALevel.SelectedItems.Value,”1″,”~”),
If(varcharfilterSOALevel && “2” in lstHomeSOALevel.SelectedItems.Value,”2″,”~”),
If(varcharfilterSOALevel && “3” in lstHomeSOALevel.SelectedItems.Value,”3″,”~”),
If(varcharfilterSOALevel && “4” in lstHomeSOALevel.SelectedItems.Value,”4″,”~”),
If(varcharfilterSOALevel && “5” in lstHomeSOALevel.SelectedItems.Value,”5″,”~”),
If(varcharfilterSOALevel && “6” in lstHomeSOALevel.SelectedItems.Value,”6″,”~”),
If(varcharfilterSOALevel && “7” in lstHomeSOALevel.SelectedItems.Value,”7″,”~”),
If(varcharfilterSOALevel && “8” in lstHomeSOALevel.SelectedItems.Value,”8″,”~”),

Here’s an example Stored Procedure execution call which may seem to be working for you:
EXEC [dbo].[SPNAME] ‘9/13/2018’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’, ‘~’
And an alternate version:
EXEC [dbo].[SPNAME] ‘9/13/2018’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”

However, you may still get the following error code text anyway:
“status”: 400,
“message”: “Microsoft SQL: Incorrect syntax near ‘WHERE’.\r\n inner exception: Microsoft SQL: Incorrect syntax near ‘WHERE’.\r\nclientRequestId: aaa-aa-aaaa-aaaa-aaaaaa”,
“source”: “””

In this case, one issue could be the tested stored procedure you were using actually had one too many of the parameters to test when constructing your WHERE clause, so the issue was indeed in your original code. There could be one of many issues, If you ever need PowerApps Flow Stored Procedure custom Training, Support, Licensing, Consulting, anything related to Flow Stored Procedures help, or anything Power BI, PowerApps, Flow, Azure, SQL Stored Procedures, SQL Server and more – contact Dynamics Edge now – the official Microsoft partner you can trust!

Microsoft PowerApps Flow Training Courses

Dynamics Edge offers Microsoft PowerApps Flow Training Courses – or, Microsoft PowerApps Training and/or Microsoft Flow Training.

Please use this link right now in order to check out all the Microsoft PowerApps Flow Training offered by the official Microsoft Partner you can trust, Dynamics Edge!

Microsoft PowerApps Flow Training Dynamics Edge
For analytics (Power BI), interactive apps (PowerApps) and business process automation (Flow), the way enterprises get stuff done these days has significantly changed as compared to the past. Even just a few years ago is a totally different landscape from right now. All of the apps we use to do enterprise-level business solutions have been somewhat slow to keep pace with employee demand and new productivity. We accomplish amazing things on a daily basis on all kinds of devices – our laptops, our tablets, our mobile phones, and more – in every place we go! Whether we need an enterprise problem solved at our customer meetings, in airplanes, on manufacturing floors, at trade shows booths, at the front desk, and everywhere – sometimes off-the-shelf solutions just can’t solve every problem these days, and at the same time, custom solution development has often been too time consuming and expensive.

CDS or Common Data Service, Microsoft Flow and PowerApps are designed to help non-coders to develop at the level of custom solutions (or even better sometimes), at a much faster pace. These technologies give people who best understand their own challenges and needs the power and the opportunity to quickly address it themselves, without as much complexity and cost of custom software development as well as time.

There is one caveat. Even these technologies assume you know the ways to use these in order to substitute for custom development to meet your business needs. Often times, in the quest to substitute for complex, custom development or consulting with PowerApps, Power BI, Flow and Common Data Service, enterprises still end up often turning to consultants or “custom development” help for the supposed technologies like PowerApps, Power BI, and Flow that were designed for you to “do it yourself.” Note that depending on your needs, a custom solution with a great consultant using PowerApps, Power BI, Flow, Common Data Service, Dynamics 365 and other great technologies integrated together, can still be faster and less time consuming, and more cost effective, than using some other technology. However, if you are in doubt, contact Dynamics Edge right away, we offer Power BI, PowerApps, Flow, and Common Data Service consulting. We also offer custom PowerApps and Flow Training so you might even be able to learn how to do it yourself directly from us!

In the case that you are an enterprise expert or data analytics and management specialist, you may want to quickly automate workflows, create apps and integrations, and much more in order to solve real-world enterprise needs and expectations. For this, Dynamics Edge has got the Flow and PowerApps training for you (as well as Power BI and more)! Our courses help you improve business processes throughout your enterprise by learning how to create apps that solve specific business needs for non-developers without writing manual code, debugging with an IDE or editor in a traditional programming language, or struggling heavily with integration issues using raw manual code. Instead, you can learn how to concentrate on your enterprise and data processes, while leveraging the innate capabilities of Flow, PowerApps and Common Data Service in order to deliver quality solutions that works cross-device, across browsers, tablets and mobile phones! So contact Dynamics Edge today to see what we can do for you!

Microsoft PowerApps App in a Day Training Workshops and Courses

Dynamics Edge offers custom Microsoft PowerApps App in a Day Training Workshops and Courses. Here is some information about upcoming official Microsoft App in a Day Training for 2018. You should know that Dynamics Edge also offers our own, custom-tailored App in a Day Training Live Virtual (real time with the instructor – you can attend live, with the instructor, remotely from anywhere in the world) as well as in-person, physical in-classroom delivery options at our locations all over the USA.
Please note the following are Official Microsoft Events only – if you want Dynamics Edge PowerApps App In A Day events, click here to check out our courses.

Microsoft is aware of the great demand and excitement coming from the Spring roadshow (Original Article Source: here) Microsoft is offering App in a Day (AIAD) events to their customers globally throughout the year! A place designed to be where you learn how to create and build custom business applications that run and execute on mobile devices and desktops too, without writing tedious manual custom code, and share them inside your organization securely, the official Microsoft App in a Day events are free one-day workshops that will be run by qualified Microsoft PowerApps partners, so come with your devices and your questions in this all-day interactive Microsoft training! These events include partners who are deeply knowledgeable about the platform and can help your organization get the most value out of your app ideas, and Microsoft will even provide lunch. After attending this workshop, you will be able to walk-away with a cool app and an understanding of how to differentiate yourself within your organization by using apps that drive productivity and automation for your team.

Here is a list of official Microsoft events and their dates. You should know that more cities could be added soon, so continue to check back with Microsoft if you can’t make one of these,
(or check with Dynamics Edge, official Microsoft Partner, for our AIAD events using the links at the top of this page):

Atlanta, GA, USA


London, UK


Denver, CO, USA


New York, NY, USA


San Francisco, CA, USA


Dallas, TX, USA


Pittsburgh, PA, USA


Los Angeles, CA, USA


Chicago, IL, USA


Houston, TX, USA


Atlanta, GA, USA


Copenhagen, Denmark


Perth, Australia


Melbourne, Australia


New York, NY, USA


Boston, MA, USA


Chicago, IL, USA


Charlotte, NC, USA


Pittsburgh, PA, USA


Dallas, TX, USA


Houston, TX, USA


Minneapolis, MN, USA


Hamburg, Germany


Related Dynamics Edge Microsoft PowerApps App In A Day (AIAD) Training Workshops and Events In-Person In-Physical-Classroom in the USA:

Microsoft PowerApps App In A Day Training Workshops on site in USA in person, or Live Virtual (Live in real time with the instructor online).