cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sipark09
Regular Visitor

Retrieving per variable content from sharepoint

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.

sipark09_0-1656339143962.png

 

3 REPLIES 3
Jondoesflow
Advocate II
Advocate II

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.

 

Jondoesflow_0-1656341120501.png

 

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

 

Thanks !

Hello,

 

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

sipark09_0-1656342130500.png

 

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!

 

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. 

sipark09_0-1656344904242.png

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,889)