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!!
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.
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,
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?
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.
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.