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

Announcements

News and Announcements icon
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,272 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard