Skip to main content

Notifications

Calling Actions from Copilot Studio
Answered

Extracting a varying number of data from Flow

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 740 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 740 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 740 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

     

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,990

#3
Expiscornovus Profile Picture

Expiscornovus 1,700

Featured topics