Coalesce lookup not working

(0) Share

Report

Posted on by genarich

318

Hi,

I am getting an error below showing that types can't be compared (Record, Number).

Back story: I am recording all bookings/reservations made by employees in a SharePoint list. I was able to successfully Patch and create items when a user books a desk. However, when they need to update those details, I am hitting the error below. I would really appreciate your help on this please!

With(
 {
 _record: Coalesce(
 LookUp(
 'Book a Desk',
 MasterFormID = varRecord.ID
 ),
 Defaults('Book a Desk')
 )
 },
 Patch(
 'Book a Desk',
 _record,
{
 Title: User().FullName,
 DeskName: RoomsGallery.Selected.Name,
 Date: StartDateTime,
 EndDate: EndDateTime}
))

Categories:

Building Power Apps

I have the same question (0)