Execute SharePoint Online PowerShell scripts using Power Automate
May26

Execute SharePoint Online PowerShell scripts using Power Automate

Most of us would have used PowerShell for SharePoint to manage SharePoint settings at the organization level and site collection level. SharePoint Online PowerShell commands are very efficient for batch operations for e.g creating multiple sites, list items etc. To use the SharePoint Online PowerShell commands You must have the SharePoint Admin role or Global Administrator role in Office… Continue Reading ashiqf’s Article...

Read More
Access Active Directory user profile attributes using Graph API
May25

Access Active Directory user profile attributes using Graph API

Using graph API you can access all the Active directory attributes. The me endpoint gives your profile information https://graph.microsoft.com/v1.0/me. To get a specific user’s information the endpoint should be https://graph.microsoft.com/v1.0/users/useremailaddress For getting any specific AD attribute you can pass the required attribute as a query string

Read More
CDS current environment connector : “The following filtering attributes are not valid:…”
May20

CDS current environment connector : “The following filtering attributes are not valid:…”

Life is pain… “The following filtering attributes are not valid:…” {  “error”: {    “code”: “0x80040203”,    “message”: “The following filtering attributes are not valid:  lastname”  }} Fix the trigger …error Remove the white space between the comma and the next attribute! A white space between filtering attributes causing the error. No white...

Read More
Pass “reference” data from a parent Flow to a child Flow
May18

Pass “reference” data from a parent Flow to a child Flow

If you ever wonder how to do this is the exact time to figure it out together. These are types of user inputs you can pass to a child flow: Child Flow user input types: Text, Yes/No, File, Number, Date. What I was doing previously is passing a record ID as a Text input parameter then I was querying data using this ID. Like this: Query record in a child Flow to workaround a pass… Continue Reading Olena Grischenko’s Article...

Read More
Change the original Owner of a Power App & Flow
May18

Change the original Owner of a Power App & Flow

Has there been a requirement or a need to change the owner/creator of the PowerApps or a Flow built by your organizational users? There could be various reasons for this request App/flow creator would have left the organizationApp/flow creator would have changed role within the organizationHanding over the app to the operations team… By the time I am writing this post there are no… Continue Reading ashiqf’s Article...

Read More
Integrating Power BI Reports on Power Apps Screen
May16

Integrating Power BI Reports on Power Apps Screen

This post will explain how to bring the whole Power Bi report which is not in a Power BI dashboard on to a Power Apps’ screen. And also to enable all the Power BI Interactions on the screen itself without having to make the users go to Power BI app or service. Start by adding … Continue reading “Integrating Power BI Reports on Power Apps Screen” The post Integrating Power BI Reports on Power… Continue...

Read More
Automate the provision of Azure AD Account & License assignment – Part 1
May16

Automate the provision of Azure AD Account & License assignment – Part 1

A decade back I was part of a team to automate the On & Offboarding process of employees for a customer using .NET framework, it had a module to provision user accounts in an on-premise environment. I still remember having used couple of dll’s for Active directory 2003 & exchange 2007 to create AD & Email account. It was not easy but nowadays with the Office 365 in place its so easy to… Continue Reading...

Read More
Populating Word template with the CDS image field content via Flow (Power Automate)
May12

Populating Word template with the CDS image field content via Flow (Power Automate)

This is a great video which helped me on a way: https://www.youtube.com/watch?v=-1jsBllmr-w However, in this video it takes image from OneDrive but I want to populate it from CDS image field. Add image control to a Word template. Watch video I referred above showing how to add controls step by step then come back for the image adding part. Image control inside Word template. 2…. Continue Reading Olena Grischenko’s Article...

Read More
CDS current environment connector: Filtering attributes for the record created
May11

CDS current environment connector: Filtering attributes for the record created

Let’s say I want trigger some logic when the particular field has been modified on a record. In this example, I modify a contact Email field and create a Note when it’s been modified. I picked up a trigger for Create or Update because you can enter Email for a new record or you can just update. It’s obvious if you’ve ever created any plug-in in your previous life that Filtering… Continue Reading Olena...

Read More
Braintree payments PCF component (Power Apps)
May01

Braintree payments PCF component (Power Apps)

(The below has been described and tested for Canvas Power Apps. This has not yet been tested and adapted for Model-driven apps. As for the Power App Portal app, another integration pattern is appropriate, to be discussed later) This package for import in your CDS environment and source code of the control are packaged here: https://github.com/andrew-grischenko/BraintreePaymentsPCF This is a… Continue Reading Olena...

Read More
Setting up Office 365 E3 trial (video)
May01

Setting up Office 365 E3 trial (video)

I started my YouTube channel last week. This particular video I am going to leave here. If you want to explore new features, test how things work or just do training setting up your playground environment would be a very good idea. If you don’t know where to start, watch this video: Continue Reading Olena Grischenko’s Article on their blog Setting up Office 365 E3 trial (video) I started my YouTube channel last week. This...

Read More
SharePoint Search REST API query not returning all results
Apr28

SharePoint Search REST API query not returning all results

Have you ever faced a scenario where you have built search customization using Rest API with SPFx or custom display template in SharePoint 2013 etc which did not return all search results. I was facing this today while trying to get data based on a content type, it was returning only few results. The reason is because Search API by default removes duplicates as documented by Microsoft…. Continue Reading ashiqf’s Article on...

Read More
Renaming Child Flow: the magic didn’t happen
Apr28

Renaming Child Flow: the magic didn’t happen

