cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Piia
Level: Powered On

Problem sending message to Azure Service Bus queue

Hi,

 

I'm trying to send a simple test message to Azure Servive Bus queue from PowerApps, but I'm having problems with Properties -table syntax.

 

AzureServiceBus.SendMessage("tilastointiqueue"; {

ContentData:"Some text";

ContentType:"String";

ContentTransferEncoding:"base64";

Label:"Heading";

Properties:Table( {Name:"name1", Value: 1},{Name:"name2", Value:2} )

} )

 

Error says that Column with type Text is missing, but I can't find a way to fix it.

 

I am able to send the message to queue without Properties-parameter, but the ContentData doesn't seem to be transferred with the message since the Message Text is empty.

 

Has somenone send messages to Service Bus queue succesfully?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
wjhepworth
Level: Powered On

Re: Problem sending message to Azure Service Bus queue

So I encountered this recently and have a few notes in case anybody needs them.  They don't appear anywhere else it seems.

 

First, if you are trying to pass JSON it may be easier to go with the Properties parameter which is reflected on the Service Bus trigger's UserProperties when the Service Bus listener picks it up on the other end.  The trick is, the Table that it expects must be in the form of:

 

Table (
    {key: "myFirstFieldName", value: "My first field's value"}, 
    {key: "mySecondFieldName", value: "My second field's value"}, 
    {key: "myOtherFieldName", value: "More values"}
}

 

The trick is.. there must be two fields and both in lower case: 'key' and 'value'.  If not you will get a cryptic message (though truthful) that you are missing a column 'key' of type Text.  I didn't see this in any documentation so thought I would share.
 


View solution in original post

7 REPLIES 7
Community Support Team
Community Support Team

Re: Problem sending message to Azure Service Bus queue

Hi Pia,

 

I wll try to find someone who is familiar with this to take a further look.

There might be sometime delay before sharing the results.

Appreciate your patience and understanding.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Piia
Level: Powered On

Re: Problem sending message to Azure Service Bus queue

This issue was caused by my language setting (Finnish). Sending message with Properties-table to Azure Service Bus queue works fine, after changing my language to English.

Community Support Team
Community Support Team

Re: Problem sending message to Azure Service Bus queue

Hi @Piia,

 

Thanks for the update and sharing.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wjhepworth
Level: Powered On

Re: Problem sending message to Azure Service Bus queue

So I encountered this recently and have a few notes in case anybody needs them.  They don't appear anywhere else it seems.

 

First, if you are trying to pass JSON it may be easier to go with the Properties parameter which is reflected on the Service Bus trigger's UserProperties when the Service Bus listener picks it up on the other end.  The trick is, the Table that it expects must be in the form of:

 

Table (
    {key: "myFirstFieldName", value: "My first field's value"}, 
    {key: "mySecondFieldName", value: "My second field's value"}, 
    {key: "myOtherFieldName", value: "More values"}
}

 

The trick is.. there must be two fields and both in lower case: 'key' and 'value'.  If not you will get a cryptic message (though truthful) that you are missing a column 'key' of type Text.  I didn't see this in any documentation so thought I would share.
 


View solution in original post

sphillips22
Level: Powered On

Re: Problem sending message to Azure Service Bus queue

@wjhepworth  I am super grateful for your response. It worked for me. Curious, where/how did you find-out that it is required to pass the table in this format?

wjhepworth
Level: Powered On

Re: Problem sending message to Azure Service Bus queue

Honestly, it was a case of researching and experimentation and asking myself reallly exactly what the error messages meant.  There was all kinds of documentation talking about the fact that the Properties attribute existed but none specifying was would go in there.  Turns out I kept getting and error message saying it was missing 'key' and 'value' fields.  At first I converted my initial appraoch to just repeat rows with Key / Value paires thinking that would work. When it still guessed they were case sensitive on those fields and sure enough that worked.  Glad it helped.

sphillips22
Level: Powered On

Re: Problem sending message to Azure Service Bus queue

@wjhepworth Very scientific! Have you had any success parsing out the Properties parameter within Logic Apps? Specifically the table values that can get passed in using the "key &  value" format you provided. I have not had any success with it myself, so far.

Thanks --SP

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,720)