CurrentValue - Refer to the first call

I am using filter() inside formulaMap(), how can I make the CurrentValue refer to the element of the FormulaMap list not the Filter list ?

ListCombine(thisRow.[Step 2 Result].Informations).FormulaMap(Event.Filter(Event.name = CurrentValue.ParseJSON(“$.name”)).ModifyRows(URL, “https://fran.fr”))

Hello @Zainab_Fitian

You can use WithName() formula. It will put a different name to an expression.

For example:

FormulaMap(
WithName(CurrentValue, element,
Event.Filter(element.property = CurrentValue.property)
)
)

Best Regards,
Felipe Arnhold

1 Like