Patching with ForAll works only on certain tables

[ambobo]

I want to Patch to a to new records for each item in my gallery. This is my code which works fine when I try to patch to some tables, but does not work when I try to patch to others. I changed the input so it fits the respective tables. 
Without the ForAll the patching works for all tables. 
I can't figure out what the difference is between the tables where it does work and where it does not. With the tables where it does not work, it gives the suggestion for the table when I start entering it, but does not color it differently and shows an error instantly.

I get the errors that the functions have invalid arguments, which is not very helpful.

ForAll(Gallery4.AllItems,

Patch(

    'Testtables',

        Defaults(Testtables),

        {

       Title: "Hello"

        } )

);

Any help is appreciated. Thank you

[WarrenBelz]

Hi @ambobo ,

Firstly, you are not referring to anything in the gallery, although there is nothing structurally wrong with this code

ForAll(
   Gallery4.AllItems,
   Patch(
      'Testtables',
      Defaults(Testtables),
      {Title: "Hello"} 
   )
);

Where are you using it and what is the error ?

[ambobo]

@WarrenBelz Yes this is because I took a few steps back and just tried patching anything to the table in question. 
Which does not seem to work at all for this table. I don't have problems patching values from the gallery to other tables, so I tried simplifying my problem.

The errors I get are that the ForAll function and the patch function have invalid arguments and the columns I try to patch don't exist. (because it does not seem to be able to find the table)

[WarrenBelz]

@ambobo 

If you put this on a Label

First(Testtables).Title

do you see the Title field value from the first record on your table ?

[ambobo]

@WarrenBelz Yes this works for all tables (with adapting the column name of course)

[WarrenBelz]

@ambobo ,
Where are you running this from ? I just ran the same code here on a gallery and a test list and it ran as expected with no errors.

[ambobo]

@WarrenBelz what do you mean by where I am running this from?

It is a dataverse table.

I don't have any problems with some tables when I use basically the same code, but others don't work. Out of 8 tables 5 work and 4 don't. They have different columns and different relationships, but I don't understand what difference between them makes some of them work with this code and others not.

I thought maybe it is the relationship to the table the gallery references, but I tried different relationships and columns and it alle worked with a test table.

I know that I need to provide more information for the problem, but don't know what information, since I don't know where to look exactly.

[WarrenBelz]

@ambobo .

OK - it is always very good to state your data source in your initial post - I have been assuming SharePoint. I am not a Dataverse user, so unfortunately I am not the best person to trouble shoot this for you.

[ambobo · Accepted solution]

Through testing I found out that the problem was the relationship between the tables. In the documentation for the ForAll Function it is written, that the table which is subject of the ForAll function can't be modified and I assume that this extens to tables where a relationship with a lookup column in that table exists.