Power Apps Patch Statement Error expects text finds record

[JR-BejeweledOne]

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.

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

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):

[gabibalaban]

Hi @JR-BejeweledOne ,

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

[JR-BejeweledOne]

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.

[JR-BejeweledOne · Accepted solution]

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.