Monthly Archives: June 2021

How to limit number of checkbox selections in a gallery?

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?

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?

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 | 1 Comment

How to get User Profile Properties and ODfB information?

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?

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 | 3 Comments

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

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?

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

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?

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?

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