Need help to refine output message to Slack

[Anonymous]

Hi,

I have an existing flow that runs a query against a PBi dataset and then sends the output of the query in a message to a Slack channel. The flow works however the output of the message needs refining. As per screenshot, I would like to remove unnecesssary characters i.e. [], {}, " "

Appreciate any help please @Expiscornovus @fchopo 

Link to PBi file (dataset) for reference if you need
https://drive.google.com/file/d/1TPCqUXnktujYVVyW-OM-kmStLPArq8d7/view?usp=sharing

[Expiscornovus]

Hi @Anonymous,

Instead of the compose you could try a Select action. Use an expression to only retrieve the value of the [=] column.

Below is an example of that approach.

Switch the Map field to text mode and add the following expression:

item()?['[=]']

[Anonymous]

@Expiscornovus so I replaced it with 'Select' but what do I enter in *Message Text field as I couldn't find any dynamic content to enter?

[Expiscornovus]

Hi @Anonymous,

You can use an expression instead.

Try the following expression:

first(body('Select'))

[Anonymous]

Hi @Expiscornovus thanks but unfortunately the Slack action you suggested came up with an error i.e. 

first(body('Select'))

[Expiscornovus]

Hi @Anonymous,

The error suggests that it might not be able to find your specific slack Channel? I also notice an X next to the pa-flow-test2.

Can you reselect your channel from the dropdown menu?

[Anonymous]

@Expiscornovus I don't believe it's the channel as I've executed this flow successfully in the past as per screenshot. 
I entered the channel name as a 'custom value' as it didn't show up in the drop down menu but nonetheless, the flow has executed successfully in the past.

[Expiscornovus]

Hi @Anonymous,

Thanks for checking. Can you a test text instead of the expression, for example 'Hello World from Power Automate'  and test run it right now? Does it allow you to post that random text in the pa-flow-test2 channel?

Just to rule out that the issue is related to a Slack Channel or connection error.

[Anonymous]

@Expiscornovus yes that executed successfully

[Anonymous]

@Expiscornovus do you have an update on this issue since my last message? Appreciate any help please. 
@takolota - you able to assist please?

[takolota]

@Anonymous 

Can you show the outputs of the Select action / inputs of the Slack action in the flow run?

[Anonymous]

@takolota thank you for your prompt response. Attached output as requested. Let me know if you need more info.

{
    "statusCode": 404,
    "headers": {
        "Transfer-Encoding": "chunked",
        "access-control-allow-origin": "*",
        "referrer-policy": "no-referrer",
        "x-slack-backend": "r",
        "strict-transport-security": "max-age=31536000; includeSubDomains; preload",
        "access-control-allow-headers": "slack-route,x-slack-version-ts,x-b3-traceid,x-b3-spanid,x-b3-parentspanid,x-b3-sampled,x-b3-flags",
        "access-control-expose-headers": "x-slack-req-id,retry-after",
        "x-oauth-scopes": "identify,channels:read,files:read,channels:write,chat:write:user,chat:write:bot,groups:write,dnd:write",
        "x-accepted-oauth-scopes": "chat:write:bot",
        "pragma": "no-cache",
        "x-xss-protection": "0",
        "x-content-type-options": "nosniff",
        "x-slack-req-id": "c19b22c0ec9405e5c0224745d95b7a20",
        "vary": "Accept-Encoding",
        "x-envoy-upstream-service-time": "336",
        "x-backend": "main_normal main_bedrock_normal_with_overflow main_canary_with_overflow main_bedrock_canary_with_overflow main_control_with_overflow main_bedrock_control_with_overflow",
        "x-server": "slack-www-hhvm-main-iad-hwty",
        "x-slack-shared-secret-outcome": "no-match",
        "x-edge-backend": "envoy-www",
        "x-slack-edge-shared-secret-outcome": "no-match",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "true",
        "Cache-Control": "no-store, must-revalidate, no-cache, private",
        "Date": "Tue, 12 Jul 2022 08:17:21 GMT",
        "Via": "envoy-www-iad-0gw0,envoy-edge-syd-ei4e",
        "X-Powered-By": "HHVM/4.153.1",
        "Content-Type": "application/json",
        "Expires": "Mon, 26 Jul 1997 05:00:00 GMT",
        "Content-Length": "111"
    },
    "body": {
        "ok": false,
        "error": "no_text",
        "warning": "missing_charset",
        "response_metadata": {
            "warnings": [
                "missing_charset"
            ]
        }
    }
}

