web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help with error "inval...
Power Apps
Answered

Help with error "invalid argument type (table). expecting a record value instead"

(0) ShareShare
ReportReport
Posted on by 247

I am getting the error of "invalid argument type (table). expecting a record value instead" when patching the SP list.

 

Here is the code: ClearCollect( col_DatatoPatch, ShowColumns( col_Booking, "ID", "Title", "BookedDate", "BookedRoom", "BookedRoomName", "BookingStatus", "REQNum" ) );

 

Patch(BookingLineItems, col_DatatoPatch);

 

List structure:

 

NewBee117_0-1683044786325.png

Any idea how to make it work? TIA.

 

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    154,496 Most Valuable Professional on at

    HI @NewBee117 ,

    To answer that, I need to see the structure of col_Booking

  • NewBee117 Profile Picture
    247 on at

    @WarrenBelz Sure. Here it is. Thanks.

     

    NewBee117_0-1683133263269.png

     

  • WarrenBelz Profile Picture
    154,496 Most Valuable Professional on at

    @NewBee117 ,

    The columns in both need to be the same type - I suspect that you have BookedDate as a Date value in the Collection and a Text field in the list.

  • NewBee117 Profile Picture
    247 on at

    @WarrenBelz based on your suggestion, I did a test, provide the BookedDate a string value, still getting the same error.

     

    NewBee117_0-1683217040983.png

     

     

  • Verified answer
    WarrenBelz Profile Picture
    154,496 Most Valuable Professional on at

    @NewBee117 ,

    I was suggesting you make them both dates, but the real issue here is that you have a mismatch with one or more columns. Try deleting and adding one at a time until you find the error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard