Canvas App - Send Drop Down List Selection to Sharepoint

[tbush33]

Hello,

I am trying to create a submission log for managers to submit employee discussions to a Sharepoint List. I have a drop down that is connected to a separate Sharepoint that pulls the employee's names and everything else is a manual input. I created a flow with each input given the dynamic content of "Ask in Powerapps". In the formula bar for OnSelect, I have the following: 

'PowerApp->Createitem_2'.Run(IssueDateInput.SelectedDate,EmployeeInput.SelectedText,WitnessInput.Text,ReasonInput.Text,DiscussionInput.Text)

The problem is that it gives me an "Invalid Argument Error: A Text Value Was Expected" for the input "EmployeeInput.SelectedText". I am stuck here and do not know how to get around it. Any ideas?

Thanks,
Travis

[WarrenBelz]

Hi @tbush33 ,

Try

EmployeeInput.Text

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[tbush33]

Hi @WarrenBelz , thank you for your response. When I attempt to just put the .text, it says that the name is not valid and that the identifier is not recognized. Any ideas?

[WarrenBelz]

@tbush33 ,

What type of control is EmployeeInput?

[tbush33]

@WarrenBelz It is a Drop Down.

[WarrenBelz · Accepted solution]

@tbush33 ,

You need

EmployeeInput.Selected.xxxx

where xxxx depends on the Items property of EmployeeInput
When you type EmployeeInput.Selected. (note second dot), valid values will come up underneath. For some guidance of what they mean: -

• If your Items are Choices(ListName.EmployeeInput) - a Choices or Lookup field), the reference will be EmployeeInput.Selected.Value
• If they are Distinct( . . .  .), it will be EmployeeInput.Selected.Result
• The other option is when they are based on a field value in a list (other than Distinct), then it will be EmployeeInput.Selected.FieldName (actual field name)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[tbush33]

@WarrenBelz I feel like a fool. The help bar was even trying to guide me down that path...I was able to get it to work following your instructions. Thank you so much!!