Showing results for 
Search instead for 
Did you mean: 
New Member

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


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.



Super User
Super User

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):


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.

Hi @

Super User
Super User

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



Hi, @




Super User
Super User

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.



Helpful resources

PVA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Top Kudoed Authors
Users online (2,522)