Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Answered

Extracting a varying number of data from Flow

(0) ShareShare
ReportReport
Posted on by

Hello,

I used HTTP with the GET method in a flow. More than one object structure returned in Body as a result of HTTP Request.
I want to reflect this object structure to the bot as separate messages as in the attached picture.
By the way, the object structures returned in Body always vary, so I could not use Return Value Power Virtual Agents.

 

Can you give me some idea of how I can do it?
Thank you from now.

Bot.PNG

Categories:
  • Verified answer
    Jcook Profile Picture
    Jcook 7,770 on at
    Re: Extracting a varying number of data from Flow

    Hi @Anonymous 

    I would just pass both back to PVA since we cannot send back arrays.

     

    I do like your use case though, I would submit that idea and post the link back here to get some votes. 

  • Re: Extracting a varying number of data from Flow

    Hi @Jcook ,

     

    I have to use the project name in another API query after the user sees the project name and makes the selection. Therefore I was thinking of separating.

  • Jcook Profile Picture
    Jcook 7,770 on at
    Re: Extracting a varying number of data from Flow

    Hi @Anonymous 

     

    Yea, we cant pass Array Values to PVA yet.

     

    What is the purpose of having multiple outputs in separate messages?

     

  • Re: Extracting a varying number of data from Flow

    Or if you have an alternative route suggestion I'd like to discuss it as well

  • Re: Extracting a varying number of data from Flow

    Hi @Jcook ,

     

    Of course.

    In my script, I pull data from a web service using API for each user. When the HTTP query runs I get a Body similar to the following for a user.

     

    "memberships": [
    {
    "id": 132803,
    "project": {
    "id": 123,
    "name": "dusıjdznmöx"
    },
    },
    {
    "id": 367428,
    "project": {
    "id": 987,
    "name": "usaıjskdnsdfn"
    },
    }

     

    Here, I intend to sort the id and project id information in the objects in this Body in different message boxes. (The number of object structures in the body varies according to the user.)

    In short, when the bot runs, I want it to appear in the format found in the picture before.

     

    Thank you

  • Jcook Profile Picture
    Jcook 7,770 on at
    Re: Extracting a varying number of data from Flow

    Hello @Anonymous ,

     

    unfortunately this does not seem possible yet.

     

    Could you explain the use case in detail?

     

    I would also suggest you create an idea for this feature 😊

    https://aka.ms/pva/community/ideas

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics