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
