Solution: Column validation error “Sorry, something went wrong. The formula cannot refer to another column.” when referencing today’s date

If you’re trying to create column validation using [Today], you’ll likely get the following error:

Sorry, something went wrong. The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column.

Commit this to memory: when [Today] or Today fails in a formula, try Today().

While [Today] may work in list view filters, it’s not the correct format for column validation or calculated columns. You can, instead, use Today() for column validation.

For example, you could use EndDate<=Today() to require users to enter an EndDate that is on or before the date of submission.

Note that if you’re creating column validation through the modern UI, you’ll need to start validation formulas with an equals sign.

How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” actions

100itemlimit

The first time I created a flow for a list with over 100 items, I noticed an “Apply to Each” block stopping at 100 items. It’s a simple fix:

Continue reading “How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” actions”