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”: { […]

Continue reading

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 ! This […]

Continue reading

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 […]

Continue reading

SharePoint Online: View Only Permission Level is hidden

Excited to know that there are way to restrict downloading on SharePoint Online Document Library. But where is the Read Only permission ? Follow the steps below to Activate it. Navigate to Site Settings > Site Collection Administration > Site Collection Features. Look for SharePoint Server Enterprise Site Collection features Click Activate. Here you go. View Only […]

Continue reading

PowerApps Portal: How to Add Favicon

 To add favicon into PowerApps Portal. Prepare .ICO file before proceed further. you can use any online site to convert the file. I tried that but not sacrificed with outcome which larger file size from original. Tips: just rename .PNG to .ICON will do You can download it from website as well. Quick hack : […]

Continue reading

Orchestrator: Runbook Error “The term Get-SCSMObject is not recognized as the name of a cmlet…”

Working on a project to upgrade System Center Service Manager (SCSM) and Orchestrator (SCO) 2019 recently, seeing a familiar error message from Orchestrator Runbook again. Runbook activity show Failed. Error : The tern ‘Get-SCSMObject’ is not recognized as the name of a cmlet, function, script file, or operable program. Check the spelling of the name, […]

Continue reading
1 2 3 17