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?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
202 | |
176 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
268 | |
104 | |
74 | |
56 |