0

I have a collection colPendingChanges and it has multiple rows. Each row has multiple fields and one of them is AttributeTable which is a nested table.

colPendingChanges = 
[
{fieldA: 'foo',
filedB:'bar',
AttributeTable: 'Table'}, {....}, {....}]

I'm trying to iterate through colPendingChanges and then iterate through AttributeTable to store each row into Attribute Intakes table (dataverse) but I could not find a way to access each field value of AttributeTable

But it throws the error something like

The type of this argument 'new_attributesequence' does not match the expected type 'Text'. Found type 'Error'.

Name isn't valid. 'attributeSequence' isn't recognized.

I tried display name, logical name of the field but none of them worked. Is there a better way to access field value of AttributeTable so that I can map correctly inside

    ForAll(
        colPendingChanges,
        ForAll(
            ThisRecord.AttributesTable As attributeRow ,
            Patch(
                'Attribute Intakes',
                Defaults('Attribute Intakes'),
                {
                    attributeSequence: attributeRow.attributeSequence // throws the error here

                }
            )
        )
    );

this is a collection and I store this whole collection into a AttributeTable of each row inside colPendingChanges

enter image description here

Improve this question
4
  • You mention that the field in the collection that stores the table is called AttributeTable, but in the expression you reference it as ThisRecord.AttributesTable (extra 's'). Could that be the issue? Commented Dec 12 at 14:25
  • thanks for looking into it, but no that is not the root cause. it was just a typo in the example. Commented Dec 12 at 17:08
  • Can you try attributeRow.attributeSequence.Value Commented Dec 13 at 16:16
  • stackoverflow.com/users/11015504/m-k-kim If you can provide the structure used within the 'Attribute Table' property, that would be easier to help you out Commented Dec 16 at 6:34
Related questions
0
Column doesn't exist – but it clearly does in collection and SharePoint
0
Patch related table with collection from another table. "Specified column not accessible in this context"
0
PowerApps Can't Patch Collection as Table
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.