[takolota]

@Anonymous 

I see that lists a “no text” error.

Please share a picture of the Select action outputs in the run.

I suspect there may be an issue with the inputs to that action. Like if the From array data input isn’t formatted correctly as JSON, then the item() expression isn’t going to return anything.

[Anonymous]

@takolota Here you go

[takolota]

Yes, it’s null. And it looks like the input on the Select is a single string, so it makes sense it isn’t pulling anything.

It’s not letting me load the picture to full screen though, please share the Select inputs the same way you shared the Slack action details in the code view.

[Anonymous]

@takolota here you go

{
    "from": [
        {
            "[update]": "the onsite revenue for June22-Wk4 is $ and comparative is $8872729.77686175 and variance is -1%"
        }
    ]
}

[takolota]

Is…

the onsite revenue for June22-Wk4 is $ and comparative is $8872729.77686175 and variance is -1%

Something you want to send to the Slack action?

In that case the expression in the Select needs to be  

item()?['[Update]']

Otherwise, you need to figure out why that PBI dynamic content doesn’t have the data you want.

[Anonymous]

@takolota correct that is what I want to send to the Slack action. However, after making the change you suggested there is still an error on the Slack action

{
    "statusCode": 404,
    "headers": {
        "Transfer-Encoding": "chunked",
        "access-control-allow-origin": "*",
        "referrer-policy": "no-referrer",
        "x-slack-backend": "r",
        "strict-transport-security": "max-age=31536000; includeSubDomains; preload",
        "access-control-allow-headers": "slack-route,x-slack-version-ts,x-b3-traceid,x-b3-spanid,x-b3-parentspanid,x-b3-sampled,x-b3-flags",
        "access-control-expose-headers": "x-slack-req-id,retry-after",
        "x-oauth-scopes": "identify,channels:read,files:read,channels:write,chat:write:user,chat:write:bot,groups:write,dnd:write",
        "x-accepted-oauth-scopes": "chat:write:bot",
        "pragma": "no-cache",
        "x-xss-protection": "0",
        "x-content-type-options": "nosniff",
        "x-slack-req-id": "8b34e848c93c645ebae5dbea6ed8131e",
        "vary": "Accept-Encoding",
        "x-envoy-upstream-service-time": "241",
        "x-backend": "main_normal main_bedrock_normal_with_overflow main_canary_with_overflow main_bedrock_canary_with_overflow main_control_with_overflow main_bedrock_control_with_overflow",
        "x-server": "slack-www-hhvm-main-iad-xz39",
        "x-slack-shared-secret-outcome": "no-match",
        "x-edge-backend": "envoy-www",
        "x-slack-edge-shared-secret-outcome": "no-match",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "true",
        "Cache-Control": "no-store, must-revalidate, no-cache, private",
        "Date": "Mon, 18 Jul 2022 02:35:19 GMT",
        "Via": "envoy-www-iad-ie4e,envoy-edge-syd-mp0k",
        "X-Powered-By": "HHVM/4.153.1",
        "Content-Type": "application/json",
        "Expires": "Mon, 26 Jul 1997 05:00:00 GMT",
        "Content-Length": "111"
    },
    "body": {
        "ok": false,
        "error": "no_text",
        "warning": "missing_charset",
        "response_metadata": {
            "warnings": [
                "missing_charset"
            ]
        }
    }
}

[takolota · Accepted solution]

@Anonymous 

Thanks for the clearer picture.

Sorry, I capitalized the U, it looks like it should be lowercase u.

[Anonymous]

@takolota that worked perfectly. Thank you, much appreciated.

On a side note, is it possible to include a visual (e.g. chart/table) that represents the text output in the Slack action? Here's an example sample screenshot of another Slack channel but the person who posted it does it manually on a regular basis. Let me know if not possible or this question requires a new post in the forum.