I would like to know on how we ingest add all the dates in column from excel sheet to SQL Server using Logic Apps. I tried to use Compose and addDays expression but there's an error. Can you please help…
There is a variable in ADF that holds the below value. @json(concat('{','"S.No":',variables('counter'),',"Input Table":"Input TblName","Output Table":"[Tbl1, tbl2, Tbl3]", "Status":"Successful"}')) I pass this variable to a logic app using Web activity and use 'Create HTML Table' to convert this json to a…
I'm trying to group by below JSON Message: [ { "Id": "1", "name": "xxx", "age": "20" }, { "Id": "1", "name": "yyy", "age": "52" }, { "Id": "5", "name": "zzz", "age": "59" } ] to [ { "1": [ {…
I have a requirement to display a table in mail. I have used 'Create HTML Table' activity in logic app and below is the result. I want to add colors to alternative rows. Something like below. Is there a way…
What works: ability to edit workflows in VS Code designer ability to trigger HTTP and Service bus workflows What doesn't work: ability view run history ability to debug through workflows that have run, requires run history Also having random runtime…
I have a Logic app (LA) that have an http trigger. To the LA, I send a SOAP request similar to this: <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"></SOAP-ENV:Header> <SOAP-ENV:Body> <tns:Order xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="http://test.com"> <name>AAAA</name> <id>1234</id> <OrderType>new</OrderType> </tns:Order>…
Hello I have a logic app that looks for email attachments, I made an HTTP request to upload this file into a temporary blob storage. When I open my pdf file it is empty. I have a variable where I…
I am working on a scenario where I need to fetch the list of users having admin access (Global Administrator) permission on Azure AD and send them an email. However, when I started working on it I could not find…
Good afternoon everyone, I'm trying to create a simple Logic App, but for some reason that I can't understand, I am unable to save it. The Logic App is straightforward, it should only post a message on Slack when an…
I'm trying to add a new line in a concat in azure logic apps. but it only adds the new line as a string instead. My goal is to add an array of object I get into a word doc.…