Tech Battle Field

Sometimes we may need to re-submit multiple failed/cancelled flows if we have any issue and after fixing the issues. We can run the flows in Bulk using the steps below, Open https://flow.microsoft.com Click on My Flows in the left navigation Click on the flow to run in bulk Click on All Runs in the flow Select the flow and click on Resubmit on the top as below

 While working with PowerApps I have configured multiple flows on a PowerApps buttons click. All the flows working as usual and all the sudden they failed to start on the users. Flows working as expected with my account (i.e. when I click on button flow is triggering as expecting). I have verified re-adding the flow to PowerApps and published the app. Not worked. After that I have verified all the flows in the app are having same issue. As the current flow saving the item in the SharePoint list I thought it might be SharePoint permissions. Created a new flow just to send email with manual trigger. It worked as expected. But adding PowerApps trigger not triggered the flow. Tried to use PowerApps trigger V1 and PowerApps trigger v2. It was not worked for both the triggers. After checking multiple options, In flows clicked on connection in the left navigation. Verified all the connections are authenticated. Initially I left it as all of them are connected. But later I have re-auth...

We can send notifications from PowerApps using Data Connections. To send emails get the App Id  using the Post. In PowerApps data source, search for Power Apps Notifications as below. Enter the App Id and after selecting “Power Apps Notifications”. Click on Connect. Now to send email, add following logic. For example, on Button, add the logic on button click. Following are the parameters on the Send Notification method. recipients – Required value. Email address to be send the notification message – Required value. Message to be sent to users openApp – optional. True or false to open the app while sending the emails. params – Optional – Key Value pair to pass in the notification.      

In PowerApps SharePoint choice field will be shown as dropdown by default. Even we change the type in to Choice from dropdown to radio button it will still show as dropdown as shown the images below. I have created Location field as choice field with dropdown Adding it to PowerApps form we can see dropdown. As user wanted to show the field as radio button option I have updated the SharePoint field setting and refreshed in PowerApps, still see it as dropdown as below. After checking the blogs, I have found following solution. To show dropdown field as radio button, remove the dropdown in the form add Radio buttons as below. Unlock Field and remove all the fields. Add Radio field.  In Radio Button select  Items  formulae as below OnSelect  filed update the formula to be update the selected value. In Update formulae update as below.. This will update to radio buttons in the formulae. 

 Every time while working with PowerApps with large data sets I can see the delegation issue and get only 2000 items. By default PowerApps supports only 500 items. We can set the items until 2000 in the PowerApps setting by navigating Settings of the Power Apps and set “Data Row Limit” to 2000 as below. But working with more than 2000 records is always issue in Power apps due to delegation limitation. For that I have used simple function using Concurrent as below. Concurrent function will run multiple functions concurrently. Using following logic, I got multiple items (for my case it is 10000 records in the SharePoint Lists item. I have used following function to get the items Concurrent( ClearCollect( Collection1To2000, Filter(SharePointListName,ID<2000) ), ClearCollect( Collection2000To4000 , Filter(SharePointListName,ID >=2000 And ID<4000)), ClearCollect( Collection4000To6000, Filter(SharePointListName,ID >=4000 And ID<6000)), ClearCollect( Collection6...

Updating SharePoint user columns using patch, for Text and Number fields we can directly pass the value to the column. But for lookup and user fields passing direct values will not work. To update User filed values we have to update the claims ID and Display Name. For example I have a filed called Sponcer – As user type column. We can update following formulae in the patch function. For updating multiple users, we need to add the users to a collection in the update column section and pass the values in Patch function.

Patch function will submit data from PowerApps to Destination Data location. Sometimes we may not see if patch is successful or failure in the PowerApps until we see the record in Destination location. By using Error Functions in PowerApps we will Notify the Patch errors. Error, IfError, ISError, IsBlankOrError functions will be helpful to detect the errors in the Action. But all these functions will be available in Experimental features in PowerApps. To get the functions, we need to enable the Experimental Features in PowerApps in Settings -> Upcoming Features -> Experimental as below. Error Function will allow us to see if there is any error on patching the Destination. We can add Error function for patching as below. If(IsEmpty(Errors(' <<Destination>> ',                                                   ...

Range function in flows help us to get the range of the list items from position to Specified number of items. Range function will help us to see the items located in a array. We can also use he Range function to loop the specific items using apply-each loop Here is the syntax for Range function. Range(<Start position of the array>,<Number of positions in the array>) For example if we write Range(2,10), we can get the items Index starting from 2 nd index to counting 10 index point including 2 nd position. We will get the items from 2 nd Index position to 12 th Index position. Here is the usage of the Range function, In initialize variable, Value section, Dynamic expression, enter the Range(2,10) as below. It will return the values as below.

 Flow analytics will help us to understand the flow Usage, Actions and Error details. We can get the Analytics of the flow using the steps below. Selecting three dots right side of the flow Selecting Analytics on the top after opening the flow as below. We can get max 30 days Analytics. After Opening the Analytics we can see Actions, Usage and Errors in different tabs as below In the Action Section we can get the Aggregate count of the Action executed on the specific day. In the Usage section, we can see the reports of the flow runs and Total number of nus and trend of Fails and successful runs. By clicking on bar, it will highlight all three sections as below. On Errors tab we can see the Error report and each action count the flow failed as below. By clicking on filter and sleeting the error, it will highlight the error information. In the Error details, it will show the error logs with the link. By clicking on the link it will navigate to the error details informat...