Formula is: WithName( AddRow([Table 1]), newrow, [lookup table 2] .ModifyRows( [Table 2].[Table 1 Inputs], If( [lookup table 2].[Table 1 Inputs].IsBlank(), newrow, [lookup table 2].[Table 1 Inputs].ListCombine(newrow) ) ) ) It may be related …

Hi @cnr , Interesting case, but I’m not sure I completely understood it. What is your purpose? You say: However, AddRow() formula returns an Action, not a row (*). Therefore I expect that the quirky behaviour is due to the fact that the first time it adds the full row by guessing the data infe…

[image] Federico_Stefanato: However, AddRow() formula returns an Action , not a row (*). @Federico_Stefanato This is a good explanation. We have discussed potentially changing this for WithName, but we have not had the bandwidth to get to it yet. We will have to spend some time thinking about…

Thank you for your response! Is there even a way to call an action if it’s in a table? Can I add actions to various rows in a table and then call RunActions on them? Also, isn’t it fairly inconsistent right now? For some reason the first AddRowis executed and then the second one is not? I would un…

[image] cnr: Also, isn’t it fairly inconsistent right now? For some reason the first AddRow is executed and then the second one is not? I would understand if it were both or neither, but as it stands it seems unpredictable. Yes, this is my opinion as well. [image] Federico_Stefanato: Let…

Please, follow here: [image] [Open discussion]: What an action (add, delete, modify) should return? Developers Central Hi everybody. The discussion started here ( Why Doesn't This Formula Work? by @Connor_McCormick and followed by @Jason_Tamulonis ), but perhaps it’s a go…

Why Doesn't This Formula Work?

Product Feedback Bugs

Federico_Stefanato May 5, 2021, 2:45pm 6

Please, follow here:

1 Like

Topic		Replies	Views
withName row variables cannot access column values in certain cases Bugs	15	987	April 28, 2021
Help with nested loops and the new WithName() formula	22	4437	February 4, 2021
[Open discussion]: What an action (add, delete, modify) should return? Developers Central	11	1297	October 11, 2022
WithName table alias fails at column reference Bugs	6	728	June 30, 2023
How do I force a formula action to run even when calling it inside a Concatenate or ListCombine?	4	427	April 5, 2023

Why Doesn't This Formula Work?

Related topics