I think I've found another bug.
To get a minimum test case. I have a sharepoint list called Test with a Title (of course) and an text field "SN".
ClearCollect( Test2, RenameColumns( Test, "SN", "OrigSN" ));ClearCollect( Test3, AddColumns( Test2, "SN", If(IsBlank(OrigSN),"",OrigSN) ))
This should work, but adding an "SN" column to Test2 fails. If I call it "SN2" it works fine. This doesn't seem to be an issue when the orginal source is a local collection, but it is an issue when it's a sharepoint list.
Go to Solution.
I'm not blocked, thanks. I was trying to work around the "patch doesn't work for blank fields" issue but UpdateIf was a better workaround anyway.
View solution in original post
Thank you for reporting this issue. I've filed a bug with the appropriate team for fixing.
Meanwhile, are you blocked by this issue? If so, can you provide more details from your scenario so that we can provide a workaround while the bug is not fixed?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand