Unanswered

The type of this argument 'List Name' does not match the expected type 'Record'. Found type 'Error'

(1) Share

Report

Posted on by PraveenC

166

I have a share point list with column Company as lookup (this column is looking into another share point list called companies and pointing to Title).

Below is the code I have written in Power apps patch function.

I have tried

Company:cmbCompany.Selected.Value
Company:cmbCompany.Selected.Text
Company:cmbCompany.SelectedItems

and many other combinations.

Set the value to Allow nulls in list setting for this column.

Here are the properties of combox box used

Companies List

This is where I am expecting the data to be saved into Waiver List page

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report
Hi PC-13080023-0,

You have changed the Items of your Combo Box from the standard Choices(ListName.FieldName) - Lookup columns will cause you more grief than this (I have never used them with Power Apps), but assuming that this is a single choice Combo Box, the Patch would be something like
Patch( Waivers, Defaults(Waivers), { Company: { Value: cmbCompany.Selected.Title, Id: LookUp( Companies, Title = cmbCompany.Selected.Title ).ID } } )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
PraveenC 166 on at

Like (0)

Report

Hello WarrenBelz,

This teams to be working. Can you also please suggest for the combo box which are popualated in code in Items event.

For ex: for Types column, i have added the values manually.

When I use this code it still throws the same error

Types:cmbtype.Selected.Value

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi PraveenC

Where are you using that code ?

Was this reply helpful? Yes No
PraveenC 166 on at

Like (0)

Report

Used this code and it works fine

Company: {

Value: cmbCompany.Selected.Title,

Id: LookUp(

Companies,

Title = cmbCompany.Selected.Title

).ID

}

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Yes - that is exactly what I posted

Was this reply helpful? Yes No