Patch - does not match the expected type record, found type text

(0) Share

Report

Posted on by OsmandFernando

Hi @PowerAddict and other experts,

I am trying to automate the cash received using patch. I am so exciting. Having an issue for the Invoice number field

Annotation 2019-11-27 235419.jpg

Patch('Cash Received',Defaults('Cash Received'),{Date:DataCardValue180_2.SelectedDate},{'Customer Name':DataCardValue181_2.Selected},{Amount:Value(DataCardValue182_2.Text)},{'Invoice_x0020_Number':DataCardValue179_2.Text});Refresh('Cash Received');

Thank you

Osmand

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (2)

Report

Since the error states that a record is expected, you might want to lookup the invoices with the invoice number in the text field, using something like this:

Lookup(Invoices, 'Invoice Number' = DataCardValue179_2.Text)

You might have to convert the text value to a number using the Value function. L

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Verified answer

OsmandFernando on at

Like (0)

Report

Thank you @PowerAddict but it did not work, may be i did a mistake. What I did, I changed the field type from look up to Text in the SharePoint then did the formula

Thank you so much

Was this reply helpful? Yes No