0
votes

I am trying to get a single record from a SharePoint list however I am getting a RED X, I have passed though the ID of the item however which is working for the main form I am using on the page.

My statement is below, the list is called contacts which power apps is aware of and autocompleted

First(Filter(contacts.contacttype, ID=selectID))

also tried

First(contacts.contacttype)

which I would expect to just return the contacttype of the first record in the list.

Am I missing somthing really silly

1
also tried First(Filter(contacts.contacttype, contacts.ID = selectID)) - Tom Bruton
also trying LookUp(contacts.contacttype, ID=selectID) this seems to be the better way to do it still no luck tho - Tom Bruton

1 Answers

0
votes

Assuming contacts is the name of the list, and contacttype is a field on the list, you will need to get the record before you reference the field.

To do this in one line:

First(contacts).contacttype

Or as multiple lines, saving the record to a variable:

Set(varContact,First(contacts))
varContact.contacttype