Powerapps limitation as of 5/2/2018

  1. Can not edit “rich text” of SharePoint list Multiple line text field. see post here
  2. “Html text” control is read only.
  3. “Data Table” control read only. Work around solution
  4. how to open attachment image at new window, or a preview window?
Posted in Uncategorized | Leave a comment

Excel horizontal axis date/month format

  1. right click “x axis”, select “format axis”
  2. Select “Number”,
  3. Category: “Custom”
  4. Type: “[$-en-US]mmm;@”
  5. and then, change Format Code to: [$-en-US]mmm;@
  6. click “Add”

Number to Date:

  1. Major Units “30” means “30 days”


Posted in Uncategorized | Leave a comment

Excel create Gantt Chart

refer to this post

Posted in Uncategorized | Leave a comment

WaterCAD error “Value does not fall within the expected range”

please refer to this post:

Error performing standard tasks: “Value does not fall within the expected range”

Posted in WaterCAD | Leave a comment

Site Plan consist

  1. Title Cover page
  2. Conditions
  3. Existing condition & demolition plan
  4. site plan overall
  5. grading plan
  6. utility plan
  7. dry utility plan
  8. Utility profile
  9. storm water management plan
  10. erosion and sedimentation plan
  11. construction phase
  12. traffic control plan
  13. site plan details
  14. building architecture plan
  15. landscape plan
  16. lighting plan
  17. photometer plan
Posted in Uncategorized | Leave a comment

Outlook email search tips

see this post: Learn to narrow your search criteria for better searches in Outlook

Posted in Office365, SharePoint, SharePoint online, Uncategorized | Leave a comment

Combine multiple excel sheet (Power Query)

refer to this article

Power Query is included with Excel 2016. It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section. This means there is nothing to install. If you are using Excel 2016, go to the Data tab on the ribbon and press the New Querybutton to create a query and open the Power Queryeditor.

  1. prepare each sheet: create “Table”. Column names shall be identical (it is case sensitive).
  2. create query “From Table”.
  3. merge query and load data to a new sheet
Posted in Uncategorized | Leave a comment