Hi Sir/Madam,
Would you please help me on this. Please refer to the picture.
I have 2 lists, Record_ID column in List B is a lookup column which gets value from Title column in List A.
I have an app, via which I wanna update Date_column in List B where the Record_ID equal to certain value.
I wrote the formula in onselect of the button as below
Patch('List B',
lookup('List B', Record_id=aaa),
{Date_column: date_picker.selectedDate})
It gave error message, saying that "These types can't be compared: Record, Text."
Then I realised that lookup column is special, I changed 'Record_id=aaa' to 'Record_id.Value=aaa'.
The error was gone, but the app actually doesn't work.
Would you please advise.

Report
All responses (
Answers (