Patch with drop down not working

(0) Share

Report

Posted on by akbarmahfuzalam

709

PowerHi Guys,

I am new to Powerapps and I am trying to build an app for mobile users with their Time in and Time out with Cascading drop-down list which is been taken from SharePoint List.

I am able to Build an app with all the combination and permutation. But when it come to send the data from Powerapp form to SP . Its not happing.

I am able to send data the one which is in Text format but failing big time with drop-down and date.

Sample Code: Patch(ATM,Defaults(ATM),{Title:TextInput1_1.Text,Comment:Comments.Text,Category:Dropdown1.Selected.Value})

The type of argument 'Category does not match the expected Type' Record' Found type Text

The function Patch has some invalid arguments.

In Sharepoint too I have defined Category as Choice field.

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@akbarmahfuzalam
Just use .Selected, ie
Patch(ATM,Defaults(ATM), {Title:TextInput1_1.Text, Comment:Comments.Text, Category:Dropdown1.Selected})
Then for date you use .SelectedDate.

The error message is telling you why. A Choice field in SP is not just a single value it is a table of results so the Patch expects a full RECORD ie ALL the columns associated with the Category that is selected. This is why .Selected is used because it returns the entire record.

A simple way to see this in PowerApps is to create a collection and look at what makes a Choice column. You can do this via this code on a Button:
ClearCollect( colChoice, Choices(ATM.Category))
Then have a look at the table produced: View --> Collections --> colChoice

Hope this helps.

Was this reply helpful? Yes No
MarvinBangert 1,924 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @akbarmahfuzalam
Welcome to the community!

Based on your SharePoint Screenshot, your column "Category" is a Text field. Try this:
Patch(List;{Title:Dropdown1.SelectedText.Value;Choice:Dropdown1.SelectedText})
If you want to update a text field with the selected dropdown item, use "Dropdown1.SelectedText.value".
If you want to update a choice field with the selected dropdown item, just use "Dropdown1.SelectedText"

Hope this helps you!

Regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, Elman for your quick response, But it seems to be again not working. If i remove the Dropdown section it work but the moment i added the dropdown it doest work for me.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@akbarmahfuzalam
Could you please supply the Items property of your Dropdown

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Marvin, Thanks for your Quick Response.
I am not able to figure out what need to done or what changes it required on my formula. When I submit the data. Its not storing in in the SP.

and I am getting an error on the button as screenshot is attached for your REF

Was this reply helpful? Yes No

akbarmahfuzalam

709 on at

Like (0)

Report

Copy link

Link copied!

Language	Process	Input	Category	Sub Category
Arabic	Abc	WFH- Arrival	Work from home	Work from home
	BDsh	WFH- Exit	Work from home
	gkhk		Idle
	shsh		Off
			Planned Leave
			Resigned
			Self-Quarantine
			Unplanned Leave

Was this reply helpful? Yes No

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@akbarmahfuzalam
Thanks for that but I don't need the actual items but the code that is in the Items property of your Dropdown inside PowerApps. Also, are you using a Dropdown or a ComboBox?

Cheers

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

I am using Drop Down and the code goes like this..

Patch(ATM,Defaults(ATM),
{Title:TextInput1_1.Text, Comment:Comments.Text, Category:Dropdown1.SelectedText, SubCategory:Dropdown2.SelectedText,Internetfeasibility:Dropdown5.SelectedText,Language:Dropdown6.SelectedText,Process:Dropdown7.SelectedText})

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@akbarmahfuzalam
Thanks, but that's the code on your 'Record Data' button, I get that. What I want to know is the code for the Items property of your Dropdown. To get this, inside PowerApps select your Dropdown control then in the dropdown Menu on the left hand side scroll to the Items property and get the code that's there.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Distinct(CascadingList,Title)

Was this reply helpful? Yes No