Is it posible to compare username with name in a excel table?

(0) Share

Report

Posted on by OscarMir

Hello,

I'm trying to find an option to compare username to name in an excel cell table.

The idea is to send a schedule based on the username written in excel.

Thanks!!

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @OscarMir,

I would say it would be possible if you would use either the bot.UserId or bot.UserDisplayname variables in a Power Automate action (this requires enabling authentication on your bot):

https://powerusers.microsoft.com/t5/Power-Virtual-Agents-Community/Getting-User-Details-To-Use-In-Power-Virtual-Agents-In-Teams/ba-p/744934

In the Power Automate flow you could use a list rows present in a table action and a filter to retrieve the correct rows for the user.

In what format is the username written down in the Excel table? Can you share a screenshot of the Excel table. Obfuscate the data if needed.

Was this reply helpful? Yes No
OscarMir 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus,
The name is the user's mail. I change now and I did a table for each user, so I need to equal the name with the table's name.

Was this reply helpful? Yes No
Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @OscarMir,

Just double checking. Do you mean table name a worksheet name? I have tried adding an e-mail address to my table name and it doesn't allow me because of special characters 😁

1. Tried adding dennis@contoso.com as a value in Table name and got the error below.

2. So, in the example were would the e-mail address of the user be. At the place were currently Table1 is or Sheet1?

Was this reply helpful? Yes No
OscarMir 4 on at

Like (0)

Report
Copy link

Link copied!

Hi, @Expiscornovus. Sorry if I have not explained it well.
The mail I have put in the name of the sheet. In the table it gives error as you indicate.

Cheers,

Was this reply helpful? Yes No
Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @OscarMir,

I would actually suggest to use the Table. That is simply easier to work with from a Power Automate point of view. In your example I would use the table name oscar.miro, without the @ and the domain name.

With this approach you could use a split function to retrieve the e-mail and match on the first part of the e-mail, which is oscar.miro.

Below is an example of that approach.

1. The flow setup in Power Automate.

In the table field of the List rows present in a table action I am using this expression:

split(outputs('Get_user')?['body/mail'], '@')[0]

2. The topic setup in the Power Virtual agent. Over here the bot.UserId is mapped to the UserId field from the flow. I use this to retrieve the users e-mail address to be able to collect the correct table from the Excel file.

Was this reply helpful? Yes No