I am trying to AutoFill boxes and auto send an email to the manager / Team Lead upon form submission.
I am getting errors all the time...
Currently I am trying to type: Office365Users.Manager(DataCardValue3.SelectedItems.Text).DisplayName
The entire thing gets an error. The first says that "Manager has an invalid function. ".Text" is a wrong Identifier. and "DisplayName" Expected Record Value.
I can't find other answers I have looked....
DataCardValue3 is the name of the First Dropdown box in my form which is where a user will input the Employee name that I need the manager, team lead and assistant manager of. The Card name is Employee_DataCard1.
Any help is appreciated.
Solved! Go to Solution.
Hi @Agerde ,
Hi @Agerde ,
Can you please give a shot to
Am I supposed to change DefaultSelectedItems: to something different? Sorry, I am newer to PowerShell, but now the rest of it is saying it is ok, but the first portion is saying " Name isn't valid. This identifier isn't recognized"
What is the datasoure? SP list?
What is the column type of DataCardValue3,Person or other?
Could you please reference this
Hope this could be helpful.
Yes. So I have a ComboBox ( which I am not sure is the correct choice) and I am filling comboboxes with the Team Lead, Assistant Manager and Manager of the agent from the Employee Combobox. I had them all set as combo boxes since the user was manually entering in the information at first, but I am trying to get it to AutoFill. If I need to change the type of box it is to get this to work I can.
They are people picker fields, where you start typing in any and they are linked to our office365 employee list to find an employee.
I have tried entering in a formula into the Default and defaultselecteditems boxes and get errors either way...
If I follow your link the only portion i get an error on in the Default field for the formula is the ").DisplayName"
The error I get says Expected Table Value. I am noticing in the other persons screenshots his autofilling field is a text box and not a combobox, do I need to change my manager boxes to text boxes instead of combo to get this to work correctly?
Yes,you are right.
The link of the case I provide, the user uses one textinput or label to show the Manager Name,
So he uses the formula expression as
And what is the column type of your manager column and teamlead column?
However,if you use one control as ComboBox or other table type controls to accept the value,please try to
change the formula expression which will output the table value,try to sub .DisplayName to test.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand