So the concat is only applied to the "Body/year" part of the statement. Encompassing the entire output statement results only in a string that isn't evaluated. GeoffersTry using this expression if it works: @{concat('outputs(''Get_a_row'')?[''body/Year',item(),''']')} ...
I want concatenated project values with comma-separated for Employee, like shown in below image I need help in getting it worked viapower automate flow Flow should be triggered when new item is created/updated inEmployee-Project List Please guide me. Thanks in advanced...
outputs('Get_a_row')?[concat('body/Year', Items('Apply_to_each_financial_year'))] So the concat is only applied to the "Body/year" part of the statement. Encompassing the entire output statement results only in a string that isn't evaluated. GeoffersTry using this expre...
I presume this is a concatenate of some sort, but I can't get the syntax If I can get this syntax to work it would loop round and create an entry for all 5 years without needing to write 5 create item actions in the flow. Many thanks in advance ('outputs(''Get_a_...
So the concat is only applied to the "Body/year" part of the statement. Encompassing the entire output statement results only in a string that isn't evaluated. GeoffersTry using this expression if it works: @{concat('outputs(''Get_a_row'')?[''body/Year',item...
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(K23:K35,K23:K35<>"None","None"))) My apologies, it should have been Ok so 1) =TEXTJOIN(", ", TRUE, IF(K23:K35="None", "", K23:K35)) duplicate allergens still appear and when column K is changed to have none in all the cells I get...
All this additional stuff about concatenating values just becomes easy, and you can use filters etc etc if you build a solution in Power Apps. Your scenario is ideal for Power Apps but so much harder (or maybe not even possible) with Lists on its own. ...