I have created an App, where I have 2 combo boxes & 1 drop down. The choices for those boxes are coming from a table in excel. I am trying to figure out a way to save the selected values to a sharepoint list that I have.
I created a choice column in my sharepoint list for each combo box and drop down box, but I keep getting an error message. For the drop down I have the column in my share point list called GLCode, I am not sure where I am going wrong in my formula.
Here is the formula I have:
Patch(Rental,Defaults(Rental),{Title:"New",EqType:Title2.Text,'Duration ':DurationText.Text,GLCode: Dropdown2.Selected.Value})
Since your column in SharePoint is a choice column it is expecting a record to be patch and not just the text value. I haven't tried this using Excel as my dropdown list in PowerApps but here is a quick change you can test. Just remove the ".Value" from "Dropdown2.Selected", so it is passing the record instead of the value.
Patch(Rental,Defaults(Rental),{Title:"New",EqType:Title2.Text,'Duration ':DurationText.Text,GLCode: Dropdown2.Selected})
No luck with that. I get an error saying:
"Invalid argument type. Expecting a Record value, but of a different schema."
I'm facing the same issue. Any lucky?
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
254 | |
235 | |
82 | |
36 | |
27 |
User | Count |
---|---|
312 | |
266 | |
120 | |
68 | |
44 |