Track and Trace App - Using Variables to store SharePoint List records

[jond]

Hi, in at the deep end as I've been asked to create my first PowerApp and it's a Track and Trace solution for the business I work for, essentially a check in/check out app to register multiple ins/outs in a day of users on site.

I have two SharePoint Lists, Users and CheckInOut, when the user loads the app, on app load I'm trying to place their User record and the last CheckInOut record into a global variable so I'm not continuously looking it up in the app.

Set(CurrentCheckedInRecord,First(SortByColumns(Filter(CheckInOut,varEmail=CheckInEmail), "CheckIn",Descending))); Set(varCurrentUserRecord,Filter(Users,varEmail=StaffEmail));

There are no errors, but when I try to reference the fields in variable record data in other places, say to make a button visible or not

If(varCurrentUserRecord.UserType = "Admin" ,true,false)

Note UserType is a Choice field in the SharePoint List

Or when I want to Patch back to the CheckInOut list, I cannot pass the contents of the variable over to it.

Set( CurrentCheckedInRecord, Patch( SSR_CheckInOut, Defaults(SSR_CheckInOut), { Building: "Riverside House", StaffName: User().FullName, CheckInEmail: User().Email, CheckIn: Now(),CurrentlyOnSite: "Yes", Desk: varCurrentUserRecord.DeskNumber, UserID: varCurrentUserRecord.ID }) ); Navigate(scrCheckInEnd,ScreenTransition.Cover)

Desk and DeskNumber are both number fields in the SharePoint List, and UserID is a number field, ID is the automatically created SharePoint list item ID

I must have read 20 internet posts and I can usually grasp where I'm going wrong but in this case it's compounded by a lack of experience/understanding trying to piece it together, how do I get the contents of the fields in my stored variables to work?

Thanks for any pointers.

[Roser · Accepted solution]

• Try troubleshooting with a Label or in the variables and look if looks unusual
• try manually running the OnStart (three dots next to App)

I think there is a First() missing (or use LookUp)

Set(varCurrentUserRecord,First(Filter(Users,varEmail=StaffEmail)));

If it's a Choice field there should be a .Value

If(varCurrentUserRecord.UserType.Value = "Admin" ,true,false)

Also the If() is redundant varCurrentUserRecord.UserType.Value = "Admin" will do, because it already returns a Boolean Value

[jond]

Thanks for taking the time to reply, you wouldn't believe how long that bamboozled me for.

Essentially without the first() as part of the function it regards it as a table, with first() it becomes a record, regardless of whether the filter you use returns just one record. Would not have guessed that. Now I've found the Variables under Files that's a bit more obvious as it states what type is stored.

Also right about visibility it returns true anyhow when evaluating, so no need for an If, and the If statement doesn't appear to work in this circumstance.