Oops, I did it again! I renamed my child Flow action from “Run Child Flow” into “Generate Code”. I was counting on the intelligence of the engine to figure things out for me. Wouldn’t it expect me to re-add all my references to the Flow? Or would it? I was pleasantly surprised seeing the “Generate_Code” reference instead of “Run_Child_Flow” but it was too soon. After the first run...

Read More
Implementing Try,Catch and Finally in Power Automate
Apr27

Implementing Try,Catch and Finally in Power Automate

No matter how great we are in programming , sometimes our code has errors. They may occur because of our mistakes, an unexpected user input, an erroneous server response, and for a thousand other reasons. So handling these exceptions is very important . Anyone who has even a little experience with programming knows the “try … Continue reading “Implementing Try,Catch and Finally in Power… Continue Reading Nagaraja...

Read More
Multi-Filter with multiple values in Canvas App
Apr25

Multi-Filter with multiple values in Canvas App

Did your work ever require you to create a multi-level filter that lets you choose multiple values in each one? Something like this and you had to settle with single filter or multi filter with single value selected? Then, here is the solution for you. Below is the step by step process for multi- level … Continue reading “Multi-Filter with multiple values in Canvas App” The post Multi-Filter… Continue Reading...

Read More
Locking Out setting for Power Apps Portal for confused developers
Apr24

Locking Out setting for Power Apps Portal for confused developers

It came back to me from PROD saying it didn’t pass some last minute tests. After 5 attempts to login to the system user account was locked as it was expected but remained locked for much longer which was an unpleasant surprise to me. I remember setting login attempts to 1000 on the request from business on UAT and accidentally moving it to PROD like this. Our portal isn’t live yet so I… Continue Reading Olena...

Read More
Tip : Using Trigger Conditions in Power Automate
Apr15

Tip : Using Trigger Conditions in Power Automate

I have come across a requirement to trigger flow when a record is updated and one of the fields contains data. We can achieve this using condition action . But there is a better way to do it using Trigger Condition setting in Power Automate and  functions provided by the Workflow Definition Language. Here are the steps. … Continue reading “Tip : Using Trigger Conditions in Power… Continue Reading Nagaraja...

Read More
“Stripe” payments PCF component (Power Apps)
Mar31

“Stripe” payments PCF component (Power Apps)

There is an article my partner published on our company website. We’ve spent some time working with custom connectors and experimenting with different types of integrations with Dynamics 365, CDS and Power Platform. If you are interested to learn more about PCF controls and how to combine all above together in a working solution it will be a good reading for you. (The below has been… Continue Reading Olena...

Read More
Issue with custom ribbon buttons ? Here is the command checker tool by Microsoft
Mar29

Issue with custom ribbon buttons ? Here is the command checker tool by Microsoft

If you are experiencing an issue in a Dynamics 365 or Power Apps model-driven application with a ribbon command bar button, Here is the way to find and solve the problem easily. Microsoft use an in-app tool called the Command Checker to inspect the ribbon component definitions to help us determine what might be causing problems. Now this … Continue reading “Issue with custom ribbon buttons… Continue Reading Nagaraja...

Read More
Tip : Finding the inactive users in Dynamics 365 CE
Mar27

Tip : Finding the inactive users in Dynamics 365 CE

Recently , I have come across a requirement to get the list of users who are not active in Dynamics 365 CE for past 3 months. It means that these people never logged in to the application in the past 3 months. There is no OOB solution for this. But we have a plugin in … Continue reading “Tip : Finding the inactive users in Dynamics 365 CE” Continue Reading Nagaraja Emmadisetty’s Article on their blog Tip :...

Read More
Batch Operation in Power Automate
Mar23

Batch Operation in Power Automate

If we want to perform multiple actions Common Data Service at once , like creating/ updating 100 different records, Flow will make many different calls to CDS. Although it works fine, but it takes lot of time and keeping limitations on number of requests , this might not be a good approach. But, no worries … Continue reading “Batch Operation in Power Automate” Continue Reading Nagaraja Emmadisetty’s Article on...

Read More
Issue with npm install command : PowerApps Component Framework
Feb25

Issue with npm install command : PowerApps Component Framework

Recently , I have come across an issue while building a custom control. I had experience of developing custom controls before. But , I never faced this issue before. Issue : The component project would require lots of external files to build successfully. To install project dependencies, we need to run command ‘npm install’ in … Continue reading “Issue with npm install command : PowerApps… Continue...

Read More
Kanban view for  Opportunities : D365 2020 release wave 1
Feb10

Kanban view for Opportunities : D365 2020 release wave 1

As part of Dynamics 365 2020 wave 1 release, We can have a Kanban view on opportunities. We have early access to this feature from Feb 3rd and it will be part of general availability in Apr 2020. Feature details : To enable this feature, Add Kanban control for opportunity entity and publish. Note : … Continue reading “Kanban view for Opportunities : D365 2020 release wave 1” Continue Reading Nagaraja...

Read More
@ mention user & channel in Teams using MS Graph API
Feb09

@ mention user & channel in Teams using MS Graph API

There are ways to @mention a user while posting a conversation in Teams channel using flow action but as far as I know its not possible as of now to @mention a Teams channel using Flow actions. In this post, I will show you how to @mention a channel & user using a POST call to a MS Graph beta endpoint. To construct the endpoint URL you will need to know the TeamID & ChannelID, to get the… Continue Reading ashiqf’s...

Read More

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.