cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OscarMir
New Member

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

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

5 REPLIES 5
Expiscornovus
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):

https://powerusers.microsoft.com/t5/Power-Virtual-Agents-Community/Getting-User-Details-To-Use-In-Po...

 

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 @

Expiscornovus
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 dennis@contoso.com as a value in Table name and got the error below.

 

tablename_error.png

 

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

 

tablename.png

Hi, @

2021-10-13_15h03_25.png

 

Cheers,

Expiscornovus
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]

 

 

flowsetup_getexcel.png

 

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.

 

getmyexcel_pva.png

Helpful resources

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