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