I've got a Logic App that reads in an email from a form submission. Unfortunately, I only have access to the email and not where the form results are stored, so I currently have the Logic App set up to…
I have a blob storage that has 2 Containers called input and output. when a file gets uploaded to input then a Function app (Blobtrigger) would work on it and save the result in output folder. right now i need…
The following logic app is triggered at 10 AM and runs a SQL server query. As you can tell from the picture the resultsets are empty. The conditional check checks whether the resultssets of the query is empty. (2nd pic)…
I have a scenario where I receive messages from service bus to trigger a workflow. This workflow does some processing but ultimately inserts some data into SQL DB. When 100,000's of messages appear at once, the DB gets overwhelmed. Is…
Creating a logic app to retrieve data from SQL server in JSON format. Calling SQL Stored Proc from Logic App trigged via HTTP Request. And using below select Query - FOR JSON to create the output as JSON and using…
I got to as far as a json result from log analytic query API HTTP action call: { "tables": [ { "name": "PrimaryResult", "columns": [ { "name": "TimeGenerated", "type": "datetime" }, { "name": "_queue", "type": "string" }, { "name": "_messages",…
I'm trying to get a list of reviews from an api. This gives me a JSON with nested properties. I manage to get almost all the data I need except from the nested array ["value"]["answers"]["value"] because sometimes the array ["answers"]…
I start learning the Azure Logic Apps and my first tasks is to store the result of a specific Kusto query from calling the log analytics of azure https://api.loganalytics.io/v1/workspaces/{guid}/query. Currently, I can successfully call the log analytics api using Http…
I have a problem showing the results in Outputs. In Outputs is shows only the first 500 rows of results. my expected result is over 600,000 rows. has anyone had a problem with this, is there a solution?
Azure logic apps 'o365 connector' action 'send approval email' returning null for property 'useremailaddress'. Why? The Azure logic apps documentation for the 'office 365 outlook connector' shows that the 'ApprovalEmailResponse' object returns 'SelectedOption' and 'UserEmailAddress'. I get the correct value…