Skip to main content

Notifications

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

Is it possible to pass the data of more columns of a Sharepoint list to the Virtual Agent connector?

(0) ShareShare
ReportReport
Posted on by 1,017

Dear Experts,

 

I use a Power Virtual Agents connector to search in a Sharepoint list column Title for a string that has been specified by the user in Virtual Agent. When the string has been found it has to pass the data of the column Description of that row back to the Virtual Agent connector. Is it possible to pass the data of more columns than just the column Description to the Virtual Agent connector?

 

VirtualAgent01.JPGVirtualAgent02.JPG

Gr. P

Categories:
  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,081 on at
    Re: Is it possible to pass the data of more columns of a Sharepoint list to the Virtual Agent connector?

    Hi @PeKi72,

     

    You could add for example an expression to retrieve two columns in the MijnServer output variable.

     

    Below is an example with a second column named Role.

     

    1. This is the list with the Role column (internal field name is Role as well).

     

    serverlijst.png

     

    2. The is the setup of the flow. In the last action I used a concat function which references two columns of the first item it found in the Get Items action.

    concat(outputs('Get_items')?['body/value'][0]['description'], ' en ', outputs('Get_items')?['body/value'][0]['role'])

     

    expression_concat.png

     

    3. In a test the output would look like below.

    example_role.png

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,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics