PowerApps: Failed to import Solution

Error Message :

Solution "Power Platform Administration Planning" failed to import: SecLib::CheckPrivilege failed. User: 032e13d7-cda3-ea11-a812-000d3a09153d, PrivilegeName: prvCreateEntity, PrivilegeId: 341e3ebf-74b8-4335-84f3-7f617bb7d081, Required Depth: Basic, BusinessUnitId: 6a3d9611-7d04-e911-a985-000d3aa371be, MetadataCache Privileges Count: 5201, User Privileges Count: 1232

The error message doesn't tell which permission is missing. After granted permission for System Administrator and imported successfully. Below are few permission that you can assign for the user to resolve this.

You require System Administrator or System Customizer and Environment Maker roles to publish the components/solution

PowerApps: Error code 502 - The server did not receive a response from an upstream server

Working on PowerApps project and integrating with PowerAutomate (Flow) to perform some update on SharePoint List. The PowerApps thrown error as screen shot below.

Error Code 502 - The server did not receive a response from an upstream server.

WorkFlowName.Run failed: { "error": { "code": 502, "source": "asia-001.azure-apim.net", "clientRequestId": "a1dd8bf2-cfba-465b-89d5-25c8f380a974", "message": "BadGateway", "innerError": { "error": { "code": "NoResponse", "message": "The server did not receive a response from an upstream server. Request tracking id '08585434596297091463243902025CU13'." } } } }

When check in flows's history, the status show succeeded and data is updated into SharePoint list without issue.

Tried many ways and tips from community like below:

 - Export and Import as new flows

 - Re-create the same flows

 - Change sharepoint list's column data type

 - Change data input of PowerApps flow 

 - Etc ...

There is no impact to the PowerApps functionality but Bad user experience to customer when using the PowerApps. 

Thank you to my peer Nimesh who help to resolved this issue. What he did was added return a response back to PowerApps. And that's it simple trick. 

If you are facing the same error please give it a try.

Recommended to have this as a practice to always return a response back to PowerApps in the flows.

Hope this will save your time for troubleshooting.

Intune : Windows Autopilot White Glove Using Wireless Network

Nowadays people is preferred using Wireless network connection rather than Ethernet LAN connection.

I'm the first if you are not yet into wireless :)

During Windows Autopilot pre-provision OOBE, you can press SHIFT + F10 to open a command prompt.

Enter command below 

    start ms-availablenetworks:

Network & Internet Settings banner will prompt for you to choose which Wifi to connect.

Azure: Licenses not assigned. License assignment failed for 1 user

Working on Azure portal today and trying to assign license to user. 

But keep receive error "License not assigned. License assignment failed for 1 user."

Wondering what could be missing for Global Administrator roles. Thank you to CJ for help on resolved this.

Usage Location – Why it is important?

This property is the one used while assigning a license to a user in office 365. Some services in Office 365 are not available in certain countries and “Microsoft” determines this with the help of UsageLocation. 

This is a mandatory property that needs to be assigned while assigning the license.

After updated the Usage Location, no issue to assign license to the user now.

Power Automate: Proper Case String Workaroud

There is Proper functions in Power Apps to converts any first letter of a word to Uppercase.

But there is no Proper case function in Power Automate yet. 

Reference to a blog post written by Paul Murana to achieve the same result.

Below is the Input.

and here is the Output.

Follow the steps below:

1. Create Data Operation - Compose to input the string.
   
   
   
   
   
2. Create Control - Apply to each and add Data Operation - Compose inside.
   
   
   
   
   
3. In Apply for Each, using referencing function to call Compose output. Enter Expression below:
   
   

   split(outputs('Compose'), ' ')

    

   

   
   

4. In Compose - Proper, enter Expression into Inputs as below:
   
   

   if(equals(length(item()), 1), toupper(item()), concat(first(toupper(item())), toLower(substring(item(), 1, sub(length(item()), 1)))))

    

   

   
   

5. Create Data Operation - Compose for Result.
   
   
   
   
   
6. In Compose - Result, enter Expression into Inputs as below:
   
   

   join(outputs('Compose_-_Proper'), ' ')

   


You have Proper Case function in Power Automate now.

Power Automate: Return value from Execute a SQL Query (V2)

Working on Power Automate aka Flow to retrieve result from Execute a SQL query (V2).

Wondering where is Dynamic Content for Execute a SQL query (V2) ?

Execute a SQL query (V2) response:

Add Compose action underneath and go to expressions and paste this in.

    body('Execute_a_SQL_query_(V2)')?['resultsets']['Table1'][0]['Approved']

It just work like a charm !

SharePoint Online: How to Restrict Download for Document library

For IRM protected document library, you will see this error while uploading protected or digitally signed PDF files. Something that working fine for Sharepoint 2010 but NOT for SharePoint Online.

According to Microsoft article:

IRM protection cannot be applied to protected documents as SharePoint needs to open the documents on upload

This is most demanded features for SharePoint Online UserVoice suggestion. 

Unfortunately, This UserVoice instance is no longer available anymore. While waiting for Microsoft to allow upload password protected / AIP protected / digitally signed PDF files in SharePoint IRM document library, workaround need to be in place.

Since we are not able to upload protected PDF into IRMed folder, only option is upload into non-IRM folder. 

To further protect the PDF, customer have asked on how to restrict download PDF from document library.

How to hide/restrict Download from the document library ?

Please follow the step below to remove Download option.

1. Navigate to Site Permission > Advanced Permission Settings.
2. Under Permission, select Create Group.
   
   
   
   
   
3. Under Give Group Permission to this Site, tick View Only and click Create.
   
   
   
   
   
4. Now you won't see Download option for the user assigned with View Only permission.

No Save/Download option in preview too.