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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps Patch State...
Power Apps
Answered

Power Apps Patch Statement Error expects text finds record

(0) ShareShare
ReportReport
Posted on by 5,836 Moderator

I am having the strangest patch error.

 

This type of argument 'Approver' doesn't match the expected type 'Text'. Found type 'Table'.

 

I am patching from a collection to a SharePoint list.   The Approver is patched to the collection from a variable.   The variable does not show as a record and neither does the item in the collection.    I am at a loss as to why it's seeing this item as a record in the patch statement.

 

I have refreshed the data source, saved, exited and come back in and it still has an error.

 

You can clearly see that the initial variable that holds the approver data (ManagerDN) is text and not a record.

 

variables.png

 

So the RequestInput Collection would not have a record value for approver since that value comes directly from the ManagerDN variable.

 

Collection.png

 

Error (In this instance, the collection only has one row, once I complete the If statement, the first statement will have the ForAll as the collection will have multiple rows):

 

PatchError.png

 

 

 

 

Categories:
I have the same question (0)
  • CU-18081211-6 Profile Picture
    9,270 Moderator on at

    Hi @JR-BejeweledOne ,

    Use the variable ManagerDN instead of RequestInput.Approver. Starting from what you described such an approach should work, right ?

  • JR-BejeweledOne Profile Picture
    5,836 Moderator on at

    It would work for the single row instance, but not when the collection has more than one row.   There are multiple things going on here, and the collection isn't being patched immediately after being collected except in this one instance.

     

    I need to resolve this so I won't have issues when I am patching the collection when it has multiple rows to SharePoint.

  • Verified answer
    JR-BejeweledOne Profile Picture
    5,836 Moderator on at

    I tried everything I could think of and could not get this to work.   I eventually copied a patch statement from another app and modified it and then pasted it into my current app.   For whatever reason this worked when nothing else would.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard