Error on variable when using For a Selected Item as the trigger (Power Automate)

chris.cundy · February 9, 2022, 9:41am

Hello,

Jumping into it, my workflow works fine when I have When an item is created as the trigger - where I am using the signature control being put into a variable in order for the image to be placed into a Word document.

However (as needs have changed, we are now been asked to have a button in the SharePoint list next to the list item that had been created from Plumsail Forms) when I change the trigger to For a selected item , the workflow is now failing on the "Compose Sig1" variable - this is the same as above:

replace(triggerOutputs()?['body/SF15_SignedCus1'],'"','')

What do I need to change in terms of formatting for this variable to work?

Thanks.

Nikita_Kurguzov · February 9, 2022, 4:06pm

Dear @chris.cundy,
Normally, I would think that the same approach should work, but can you check what values are retrieved in Get item method? Maybe the field is coming up empty? Send us a screenshot of Get item content from the debug mode here:

chris.cundy · February 9, 2022, 4:32pm

HI @Nikita_Kurguzov

This is the output of a "Compose" action after the "Get item" action:

"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAACWCAYAAAAonXpvAAAAAXNSR0IArs4c6QAADmZJREFUeF7t3UvIdVUZB/B/BEUDywgz7So06UJqCjXoOioC025Go9QiUQuLiBp0kyYVUgYp3UwjiLCLZgWOMqmwgaJBl0FQoVFmkFEUQUGxYp9YHfze7/3Ou9Y+5+z12yP93vddaz2/58D/nLP3XvsROfZxa5Lzqh+/NsnNB/z+HD+6N8mZSa5K8uE5JjQHAQIECBDYB4FHHLDIEt4XVD9/X5KPbbmo7yd5qUDfchdMT4AAAQI7J3BQoJ+V5J5qxT9K8qItV3BLkvMF+pa7YHoCBAgQ2DmBgwK9LPbfays+3u/3LvCaJFcmuSPJy3pPZnwCBAgQILAvAscL6M8meVtVzLlJ7t5iceW8+YcE+hY7YGoCBAgQ2EmB4wV6CfMS6qtj2xejXZTkhiTl4rizd1LUoggQIECAwBYEjhfoz0zyy2pdDyQ5bQvrXE1Zvma/ffqf4619i8s0NQECBAgQmFfgMKF4W5JXVMt6e5Jr513m/2arL9Q7zNq3tEzTEiBAgACBeQUOE4rXJbmsWtalST437zL/b7bVhXqPT/LnLa7D1AQIECBAYGcEDhPopyR5sFpxuRf85VusYBXo5Rx6OZfuIECAAAECwwscJtALUjlvXd8mdti/6wEs0HuoGpMAAQIE9lrgsMG8frX7Nm9fWwV6+ZagfFvgIECAAAECwwscNtDrq8sL2jZvXxPow79sARAgQIDAusBhA7383V1JzpkG+HaSV2+JU6BvCd60BAgQILC7AicS6DcleUNVSvnUXrZgnftYBfrFSW6ce3LzESBAgACBXRQ4kUB/T5KPV0VcnaT829zHKtC3+bX/3DWbjwABAgQIHChwIoH+2CT3JXncNGJ5Etvzt+D7myRP3/J5/C2UbUoCBAgQIHBsgRMJ9DLK+tfuT0zyx5mBPRN9ZnDTESBAgMDuC5xooK8ejrKq7IokZSe5OY9VoH8pSVmPgwABAgQIDC9wooH+jCS/rtRuSfKamRVXge6Z6DPDm44AAQIEdlfgRAO9VFIeX1p/Mj49ye9nLFGgz4htKgIECBDYD4FNAv1dST5RlVfCvXz9PddxTZIrp1vm6u1o55rfPAQIECBAYOcENgn0k5OU56I/eqpm7nPZH07yIYG+c68lCyJAgACBLQpsEuhlueXc+fnTusttZGfMWINAnxHbVAQIECCwHwKbBvr61e4l0Euwz3GsAn3uNxJz1GYOAgQIECCwkcCmgV6+dn+omnHObVh9Qt+o1f6IAAECBJYssGmgF5N7k5w54cx5Hn0V6D9JctaSm6M2AgQIECBwWIGjBPrqavMy15xffwv0w3bX7xEgQIDAMAJHCfT1Z6TPdR79o0nem+TBJKcO0ymFEiBAgACBAwSOEujr59HLjnHl6vfex1eSvCnJP5M8qvdkxidAgAABAvsgcJRAL/XdmeSFU6HfSPL6GYpefeVepjrq+mdYrikIECBAgEB/gaMG4neTvGpa5s+SPLf/kv+77WzZfrYcc33NP0NZpiBAgAABApsLHDXQ353k6mr6o453mErqc/cvT1L2dncQIECAAIGhBY4awOckuasSnCNg60Cf67z90C8SxRMgQIDA7gscNdBLhf+uyrwqSTnH3fOoA32O+XrWYmwCBAgQINBEoEWg/zTJc6bVfC3JhU1WduxBBHpnYMMTIECAwP4JtAj0m5NcMJX+uSSXdmaoA33OHeo6l2V4AgQIECCwuUCLQK9vIysraTHmQRWV7V7vmX7hjiSeib55//0lAQIECCxEoEX4viXJFyaPfyU5PckfO/rUG9oI9I7QhiZAgACB/RFoEehvSHJTVfIcV7qvLsQT6PvzWrNSAgQIEOgo0CLQy/LmvtJ9Nd+cD4Xp2AZDEyBAgACBown0CPSy0Uv5lN7zqN9AtKqh53qNTYAAAQIEugq0CsPbq4vT5tgCVqB3fVkYnAABAgT2TaBVoF+b5PKq+FbjHsuzfNX+9OmHvefat55aLwECBAgMKNAqDN+Z5JOV37lJ7u7oWb7Wf+k0/uOT/LnjXIYmQIAAAQI7L9Aq0OvNXkrR5XnlX+1YfR3oc1xV37EUQxMgQIAAgaMLtAr005L8rlrOdUmuOPryjjnCLUnOn34q0DtCG5oAAQIE9kOgVaCXav+R5NFT2V9PUu5P73XUu9MdJtDLU9nKm45fJbmt16KMS4AAAQIEtiXQMtDrr8F7b/hyTZIrJ7RPJSnn8I91PCbJ36cffjPJ67aFbV4CBAgQINBLoGWg15+ay0Vq5WK1Xsf1SS6ZBv9ikrL97EHH6ja3zyS5rNeijEuAAAECBLYl0DLQL0pyQ1XIGUnK7WU9jvrNw7uSlE/sBx0nJXljted8jzUZkwABAgQIbE2gZaCvX+l+mHPbmxZeB/rFSW7cdCB/R4AAAQIEliDQMtCLR72D22E+OW9qWJ+v/0GSl2w6kL8jQIAAAQJLEGgd6PUObse7WO0ofr9P8qRqgPLI1vJvDgIECBAgMKRA60Cv7w/vdaV7eVTr+i1xT0ty/5AdVDQBAgQIEEjSOtB7X+n+cGHuEapeygQIECAwvEDrQF+/MK7lPuv1E93qxl2VpLyRcBAgQIAAgWEFWgf6WUnuqTTPS/KdRroPJTl5Gqvs9vbK6b97XnzXaOmGIUCAAAECfQVaB3pZ7b+SPHJa9seSvK9RCXcmeUGSvyV5b5LyyNZyfCTJBxvNYRgCBAgQILCXAj0C/YEkp04ava50L5/KPzHNcXWS9+ylvkUTIECAAIFGAj0CfY493evnr/d609CI2DAECBAgQKC/QI9A732le1Gp5/hWkgv6U5mBAAECBAjsrkCPQC/henNVco893etA73W/++52zcoIECBAgMCaQI9AX791rTyLvGw40/KY41uAlus1FgECBAgQ6CrQI9DLgus93XvcJ14HepmvVx1d8Q1OgAABAgRaCfQKwnpP9x7nuAV6q1eAcQgQIEBgEQK9Ar2+0r3H1qzrgX52knsX0RFFECBAgACBDQR6BXrvT9Dr4/d89voGrP6EAAECBAjMK9Ar0C9KckNVSuvAFejzvk7MRoAAAQI7LtAr0NevdL84yY0NLQR6Q0xDESBAgMD+C/QK9CJTX+neeje39UDvcWvc/ndXBQQIECAwjEDPQC8XqZ05Sbbe/GU90D1xbZiXrEIJECBA4OEEegZ6+Yr9zdOkf03y2IYtqPdyL8P2uNe94XINRYAAAQIE+gr0DPTyWNP3V8t/UpI/NCpn/Ry9QG8EaxgCBAgQ2E+BnoH+1iSfr1guTPK1Rkzrgf7pJO9oNLZhCBAgQIDA3gn0DPT10L0uyRWNhMptcN+rxro+SXkD4SBAgAABAkMK9Az0Alpf6V52jytB3Oq4L8lTp8FcFNdK1TgECBAgsJcCvQP9x0leUMm0nO+uJOdMY5+b5O697IBFEyBAgACBBgItA/bhllOei16ej746Wu4Y92CSU6aBW47bgNUQBAgQIEBgXoHegb5+v3i5la3sGtfiuD1JOU9fDoHeQtQYBAgQILC3Ar0D/XlJflLpPJDktEZatyY5bxrLV+6NUA1DgAABAvsp0DvQ1690b/lp+rdJnuwT+n6+8KyaAAECBNoK9A70str6Svfy/602gbk/yVMmjhcn+WFbGqMRIECAAIH9EdhGoLe6fe2SJB9I8uUkH9wfcislQIAAAQLtBeYI9PritVUFc8zbXsuIBAgQIEBgRwXmCNark7x7rX5Xpe/oC8KyCBAgQGA/BeYI9Gcl+fkaz7OT/GI/yayaAAECBAjsnsAcgV6q/kuSk6ryn5DkT7vHYUUECBAgQGA/BeYK9GuTXF4RzTXvfnbFqgkQIECAwAkKzBWsz0jy62ltZc/1shGMgwABAgQIEGgkMFegl+X+rtolbs55G1EZhgABAgQI7K7AnMH6UJKTJwqPO93d14SVESBAgMAeCswZ6HdOj1L929oFcnvIZskECBAgQGC3BOYM9N2q3GoIECBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggQE+oKaqRQCBAgQGFdAoI/be5UTIECAwIIEBPqCmqkUAgQIEBhXQKCP23uVEyBAgMCCBAT6gpqpFAIECBAYV0Cgj9t7lRMgQIDAggT+A7H6W6Y9UnkuAAAAAElFTkSuQmCC"

