Tech Battle Field

 PowerApps will be determined by the refresh cadence mentioned previous post. So that default version of the PowerApps studio will be depend on the configuration settings in the refresh cadence in admin center. We can also update the authoring version of the Power Apps. But we need to make sure updating the app whenever it is needed as per Microsoft guidelines. We can check the PowerApps studio version using the steps below, Click on “Settings” It will open the popup as below. Click on Settings and see the Authoring version. As Microsoft, if you are informed to update the version, click on Edit on the Authoring version, Edit the “Authoring Versioning” Select the Version to be updated Click on Reload + Apply Version. PowerApps studio always start the default version. So applying the changes will update only current authoring versions In Some cases, Power Apps studio will show the following message while opening the app. If we choose “Restore Previous version”, previous ve

Refresh Cadence is a setting in Power Platform to choose the updates in power Platform environment. It will allow us to set the updates to the environment released by Microsoft Power Platform Service. Microsoft provide two options in the refresh cadence. We can set refresh cadence after creating new environment. These settings will apply to Canvas app authoring service. Frequent Setting will allow all the latest updates and newest features multiple times in a month based on receiving the updates. Moderate setting will allow all the updates to the features once in a month By default, “Frequent” option will be set to environment. So that Canvas apps will receive updates multiple times in a month. If app is published, updates will apply to the runtime version. Similarly, if we choose the “Moderate” version, changes will apply to the latest runtime version. Here are the steps to set refresh cadence to an environment, Open, https://admin.powerplatform.microsoft.com/ Click on

 To troubleshoot the issue in any PowerApps and to report the details to Microsoft support, we need to provide the Session and App ID’s. Here are the steps to get Session ID’s and App ID’s of a PowerApps. We can get the Session ID from different ways. Get Session ID from Canvas App Edit Page Open Power App and Click on File and Click on Account. It will open the Pop-up as below. Click on “Support”. Under Session ID, Click on Session Details and Copy the Information as below Get Session ID from Desktop Running App To get the Session ID from a Running app, Click on Top Right Gear Icon and Click on Session Details as below. Click on Session Details. It will open the Session details as below. Get Session ID from running canvas app in Mobile We can get the Session ID from app running in Mobile using the steps below. Click on Top Left three Lines. Click on Session details as below. Get App ID from PowerApps Open https://make.powerapps.com Click on Apps and Select the App to ge

While working with updating 9000+ records from Excel to SharePoint list, I see flow terminating after some time. (like 15 to 20 mins). After going in to the flow action flow successfully executed the records and deleted the processed entries (I am removing the successful entries). Every time I see there were only 256 records processed without depending on the time (some time it is stopping at 15 mins and some time it is stopping at 25 mins). I have investigated the issue and found-out it is Pagination setting. We can see the same issue with SharePoint list. It will get only Top 100 records if there is no pagination. By default Get Excel rows set to 256 rows as threshold if there is no Pagination set. We can set the Pagination for the List rows using the steps below. Enable Pagination and Enter the Threshold value. I have entered it as 1024. While processing the Excel updates, it tool 1024 records and stop the flow. Similarly, we can set the Pagination for Get List Item action to pr

While merging two SharePoint lists in Power Apps, I have used Employee ID as a lookup Column. But both lists are using Same Name as “Employee ID”.   To Fix the issue, we need to use “With” function to update the column. Here are the logic I have used to merge the lists. Here “NewStudAdmin” is a partial data. Here With  function evaluates a formula for a single record. This formula calculate the value to perform actions to modify the data while working with collections. The above formula will work to combine two lists data based on Employee ID. Here EmployeeData1 – LIST1 EmployeeData2 – LIST2 We need to merge these two lists based on Employee ID common field in the two lists. When I try to merge these lists with ForAll and Lookup without “ With ” function, I got an error “Incompatible to comparing the two lists in the Lookup” Hope this helps.

 When a Owner or creator or a flow leave the organization without assigning a Co-owner. If flow is having connections it may fail due to authentication issues. Admin can manage the orphaned flows by adding co-owners to continue the process. Co-owner will have same permissions like owners so that they can fix the authentication issues in the connections How to check and update the flow owners to a Orphaned flow Navigate to https://admin.powerplatform.microsoft.com/home Click on Environments and select the environment. Click on Resources tab as below Click on Flows and see if there any flows not having Owner (For Orphaned flows Owner will show as “None”) To Assign the flows with other users, Select the flow and click on “Share” on the top. Type the new owner name and select the owner and save the user. Add user and click on Save to update the Co-Owner. After assigning the Co-Owner, they can update the connections and use the flows.

 While working with PowerApps SQL connector, i got the error as “An error occurred on the server. Server Response: Not a valid connector Error response” as below. I have removed and re-added the connection for SQL server and tried to remove and re-add the table in the SQL and re-added the SQL connection. Issue not fixed. After investigating the issue further, I found out there PowerApps not support following data types, binary()     varbinary() image cursor   rowversion, hierarchyid,   sql_variant xml   Spatial Geometry Types - Spatial Geography Types, and table. I have used binary() type in my table. That is the reason I am seeing the issue. After removing the binary() column I am able to fix the issue.

  Responsive design is a way of designing a webpage/app that allows to use flexible layouts and images, Styles. This allows to webpages detect the user screen size and orientation and change the display options accordingly. Why Responsive design? Technology changing rapidly these days. End user can access the site from any device (like Desktop, laptop, phone, tablets). If site is built to a specific target environment, site will be adjusted to the different devices. That will impact the end user accessibility to site. To make sure the great user experience to the end user, our site should be compatible to different devices.   If the user is intended to use the site in only in web browser, site/app should be flexible on different devices. PowerApps are created to provide responsive for different devices and there is an app built for PowerApps for mobile devices. Downloading the PowerApps app and login to the app will pull all the app that are provided access to the user. To buil

In one of my projects, I got a requirement to get the data from Multiple tables in SQL server and update it to SharePoint list. I have using Join function to combine three tables and saved it to a collection as below. ClearCollect(EmployeeDetails,     AddColumns(         Employees,         "Subjects",         LookUp(Subjects, EmployeeId = Orders[@EmployeeId]))) After collecting data, we can loop all the data in the collection and update it to SharePoint list using the patch function as below. ForAll(EmployeeDetails, Patch(                 MarksDetails,                 Defaults(MarksDetails),                 {Marks1: Marks1,                 Marks2: Marks2,                 Marks3: Marks3,                 Marks4: Marks4,                 Created: Now()})) It will save all the data from Employee Details collection to Marks Details list in SharePoint.

 In the modern SPOL, when you try to upload a custom css file, you end up getting an error like this.  This is  related to the No script setting in Modern Sites, you may need to use the below PS snippet to turnoff NoScript on the Modern Site. Connect-SPOService -Url https://<tenantname>-admin.sharepoint.com Set-SPOSite -Identity https://<SiteUrl> -DenyAddAndCustomizePages 0 One other way of doing this is to inject using one of the SPFX PnP widget -  https://github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-add-js-css-ref