web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Copilot Studio Is it possible to pass...

Copilot Studio

Answered

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

(0) Share

Report

Report

Posted on by CU16021406-1

1,058

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?

Gr. P

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,768 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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).

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'])

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

Was this reply helpful? Yes No

Join the conversation