Answered

Canvas App - Send Drop Down List Selection to Sharepoint

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 155,927 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
tbush33 29 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
WarrenBelz 155,927 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@tbush33 ,
What type of control is EmployeeInput?

Was this reply helpful? Yes No
tbush33 29 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz It is a Drop Down.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,927 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
tbush33 29 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No