Type problem while getting a column from Dataverse

(1) Share

Report

Posted on by Pigeon_Normand

Hello everybody,

I have a stupid problem that I can’t solve for the very life of me.

I’m taking the official MS course about how to do an Expense Report app (that uses Dataverse tables), and I’m totally stuck with this part:

ClearCollect(
    ColExpenseDetails,
    Filter(
        'Expense Report Details',
        'Expense Report'.'Expense Report' = VarExpense.'Expense Report'
    )
)

My problem is that 'Expense Report'.'Expense Report' comes out at a Table while VarExpense.'Expense Report' comes out as a GUID, and so the comparison can’t be done.

After hours of searching, it appears that any call of Dataverse columns from the formula bar gets me tables.

For example 'Users'.'User' also comes out as a table, or any other column.

How is it possible? How can I access the contents of the column?

Any clarification would be greatly appreciated.

Categories:

Using Apps Using Formulas

All responses (4)

Answers (1)

Michael E. Gernaey 40,844 Super User 2025 Season 1 on at

Like (1)

Report
Type problem while getting a column from Dataverse

Hi

Not sure I understand but I think so

You mean this? I would have to see the Name in the Data Tab, but yeah, it should be the Plural, so not understanding pointing to a "Singular" name for dataverse (at all)
'Expense Report Details'
Verified answer

Pigeon_Normand 23 on at

Like (1)

Report

Type problem while getting a column from Dataverse

Allright, I finally have the answer. It’s because I used the plural on the left part, as I would do when making a join in SQL while everything should be in the singular. Why? I don’t know, it doesn’t really make sense to me.
Pigeon_Normand 23 on at

Like (1)

Report
Type problem while getting a column from Dataverse

Hi FlMike, thanks for your answer.

"on the Left side after the second 'Expense Report' add a period and see what Intellisense brings up."

It doesn’t bring up anything. as if it wasn’t expecting anything. And if I type something else, it’s unhappy.

"My guess is (and no idea why) You would see another Expense Report, or another column that is the actual GUID"

I already tried with various columns and tables, with the same result.

" In dev mode. highlight the entire Left side and then look what intellisense says it is. If that doesnt work just click or highlight the last 'Expense Report' and see what it says."

On the code I pasted, it’s not totally clear because of the lack of singular/plural distinction, but let’s say, if I have

'Users'.'User' = (whatever)

Intellisense specifically says 'Users' is a Table, as well as 'Users'.'User', that’s ludicrous and totally opposed to any tutorial I’ve seen so far.

Just in case, I use the French version, and as such there are differences in the use of the period, comma and semicolons. But still, the access to properties/methods is still normally used with a period.
Michael E. Gernaey 40,844 Super User 2025 Season 1 on at

Like (1)

Report

Type problem while getting a column from Dataverse

HI

For kicks trying this

on the Left side after the second 'Expense Report' add a period and see what Intellisense brings up.

My guess is (and no idea why) You would see another Expense Report, or another column that is the actual GUID

I agree its weird.

Also try this. In dev mode. highlight the entire

Left side and then look what intellisense says it is. If that doesnt work just click or highlight the last 'Expense Report' and see what it says.