Monthly Archives: June 2021

How to limit number of checkbox selections in a gallery?

Posted on June 30, 2021 by Pankaj

Summary This is text version of the video by Daniel Christian. #1 Add a Gallery control Gallery1 #2 Add a Check Box control in the Gallary #3 Remove the border of the checkbox #4 Add a Label control name it … Continue reading →

Posted in Power Apps | Leave a comment

How to take an action in Power Automate only when certain field’s value have changed?

Posted on June 29, 2021 by Pankaj

Summary Here is the scenario, there is a list named “OrderList” with the following five fields. The end users change any of these fields except Order Status. The Order Status field is changed externally. Field Name Field Type OrderID Number … Continue reading →

Posted in Uncategorized | Leave a comment

How to fix an infinite trigger loop in Power Automate?

Posted on June 25, 2021 by Pankaj

Summary Have you seen the following error in your Power Automate? “Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself.“ If your answer is … Continue reading →

Posted in Power Automate | 2 Comments

How to get User Profile Properties and ODfB information?

Posted on June 25, 2021 by Pankaj

Summary I want to find out the User’s OneDrive for Business url or personal site. I also want to find more such user properties for the user with UPN, such as when the personal site created, if not created what … Continue reading →

Posted in PnP.PowerShell | Leave a comment

How to find all associated Power Automate Flows for a SharePoint list?

Posted on June 17, 2021 by Pankaj

Summary A customer showed a working Power Automate for an item created trigger. There was an approval action in the flow so technically only one email should be sent for a new item. But she noticed multiple approvals emails were … Continue reading →

Posted in Power Apps, Power Apps, Power Automate | 5 Comments

How to create Site Columns using field schema xml in Power Automate?

Posted on June 16, 2021 by Pankaj

Summary This is a very simple blog to create site column using Schema XML. The Schema XML can be extracted with PnP.PowerShell. First manually create the Site Column on your site. After you are happy with the created fields you … Continue reading →

Posted in Power Automate, Uncategorized | Leave a comment

How to setup certificate in MAG Azure Function App for PnP.PowerShell?

Posted on June 11, 2021 by Pankaj

Summary The PnP.PowerShell supports PowerShell Core. There are few things you must do to make the PowerShell Code to work in Azure Function App. In this article, I will go through the steps by step all pre requisites. Step by … Continue reading →

Posted in MS Graph, PnP.PowerShell | 3 Comments

DOs and DON’Ts for Performant PowerApps

Posted on June 11, 2021 by Pankaj

Summary I have watched multiple MVP’s video talking about PowerApps performance. Here I want to make this as a list of DOs and DON’Ts for PowerApps performance. Limit data connections DO: Use less data connectors in your app. DON’T: Don’t … Continue reading →

Posted in Uncategorized | Leave a comment

How to remove SCA users from Site Collection Admins?

Posted on June 10, 2021 by Pankaj

Summary This is kind of similar requirement from my previous blog article. How to remove users from multiple Azure AD Groups? But in this article I will provide only the code for removing the Site collection Admins from SharePoint Site. … Continue reading →

Posted in Uncategorized | Leave a comment

How to remove users from multiple Azure AD Groups?

Posted on June 9, 2021 by Pankaj

Summary For my customer there were many Modern Team Sites in the tenant. These sites had 4 to 5 users present in the Owners group. These users were added when the sites were originally created by a automated script. But … Continue reading →

Posted in PnP.PowerShell | 1 Comment