I am trying to use 'Get Item' after 'Manually triggering a flow' and getting error.

[Sushi_Rajeeva]

Hello,

I want to manually trigger a flow which fetches the data from a website linked. When I try to do that I am getting an error "Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type". 

First, I am trying to manually trigger a flow. I chose text, as my input is alphanumeric. I used compose with the "int(triggerBody()['text'])" as I was getting some error to convert 'string' to 'int' by the Get item. I am not able to figure out what is causing the error. I would really appreciate any help regarding this error. 

Thanks.

[Expiscornovus]

Hi @Sushi_Rajeeva,

I see you are trying to convert a text input into a number. However, the manually trigger a flow action also supports number import.

My suggestion would be to add a new input field of type number and use that in your get item action.

Below is an example of that approach.

1. Add a new input type. Call it ID.

2. In the Get Item action use that new ID input field in your Id field.

[Sushi_Rajeeva]

Hello @Expiscornovus,

Thanks for replying to my post.

My input is alphanumeric(For ex: SKTNSK1C005). I thought text would be more suitable as it takes alphanumeric inputs whereas number takes only number as its input.

I tried the solution given by you and it does not work for my input.

Could you please tell me if you have any other solution in this scenario?

[Expiscornovus]

Hi @Sushi_Rajeeva,

Apologies, I missed that alphanumeric requirement. In that setup this type of input would not work, you are correct. 

However, a Get Item action assumes you know the id value. That value is a number. So, for this scenario that would not work. 

Can you share where you are storing this alphanumeric value in your SharePoint list? 

We probably need to use a Get Items action instead and use filter query with a different column to retrieve the item you are looking for.

[Shujaath_Khan]

Hi @Sushi_Rajeeva 

If you're considering alphanumeric as the input you should not be converting to int, probably you can remove compose and directly use the input received.

And Sharepoint Item IDs are always numeric, please consider having input as the number as suggested by @Expiscornovus 

Thanks