电源应用程序编辑表格 - 编辑更改列表中的所有项目
我正在为公司制作一个Power应用程序。我需要在部门内创建每个员工的列表，以及他们需要完成的所有培训主题的列表，并且每个培训项目中都有“是”或“否”。我为每个人及其培训创建了一个带有桌子的Excel工作簿。我将其用作数据连接，并为该应用程序制作了两个屏幕。第一个使用列表模板并显示每个员工。每张卡中都有一个编辑按钮，可导航到培训编辑屏幕。该屏幕是一个编辑表单，在每个文本框中显示是或否。用户可以进行更改并查看每个培训主题的完成状态。
它非常适合一个人。但是，我遇到的问题是，对一个人的变化反思了所有员工。如果我输入一个培训主题的“否”，它将为所有员工更新。我要问的是，是否有一种方法可以确保每种编辑形式仅反映所选项目？当您单击人员屏幕上的按钮时，我将ThisItem传递到编辑屏幕中。
我在人事屏幕上选择的“选择编辑”按钮上使用的公式是：
navigate（triendit，none，{selectionItem：thisItem}）
当我在编辑屏幕上提交编辑表单时，选择“提交”按钮的公式是这样。 ：
submitform（训练形式）; 导航（人员）
再次 ，我遇到的问题是，对一名员工进行的更改反思了列表中的所有内容。我只需要找出一种使每个员工分开编辑表单的方法。任何反馈都非常感谢！
谢谢， 缺口
I am making a power app for my company. I need to create a list of each employee within a department and a list of all training topics they need to complete, and have either a yes or no in each training item. I created an excel workbook with a table for each person and their training. I used that as the data connection and made two screens for the app. The first one used the list template and displays each employee. There is an edit button in each card that navigates to the training edit screen. That screen is an edit form that shows a yes or no in each text box. The user can make changes and view the completion status of each training topic.
It works great for one single person. The issue I am having however, is that changes made to one person reflect on all the employees. If I enter "no" for one training topic, it will update that for all the employees. What I am asking is if there is a way to make sure that each edit form only reflects the selected item? I passed ThisItem into the edit screen when you click the button on the personnel screen.
The formula I used on select of the edit button on the personnel screen is this:
Navigate(TrainingEdit, None, {SelectedItem: ThisItem})
When I submit the edit form on the edit screen, the formula on select of the submit button is this:
SubmitForm(TrainingForm); Navigate(PersonnelList)
Once again, the issue I am having is that the changes made to one employee reflect on all of them in the list. I just need to figure out a way to make the edit forms separate for each of the employees. Any feedback is greatly appreciated!
Thanks,
Nick
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您将希望您的培训形式的项目（）属性为第一个屏幕的画廊。
You'll want the Item() property of your TrainingForm to be the Gallery.Selected of the first screen.