英文:
I have a problem to solve in powerapps dropdown menu
问题
你好！我制作了一个应用程序，在这个应用程序中，我注册了棉花包的RFID。它包含一个选择菜单，在菜单中有一个从1到500的数字序列，这是包裹的标识。问题是：当添加包裹和RFID时，我希望包裹编号从我的选择菜单中删除，这样下一个读取的包裹将是下一个编号。有没有解决这个问题的公式思路？
注意：（这些RFID读数将存储在SharePoint的列表中，我的选择菜单具有公式"sequence(500;1;1)"）。
我尝试过使用复选框来显示选择菜单中的序列号，我尝试过使用forall和removeif来制作筛选条件，但我不确定如何正确操作这些语法。
英文:
What's up guys!! I made an application and in this application I register an RFID of cotton bales. It contains a selection menu in which I have as an item a sequence of numbers from 1 to 500 that is the identification of the bale. The problem is: when adding the bale and the RFID, I want that bale number to leave my selection menu, so that the next bale read will be the next number. Any formula idea to solve this problem?
Note: (these RFID reads are going to a list in sharepoint and my selection menu has the formula "sequence(500;1;1)").
I've tried making check buttons to show the sequence number in the selection menu, I've tried making filters with forall and conditions with removeif, but I don't think I'm knowing how to manipulate the syntaxes.
答案1
得分: 0
有多种方法可以解决这个问题：
- 在处理捆包后，将初始的1-500个数字存储在集合中，然后逐个移除。
- 将序列过滤为不在SharePoint列表中出现的数字。
- 使用流来预先填充SharePoint列表中编号为1-500的项目，并仅在处理捆包时切换字段。在下拉菜单中使用相同的筛选条件。
此外，我建议您熟悉PowerApps中存在的不同类型的属性和公式。您可以看到有所谓的“行为”公式，执行某些操作，还有返回值的公式。您尝试的方法似乎混合了这两者，通常这样做是行不通的。过滤是非行为的，因此在这个上下文中不能使用ForAll()或RemoveIf()。
英文:
There's a number of ways to approach this problem:
- Store the initial 1-500 numbers in a collection and remove one by one after processing a bale
- Filter the sequence to numbers that do not appear in the SharePoint list
- Use a flow to pre-populate the SharePoint list with the items numbered 1-500 and only toggle a field when the bale is processed. Use the same filter in the dropdown.
Also, I recommend familiarizing yourself with the different types of properties and formulas that exist in PowerApps. You see there are so-called 'Behaviour' formulas that perform some action and others that return values. The things you've tried seem to be mixing the two, which typically doesn't work. Filtering is non-behaviour, so you can't use ForAll() or RemoveIf() in this context.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论