Retrieving per variable content from sharepoint

[sipark09]

Hello,

I'm building a chatbot for my team and clients.

Currently I am only able to manual retrieve input 'id' status values. 

I'm hoping to be able to retrieve status value for any url that the user types. In other words, I would like the 'Id' field to take in a value as a variable and be able to get the status value of it. 

Is there a way to achieve this.

[Jondoesflow]

Hi @sipark09 

Yes this is possible.

I have replicated the flow below, the URL gets passed into the trigger step, which will mimic your first PVA step.

I am then doing a split and selecting Index position 1 from the URL inputted

that code is 

split(triggerBody()['text'],'ID=')[1]

You can then use that output from the compose step inside the ID field.

If this works for you, please thumbs up the comment and accept it as a solution.

Thanks !

[sipark09]

Hello,

I'm getting an error message for the compose part. Please see the following image for the detail. 

The Error Detail : Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'split(triggerBody()['text'],'ID=')[1]' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.

Please let me know if this is resolvable. 

Thanks!

[sipark09]

More importantly,

when I resolve the array range problem, I receive this error. 

The ID is a unique identifying code that is an integer that is randomly assigned to the URL within the SharePoint Lists. 

Error Detail: The 'inputs.parameters' of workflow operation 'Get_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'id' is required to be of type 'Integer/int64'. The runtime value '"https://intellishare/sites/SP"' to be converted doesn't have the expected format 'Integer/int64'.

Please let me know if this is resolvable. 

Thanks!