英文:
Power Apps combox filter not working on Data preview Table ( Date type : Control Error )
问题
我使用一个筛选技术来从选择的组合框中筛选数据到数据表(预览)
例如，筛选('CLAIMS PROCESSs'，BusinessPlanClass = 'Business Plan Dropdown'.Selected)
我收到一个错误，错误消息是“Business Plan Dropdown = There is an error in this formula . Try Revising the formula and running it again , Data type : Control ???? Not sure where I have gone wrong , is there a way I can change the data type control to Text .... Need Help !!!!”
组合框下拉列表和表格的数据源相同...
我希望筛选能应用到数据预览表中。
英文:
I using a filter techinique to filter the data from selected combo box to Data table(Preview)
e.g. Filter('CLAIMS PROCESSs',BusinessPlanClass = 'Business Plan Dropdown'.Selected)
I get error saying Business Plan Dropdown = There is an error in this formula . Try Revising the formula and running it again , Data type : Control ???? Not sure where I have gone wrong , is there a way I can change the data type control to Text .... Need Help !!!!
the source for the combobox dropdown and the table are the same...
I want filter to get applied the data preview table
答案1
得分: 0
The Selected property of the combo box control returns a record with all properties from the selected item. From the error it looks like the BusinessPlanClass column of the 'CLAIMS IBNR PROCESSs' table is a "simple" value (such as text or number), so it cannot be compared directly to a record.
Try typing . after 'Business Plan Dropdown' .Selected - and it will show the possible properties that exist in that record. That should show you the appropriate one that you will need to choose to compare with the BusinessPlanClass column in your table.
英文:
The Selected property of the combo box control returns a record with all properties from the selected item. From the error it looks like the BusinessPlanClass column of the 'CLAIMS IBNR PROCESSs' table is a "simple" value (such as text or number), so it cannot be compared directly to a record.
Try typing . after 'Business Plan Dropdown'.Selected - and it will show the possible properties that exist in that record. That should show you the appropriate one that you will need to choose to compare with the BusinessPlanClass column in your table.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论