HK SharePoint AdminConnect Power App to Delta table from ADLS Gen 2There is no direct way available for Power app connecting to delta table. The method I provide here is indirect way to read Delta table…3 min read·Mar 1, 2024----
HK SharePoint AdminEnforce datetime value format in Power appsI need to save the date time value in MS SQL server. The format for datatype “Date” and “Datetime” are:1 min read·Dec 6, 2023----
HK SharePoint AdminYour app needs this connection. Please edit your app to add it back.When try to open a Power Apps with SQL server connection. I got below warning:2 min read·Nov 28, 2023----
HK SharePoint AdminRemove previous sign-on from PowerAppsRecently I finished a Power Apps project. Previously I used my iPhone to test the App via the Power Apps app. Therefore the old tenant’s…1 min read·Nov 8, 2023----
HK SharePoint AdminCreate Power Apps navigation menu and show/hide according to user roleThere are many blogs and YouTube video demonstrate how to build a dynamic navigation menu using Gallery. One of good reference is Power…2 min read·Nov 6, 2023----
HK SharePoint AdminThe length of substring can’t be longer than ‘x’ which is the length of the source string.This error is complaining your Power Automate substring function have invalid parameter.1 min read·May 12, 2023----
HK SharePoint AdminTroubleshooting using environment variables in Power Apps and Automate packed in SolutionRecently I am working on the package a solution and deploy to Test and then Production environment. It is a simple solution with 1 Power…4 min read·Jun 17, 2022----
HK SharePoint AdminGet 404 when connect SPO list from Power BI DesktopRecently tried to pick up some Power BI skill. First thing I want to do is import the data from SharePoint online to BI.1 min read·Jun 10, 2022----
HK SharePoint AdminRemove connections so connection reference can be addedWhen you need to package your Power Automate flow into solution, it is always recommended to replace all your “Connection” with “Connection…2 min read·May 29, 2022----
HK SharePoint AdminTaking Microsoft exam in Hong KongYou should take extra attention to the location. Hong Kong is a small city. You should be able to reach any test center within 1 hour. The…3 min read·Nov 26, 2021----