Nikita_Kurguzov · February 9, 2022, 6:36pm

Dear @chris.cundy,
A screenshot would be better, as I want to know where exactly it is inside the flow. This looks fine to me.

Did you follow all the steps to add the replace() function, or did you just copy the text from the other flow? It might be needed to follow the steps, where you select body, etc.

chris.cundy · February 9, 2022, 7:47pm

Hi @Nikita_Kurguzov

Screenshot as requested:

This previously worked on the "When an item is created" trigger - but obviously not using this now.

Nikita_Kurguzov · February 9, 2022, 7:59pm

Dear @chris.cundy,
I actually need a screenshot from the failed flow run, you need to check that the signature is there and what format it is, like this:

I did successfully run the flow with this configuration, and it created a file with signature in it:

chris.cundy · February 9, 2022, 8:12pm

@Nikita_Kurguzov here you go:

This is the output of the Get item action:

Nikita_Kurguzov · February 9, 2022, 9:42pm

Dear @chris.cundy,
Okay, once again, everything looks fine. Try to peek code in the Compose Sig1 step:

And copy the code from there:

chris.cundy · February 9, 2022, 10:10pm

@Nikita_Kurguzov

{

"inputs": "@replace(triggerOutputs()?['body/SF15_SignedCus1'],'\"','')",

"description": "replace(triggerOutputs()?['body/SF15_SignedCus1'],'\"','')",

"metadata": {

    "operationMetadataId": "bf688392-73ef-4f9f-a107-822b8f1bfe4c"

}

}

Nikita_Kurguzov · February 9, 2022, 10:20pm

Dear @chris.cundy,
How did you get the triggerOutputs()? Did you copy it from the last flow?

I followed all the steps of adding the item and I've got outputs('Get_item') instead:

{
    "inputs": "@replace(outputs('Get_item')?['body/Signature'],'\"','')",
    "metadata": {
        "operationMetadataId": "03c91ff5-f38b-4f21-832e-5ee0f932e0fe"
    }
}

It seems like you might be trying to get the information from the triggerOutput(), but it has no info in it - the info is from the Get item step instead.

Just follow all the steps and you'll get the correct code:

chris.cundy · February 9, 2022, 10:43pm

@Nikita_Kurguzov

thank you so much! This worked - My flow has run successfully!

ты спас мой бекон!