Distinct函数对一个表的每个记录计算一个公式,并返回结果的单列表,其中删除了重复值。 列的名称为Value。 当前正在处理的记录的字段在公式中可用。 可以使用ThisRecord运算符,也可以只按名称引用字段,就像引用任何其他值一样。As运算符也可用于为正在处理的记录命名,从而使您的公式更易于理解,并且使嵌套记录可以被访问...
Hello, I have a long list from my sharepoint list which content the same province value for cascading dropdown in powerapps. I try to do the "Distinct (Addresslist, ProvincialName)" in dropdown, but I can see only a few list value display in my dropdown list. I understand that this ...
First( Sort( Distinct( CityPopulations, Country ), Value ) ).Value This formula sorts the results from Distinct with the Sort function, takes the first record from the resulting table with the First function, and extracts the Result field to obtain just the country/region name.Feed...