Azure Key Vault for Power Automate
Learn how to configure Azure Key Vault for Power Automate using a service account. In cloud flow we read secret from Key Vault Continue Reading Yawer Iqbal’s Article on their blog Azure Key Vault for Power Automate Learn how to configure Azure Key Vault for Power Automate using a service account. In cloud flow we read secret from Key Vault https://www.youtube.com/watch?v=WTsAcdK-LNM Blog Syndicated with Yawer Iqbal’s...
Row Update After SharePoint File Upload
A common requirement is to update the record row in Dataverse table after a file has been uploaded to SharePoint. This small post documents the steps and expressions for it. For demonstration, I m using “Account” table and have created “URL” a custom column in it. After file uploads, I will update the row and safe URL in this field. Summary This post do not cover the steps… Continue Reading Yawer Iqbal’s Article on their...
Convert SharePoint Uploaded Word File to Pdf
Did you ever receive a requirement that a Word file uploaded through a model-driven app in SharePoint should be converted and saved as Pdf? I had this requirement in multiple projects. Recently I have used cloud flow to achieve this. It was a model-driven app that has integration with SharePoint for document storage. In this post, I m documenting steps. Summary The app has SharePoint… Continue Reading Yawer Iqbal’s Article...
Power Automate Convert a String to GUID
Suppose you need to create a new globally unique identifier (GUID). In that case, Power Automate provides guid() function which generates and returns a new GUID as string. It is a useful function, but it doesn’t create a GUID based on string we provide, the way it works in C#. This post will explain how to convert a string into GUID format with dashes (with or without curly braces). I… Continue Reading Yawer...
Querying Audit History
Audit history is a great out of box feature in model-driven apps. However, querying audit history is a bit tricky. Unfortunately commonly used querying mechanisms like Power Automate CDS connectors, LinQ, or simply FetchXml doesn’t support it. This post will discuss options we have and sample code for it. Options Using SDK messages, RetrieveRecordChangeHistoryRequest &… Continue Reading Yawer Iqbal’s Article on their...
Fiddler for Model Driven Apps
While developing ‘PowerApp Components’ and traditional ‘Web Resources’, a common challenge is that testing is not straight forward. To test a change in HTML or JS code, one needs to deploy files, which is time-consuming. There are commercial tools available for model-driven apps to make it simpler but still using Fiddler have advantages. This first post of this series will explain how… Continue Reading Yawer Iqbal’s...
Set Lookup Field in Java Script
Adding this post for someone who needs it and for my own reference. In Java Script lookup can be populated in one of three ways depending on requirements: Query lookup data to set in form Get lookup details from data available in form (from other fields)Hard code lookup values This is example using second option. It uses logged in user’s id and name to populate lookup. A lookup can… Continue Reading Yawer Iqbal’s...
Accessibility in PowerApp Projects
Accessibility is an essential consideration for a public sector or enterprise implementation. Last week I presented “Accessibility in PowerApp Projects” at Washington DC – User Group. Thanks to lovely organizers and supporters of UG Kylie Kiser, Aiden Kaskela, Nelson Johnson, Mike Ochs and others. As usual, it was a lovely chat and sessions. I covered things like what accessibility is,...
XrmToolBox 2FA Authentication and Proxy Server Settings
2FA Authentications When connecting XrmToolBox to an environment where 2FA is enabled, the following error can occur: Error: An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. I found this issue when I started working on a new project and didn’t realise 2FA is enabled. Thankfully found… Continue Reading Yawer Iqbal’s Article on...
XrmToolBox Common Errors and Solutions
This will be an ongoing post, I m writing this to log and share common XrmToolBox errors and their solutions. Error: An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. I received this error when I started working on a new project. MFA was enabled and I didn’t realise it. Thank fully found… Continue Reading Yawer Iqbal’s Article on...
Binding CDS Data using Knockout (more tips)
This post is second in a series of querying CDS entity data and displaying it in a model-driven app web resource. A few days back, I wrote first post in this series CDS Data Binding using Knockout. Here I m answering a couple of questions and sharing a few more tips. Though I have fetched data using WebApi and J-Query but any mechanism that returns object array will work. Yes, we can… Continue Reading Yawer Iqbal’s Article...
CDS Data Binding using Knockout
In this post I am explaining how to query CDS data and bind it inside a web resource using Knockout. It can provide the following advantages: It is easy don’t requires a lot of efforts (less coding)We have flexibility to do further customisation About demo: Since it is just a demo, I have included script and link references from CDN. Focus of this post is to explain and share… Continue Reading Yawer Iqbal’s Article...
Power Chat with Olena Grischenko
Based in Sydney Australia Olena is a Microsoft MVP, developer and architect. She has vast experience in software development, D365 CE and Power Platform. She is a community speaker and organiser of multiple user groups. Tell us about yourself (experience, background, industries, community service, else) Started as a .Net developer, I’ve been working in IT for 20 years. Have… Continue Reading Yawer Iqbal’s Article on their...
Power Chat with Rasheed Gomaa
Mohammed Rasheed Gomaa is a Senior D365 Techno-Functional consultant recently moved to Saudi Arabia from Sydney Australia. Rasheed has authored multiple plugins for XrmToolBox. He is now leading D365 User Group in Riyadh. I have asked him technical questions and also about D365 market in Gulf and how it is to live and work in KSA. Tell us about your professional experience and how you… Continue Reading Yawer...
Accessing Git Repository from Visual Studio behind a Proxy Server
I was working for a client who has a proxy server on the network and every HTTP request passes through it. In this situation I couldn’t access my Git repository and was getting errors like “Couldn’t resolve host..” or “Unable to access …” For me the solution was to config proxy settings in GIT. On my local machine in command prompt I used this sample command: git-config… Continue Reading...
Power Chat with Jim Novak
Jim Novak is a Microsoft Business Applications MVP and a D365 technical architect. He leads D365 Saturday and TDG communities in Washington D.C. area. He is an admirable and inspiring community contributor. He frequently arranges events, presents as a speaker and develops tools for the community. I hope you will like this chat with Jim Novak For the success of a D365 project, what are… Continue Reading Yawer Iqbal’s...
Power Chat with Rami Mounla
Rami Mounla is a solution architect based in Wellington, New Zealand. He is the author of Microsoft Dynamics 365 Extensions Cookbook. Rami is a regular speaker and organises different community events, including D365 Saturday, in New Zealand. He was awarded Microsoft MVP multiple years. It was a pleasure for me to meet Rami in Melbourne a few years back. I admire his experience,… Continue Reading Yawer Iqbal’s Article on...
Create Rich Chatbots With PVA
Have you tried Power Virtual Agent (PVA)? If not I will strongly recommend to try it now from https://aka.ms/TryPVA. If you have already tried a basic functional bot, probably it is time to explore a few features further and think about creating a better chat experience. This post discusses a few ways we can try to format and present bot responses in a comparatively rich format. Let Your… Continue Reading Yawer...
Power Chat with Stefano Tempesta
Stefano Tempesta is based in Melbourne, Australia. He is a CTO, digital advisor, Speaker, Author, and Blockchain & AI expert. Stefano is Microsoft Regional Director and MVP in three categories (AI, Azure and Business Applications). He is one of founder members of D365 Saturday This week in “Power Chat” I asked my questions to Stefano, I was particularly looking for him because… Continue Reading Yawer...
Power Chat with Neil Parkhurst
Neil Parkhurst is based in Dudley, United Kingdom. He is a consultant, trainer, project manager & Microsoft MVP (Business Applications) If you have any interest in D365, USD and even relevant certification exams chances are, in one way or other, you have been benefiting from Neil’s community work. It was an absolute pleasure for me last year to attend Neil’s session (about Omnichannel)… Continue...
Power Chat with Andre Margono
Andre Margono is based in Melbourne, Australia; he is a System Architect & Microsoft MVP (Business Applications) In Power Chat I m interviewing Power App experts and share their practices and suggestions with community. These ideas can lead a project to success. Here are questions I asked Andre and his replies. For the success of a D365 project, what are a few things (practices or… Continue Reading Yawer...
Power Chat with Alex Shlega
Alex Shlega is based in Ottawa, Canada; he is Microsoft MVP (Business Applications), Consultant, Solution Architect and Developer It is always a good idea to learn about different views and approaches, other than your own. Being part of D365 & Power Platform community a few time, we know people but don’t get a chance to work with them. I m starting a new series ‘Power Chat’ on my… Continue Reading Yawer...
Power Platform Analytics for Administration & User Adoption
Power Platform analytics are out of box reports, located under the admin center. Historically similar statistics were available as ‘Organization Insights’ dashboard, which was a separate install-able solution. After login to https://admin.powerplatform.microsoft.com, under analytics section, the following four reports are available at the moment: CapacityCommon Data ServicePower… Continue Reading Yawer...
D365 & Power Platform New Certifications & Exams
In the year 2019, D365 certifications and exams have undergone many changes. New certifications are replacing the legacy ones. By the mid of 2020, almost all past exams will be retired. I often get a chance to talk to people new to D365 or certifications. Few times I found they are not aware of these changes and focusing on something which is expiring soon. I hope this post will explain… Continue Reading Yawer Iqbal’s...
Web API “An error occurred while validating input parameters”
Today I had this error in my JS Web Api request: {“error”:{“code”:”0x0″,”message”:”An error occurred while validating input parameters: Microsoft.OData.ODataException: An undeclared property ‘mm_account’ which only has property annotations in the payload but no property value was found in the payload. In OData, only declared navigation properties and declared named...
Plugin Registration & Configuration Migration tool login issue behind proxy server
Recently I was working in a client’s office where they had proxy server in network. For D365 applications, SSO (Active Directory Seamless Single Sign-On) was configured. Tried to use “Plugin Registration” and “Configuration Migration” tools but on login got this error: Error : You don’t have permission to access any of the organizations in the Microsoft Common Data Service region that…...
D365 & PowerApps Minimum Viable Projects
Minimum Viable Product (MVP) is often referred with startups. The concept is to develop minimal features which ideally should have core functionality, just enough for the user to give feedback. It may not be very fancy and user experience focused. In product development, feedback provides direction for further work and growth. Here I m sharing my experience. The idea of MVP (minimal viable… Continue Reading Yawer...
Power Platform 24 Video recordings
Last month xRMVirtual User Group conducted Power Platform 24, which was a virtual conference focused on the Power Platform and Dynamics 365. In 24 hours, presenters from various parts of the word presented sessions. My presentation was ‘Accessibility’ for D365 & PowerApp Projects. It was a great event thank you Julie Yack, David Yack, Joel Lindstrom, Beth Burrell, Sarah Jelinek, Jim…...
CDS Solution Checker What Why When How
While delivering D365 projects, to address unique business requirements often we do customizations. The customizations can be simple or complex. A few times doing customizations can create performance and maintainability issues in solutions. Usually, teams follow some sort of best practices to avoid such risks. CDS solution checker is great Power Platform feature which can analyze… Continue Reading Yawer Iqbal’s Article on...
Passing multiple GUID to QueryExpression
A few time we need to pass multiple parameters to QueryExpression to fetch required entities. I have seen code with multiple calls instead of passing multiple parameters, and of course avoiding multiple calls is efficient. In code reviews, I also have seen hard coded Guids or people looping through collections to obtain Guids. In some situations, these can be the “only” or best options but… Continue Reading Yawer...
Can’t connect to D365 if system clock is wrong
Probably title of this post summaries it well, but there is some detail worth explanation. I was developing an Azure Function app which was basically integrating data between D365 CE and another system. The major functionality of this application was complete and tested. Two weeks back when I came back from leave I found application (which I was developing), can’t connect to CE now. I was… Continue Reading Yawer...
Fixing Plugin registration tool crash after login
Plugin registration tool (v.9) was working fine but I had to change the user account to deploy a plugin and tool started crashing. It was accepting my password, showing available CRM instances, and after I select the instance, without reporting any error it was crashing. To fix I downloaded plugin registration tool again and also deleted files from: <blockquote… Continue Reading Yawer Iqbal’s Article on their blog...
“Accessibility” for D365 Projects 2
This is my second post on this topic. In first post “Accessibility” for D365 Projects, I mentioned accessibility became part of our project requirements but it was not from the start of the project, it happened when multiple releases were already delivered and in production. So it was not straightforward to make everything accessible. This taught us two important lessons: Best time to… Continue Reading Yawer...
“Accessibility” for D365 Projects
Last year in a D365 implementation in public sector accessibility was one of the project requirements. That time it was something new to our D365 team. Here I am documenting my learning and hoping it will be helpful to someone have similar requirements. What is accessibility? You may have seen similar to one of these in your surroundings if not all. In general products, systems, devices… Continue Reading Yawer Iqbal’s...
Publish duplicate detection rule using PowerShell
In D365 project PowerShell scripts are used for a number of tasks. A few examples are: To automate import and export of solution For automating manual deployment tasks or steps Creating reference data Querying, testing and analysing data while in development, and also post-deployment Creating integration tests to ensure the system is in expected state Recently I used PowerShell script to… Continue Reading Yawer Iqbal’s...
My presentation about MS Flow with D365
I love Dynamics 365 users group Melbourne, Nadeeja Bomiriya (MVP), Elaiza Benitez (MVP) and Daniel Hesketh are doing great community contribution. This month I presented “Empowering D365 business users with Flow” at the user group. In this presentation, I showed the following four demos about how MS Flow is helping Dynamics 365 business users: Providing mobile text messaging (SMS)… Continue Reading Yawer...
Exporting and importing solution using PowerShell
Powershell scripts are used with data centres, clouds, virtual machines, servers and applications to perform a variety of administration tasks, and Dynamics 365 is not an exception. The following script can be used to export a solution from one environment and import into other. It works with managed, unmanaged, and patch solutions. Execution of script can be triggered manually or it can… Continue Reading Yawer...
Flow variables
Today I was doing a Flow task and to complete it I used variable as a flag. It is very interesting Flow is a “No Code” approach but still many coding concepts are available in it. Having development experience or knowledge just open another door of creativity. The good thing is in Flow “No Code” means we don’t write code, rather we use code blocks as actions to do different things. We...
Create contact from received Email using Flow
Last week in a meeting client explained requirement: “.. we receive emails in a mail box, and we manually create contacts in CRM using sender name and address for further processing, we want to automate this.. .” This task was going to extend existing system functionality but there was no existing code to reuse or modify and of course expectation was to deliver this soon. So it was a perfect case to use Microsoft Business...