英文:
How do I save combo-box values to a SharePoint list?
问题
我有一个Power App，用户在其中输入序列号。我有1个文本框和3个下拉框，它们依赖于用户输入的序列号。查找表在Excel中。它能够正常工作并进行查找。
然而，我需要能够记录数据在SharePoint列表中。文本框被正确记录，但下拉框的值没有被记录。
简而言之... Power App > 用户输入序列号 > 在Power App中查找Excel表中序列号的4个属性 > 用户点击提交 > Power App记录数据在Sharepoint列表中 > Power Automate流发送电子邮件通知。
英文:
I have a Power App where users input a serial number. I have 1 text-box and 3 combo-boxes that depend on the serial number input by the user. The lookup table is in Excel. It is working and able to do lookup.
However, I need to be able to record the data in a SharePoint list. The text-box is recorded properly, but the values of the combo-boxes are not.
In short... Power App > User input serial > Lookup excel table for 4 attributes of the serial > user clicks submit in the power app > power app records data in Sharepoint list > power automate flow sends email notification.
答案1
得分: 1
Use Patch function like this:
使用 Patch 函数如下所示：
Patch('DataSouceName', Defaults('DataSouceName'), {Title: TextInput1.Text, Comboboxfield: {Value: Combobox1.Selected.Value}})
这里，Combobox1 是下拉框的名称，Comboboxfield 是您需要存储下拉框所选值的列的名称。
要获取有关 Power Apps 的更多信息，请访问以下网站：
http://ashishcoder.com/courses/power-apps/topics-list.html
谢谢
英文:
Use Patch function like this
Patch('DataSouceName', Defaults('DataSouceName'), {Title: TextInput1.Text, Comboboxfield: {Value: Combobox1.Selected.Value}})
Here, Combobox1 is the name of the combo box and Comboboxfield is the name of the column where you need to store the combo box selected value.
For more info on Power Apps visit the following website:
http://ashishcoder.com/courses/power-apps/topics-list.html
Thank you
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论