Patch Formula Error

(0) Share

Report

Posted on by CU22012056-0

I am creating a form in Power Apps that has 9 manual fields for user input. The patch formula writes the data back to a SharePoint list. The code is below and I keep getting an error on the code that says "This type of argument FM_Email does not match the expected type text. Found Error." I removed FM_Email from the code but then it just gives the same error on the next line of code. I checked spelling and the names match the SharePoint list and all are classified as single line of text. "Does not match the expected type" seems to be the common error. Appreciate any help if anyone knows how to fix this:

Patch(
    FAR_Request_Queue,
    Defaults(FAR_Request_Queue),
    {
        PID_to_Process: BrowseGallery1.Selected.Value,
        Requestor_Name: txt_Requestor_Name.Text,
        Name_of_Effort: txt_Name_of_Effort.Text,
        Tech_POC: txt_Tech_POC.Text,
        Tech_Email: txt_Tech_Email.Text,
        Tech_Phone: txt_Tech_Phone.Text,
        FM_POC: txt_FM_POC.Text,
        FM_Email: txt_FM_Email.Text,
        FM_Phone: txt_FM_Phone.Text
    }

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU22012056-0

Would really like to see the SharePoint Names (not the display name)

Then would like to see the List itself and finally, its confusing s you have a gallery as one aspect of your data, you said you have a form, but I do not see a Form usage there, also are you sure you should use .Text and not .Value? is it the Classic or the Modern Text Input? as they are different.

Make sure .Text is valid

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
Suggested answer

Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU22012056-0

There are multiple issues i can able to see here

PID_to_Process: BrowseGallery1.Selected.Value to PID_to_Process: BrowseGallery1.Selected.Id

I feel some other fields DataType is Different, for example i feel email should be FM_Email: Value(txt_FM_Email.Text)

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
WarrenBelz 154,473 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@CU22012056-0,

Summarising this as what you have is a really basic Patch

Are you using Classic or Modern Text Inputs - if Modern, you need .Value, not .Text as the output reference - I think @Michael E. Gernaey is correct here and if so, please mark his solution.

What is the Items of BrowseGallery1 and do you have a column in there called Value ?

The field names in SharePoint will work fine with the current names even if you have changed them but they all need to be Single Line of Text, so re-check these (names and types) against your List Settings.

Was this reply helpful? Yes No
WarrenBelz 154,473 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CU22012056-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No