Andreas Wijaya's Blog

Hi All, Just want to share a nice post that provides a trick with applying exclusion filter for disabled user accounts. If you add the filter after the first full profile sync, your filter won't work with Incremental sync unless you do Full sync. There is a trick to make Incremental sync picks up the changes, which is toggling (Enabling and Disabling) the user in AD and then run the Incremental sync. This should save you time if the number of disabled users is not that many and this won't clear any user-entered changes on existing user profile data. HTH, Andreas

Hi all, I have been enjoying my SP journey without InfoPath until two weeks ago when I was asked to help my colleague with Infopath form enhancement. Looking into how it was deployed to SP online, I noticed quickly it was published as a Content Type. So we did some enhancements, and once it's all done it's time to publish! What I wasn't aware of is that if the Form Template wasn't obtained from the deployed site, the promoted fields information will be set to 'Create new site column' instead of updating existing content type. After the form is published, it creates duplicate promoted site columns which are a nightmare to clean up! Not to mention that some site columns are read-only and cannot be deleted through UI. Luckily, I found that we can use SP JS to do the clean up of all duplicate fields. We just have to be careful to only delete the duplicate ones (marked by '_1' appended to existing field name, or '_12' and '_123...