Power Platform Community Forum Thread Details

Dropdown formulas failing in Dataverse (Sort/Collect type errors in Canvas App)

I’m building my first Canvas App that uses Microsoft Dataverse. The app includes a working login screen that successfully writes user names into Dataverse — so basic create and write operations work without any issue.
However, when building a dashboard screen that uses dropdowns to filter and display data, I keep running into formula errors.

Even though the Dataverse table (Organisations) is correctly created and connected, I keep getting errors in Power Apps whenever formulas try to manipulate or extend the data — for example:

Simpler formulas do work fine, like: Distinct(Organisations, 'Name Organisation')

It doesn’t seem to be related to permissions or connections — I can read data without issues. The problem appears to be how Power Apps interprets field types or return types in this environment, continuesly resulting in type errors such as: “Invalid argument type” “Expecting one of the following: Text, Number, Boolean…”

What I’ve already tried

Created a new Dev environment with a proper security group (DataverseAdmins)
Created new Dataverse tables with simple text columns
Reconnected all Dataverse data sources
Republished and tested the app in incognito mode
Tested various formula combinations: Text(), ForAll(), SortByColumns(), etc.

None of these actions resolve the issue — it consistently breaks when I try to sort, collect, or add columns based on Dataverse data.

What could cause this kind of behavior?

Why would simple Distinct() work fine, but Sort() or AddColumns() immediately trigger type errors when connected to Dataverse?

Hi @HK-13101328-0

It would most likely seem that you are using the wrong "term" or not including the proper syntax.

In some cases, things return Value, not a specific Column name

In some cases, you require "" around the column Name not just the Name

I would need to see the list of the ones you tried, also, what does it show you in the UI, is it just broken (red squiggles?)

Please share as it sounds completely like syntax.

As for why Distinct works is because it doesn't have anything for you to accidentally Syntax wrong.

If you put Result, and are Mean to put Value its syntax

If you are meant to put "Result" and you put Result its syntax

And that is just examples of when / why these happen.

For each exact one you'd have to put a picture for me to tell you each one, but I would do a look up at the documentation to verify what you typed versus what is intended "" or Value or "Name": etc

Leaderboard > Microsoft Power Up Program Community