tried to create new Custom column like this :
IF([SalesOrderOriginCode] = "PHONE", "PHONE",
IF(Text.Start([InvoiceAddressCity],1)= "A", "LOCAL","EXPORT")
No syntax error, but after press ok, it says The name IF wasn't recognized. What's wrong ?
Solved! Go to Solution.
@VoltesDev seems like you are adding this in Powe Query
if [SalesOrderOriginCode] = "PHONE" then "PHONE" else if Text.Start([InvoiceAddressCity],1)= "A" then "LOCAL" else "EXPORT"
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates