Answered

Filter CDS Account entity with record GUID

(0) Share

Report

Posted on by Clayce

I am having a problem filtering for a single Account record in the "Item" function field on my App.

As you can see in my image below... I am trying to filter the CDS Account entity records using a guid variable called "accountid_var".

The formula I am using is "Filter(Accounts, accountid= GUID(accountid_var))"

You can see that the filter is actually working as far as filtering the records as you can see the chosen record in the line below the formula.

But the problem is that I am getting an error message, "Expected Record Value" and consequently the filtered record is not appearing in the gallery.

I also tried the formula "Filter(Accounts, Account = GUID(accountid_var))"... switching out the accountid field with just Account.

But got the same results, filters the one record but get the same error.

Any suggestions on how I can fix this formula would be most appreciated.

Thanks- Clayce

Filtering Account error image.png

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Clayce
Can you clarify the object where you're attempting to set the Item property? Is it a form control?

If so, you would call the Lookup function like so:

Lookup(Accounts, accountid= GUID(accountid_var))

Was this reply helpful? Yes No
Clayce 39 on at

Like
a
(0)

Report
Copy link

Link copied!

on the EditForm.. ps tried Lookup and didn't work.

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @crodamer

Do you receive an error when you try Lookup, or is it not returning the record that you expect?

Was this reply helpful? Yes No
Clayce 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Getting error that says, "invocation of unknown or unsupported function)

Was this reply helpful? Yes No
Clayce 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Timl,

Tried again and your formula worked.
Do you have explanation as to why Lookup worked while Filter didn't on the EditForm.

Thank you so much for the help!
Clayce

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Clayce,

Glad that worked for you.

In answer to your question, the filter function returns a *table* of data. We typically call this function to populate a gallery, a data table, combo box, or any other control that expects multiple records.

In contrast, the lookup function returns the first *record* that matches the criteria. Therefore, we need to call the lookup function for controls that expect a single record, such as a form control.

Was this reply helpful? Yes No
Clayce 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Makes sense... thanks again for the help!

Clayce

Was this reply helpful? Yes No