Verifying values from an Excel file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to create a chat bot that will check if values are correct in comparison to the excel file, that was i can verify who has permissions to use the chatbot .

Example : in my Excel, it is written

TOKEN 1	TOKEN 2	TOKEN 3	company	E-MAIL
12345	67890	147852	CTT	CTT@gmail.com

The bot will ask for the company and email and then it will either as for token 1, 2 or 3.

How can I do that ?

Thanks,

Bea

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,718 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

You could ask three questions to request input for the company, e-mail and token. After that you can use that input and check it in a flow action.

However, I don't know if I would use an Excel for this. As far as I know, the list rows present in table action does not support multiple filters. However, you could workaround that by using a couple of Filter Array actions

Below is an example

This is a very basic setup. You might want to include a couple of condition actions to check the results of each filter action, for some error handling.

1. Topic example

2. Flow which uses the input to check the Excel file

Expression used in the second Filter Array action

@or(or(equals(item()['Token1'], triggerBody()['text_2']), equals(item()['Token2'], triggerBody()['text_2'])), equals(item()['Token3'], triggerBody()['text_2']))

Expression used in the Result variable

if(equals(length(body('Filter_array_-_Token')), 0), 'No match found', 'Match Found')

Was this reply helpful? Yes No