You require System Administrator or System Customizer and Environment Maker roles to publish the components/solution
Ben's Experiments
A notes to myself on exploration on System Center, Azure, PowerShell, DevOps and basic stuff.
Tuesday 10 October 2023
PowerApps: Failed to import Solution
Wednesday 20 July 2022
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.
Thursday 28 April 2022
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.
Thursday 9 December 2021
Azure: Licenses not assigned. License assignment failed for 1 user
Working on Azure portal today and trying to assign license to 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.
Saturday 9 October 2021
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:
- Create Data Operation - Compose to input the string.
- Create Control - Apply to each and add Data Operation - Compose inside.
- In Apply for Each, using referencing function to call Compose output. Enter Expression below:
- In Compose - Proper, enter Expression into Inputs as below:
- Create Data Operation - Compose for Result.
- In Compose - Result, enter Expression into Inputs as below:
join(outputs('Compose_-_Proper'), ' ')
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjyokgZPbkrkPVR6UeMPBm2f6RebUBg1m4pF06poJvj0TUpH0FfsG6GH92b7nx3Lelro26cKQC6GF8YrgXZ_MPVSF8HTwappcfq6UJqSxxWHQYbScywQtYBAgPjB0cF7u7ILll_56OjcZe/s16000/image.png)
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) ?
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
- Navigate to Site Permission > Advanced Permission Settings.
- Under Permission, select Create Group.
- Under Give Group Permission to this Site, tick View Only and click Create.
- Now you won't see Download option for the user assigned with View Only permission.