Matthew Perren
banner
matnav.co.uk
Matthew Perren
@matnav.co.uk
#MSDyn365BC consultant. Reporting specialist
#PowerBI
#JetReports
#SQL
#Cosmos

Professional profile of @matthewperren.bsky.social
I’ve read a couple of articles about #PowerAutomate flows to automate the setting of an out of office in Outlook. However the formulas they recommend for start/end date times all feature utcNow() but in ways that make no sense. It’s volatile so would need to be part of an extended if statement no?
November 13, 2025 at 7:06 AM
October 21, 2025 at 7:57 AM
That’s exactly it.

I’ve got a wee button in excel that lets the user browse for the file. The cell it returns to is a named range “Path”

That is then stored in PQ in a single value list called Path but Csv.Document(File.Contents(Path)) returns this error
June 18, 2025 at 12:51 PM
Anyone having trouble adding a new distribution line to an allocation account in #MSDyn365BC?
April 30, 2025 at 2:01 PM
March 29, 2025 at 6:47 PM
March 3, 2025 at 7:00 PM
BC Sandboxes at the minute, man! So slow!

Anyone else? Just me?

#MSDyn365BC
March 3, 2025 at 4:36 PM
You don’t know do you, @o2?
January 5, 2025 at 6:33 PM
January 4, 2025 at 8:46 AM
January 4, 2025 at 8:37 AM
I mean, do they? I’ve literally heard no one - not one single end user - articulate this wish. Ever.
January 2, 2025 at 7:51 PM
That’s next year’s Christmas card sorted.
January 1, 2025 at 10:50 PM
He’s been fighting again.
December 28, 2024 at 9:55 PM
Amazing. Selena Gomez follows me. She’s from Leeds. “Began me career as a child actress”
December 28, 2024 at 12:51 PM
Just let me know when this crops up. I can explain it.
December 25, 2024 at 5:10 PM
December 25, 2024 at 4:15 PM
Merry Christmas to all my #MSDyn365BC pals. I’m so glad we’ve managed to rebuild our community on Bluesky this year. You’re all fabulous.
December 25, 2024 at 10:26 AM
Lotta has a fold in her ear just now. Didn’t seem bothered. It’s been a couple of hours now and I can’t breathe.
December 24, 2024 at 2:33 PM
This glass?
December 23, 2024 at 7:00 PM
They thought quite a lot of themselves, the victorians, eh?
December 22, 2024 at 12:17 PM
Turns out bins round our way is Christmas Eve and New Year’s Eve. I’m buying a box of biscuits for the lads this year.
December 22, 2024 at 10:27 AM
Happy Christmas?
December 21, 2024 at 8:34 AM
Here you go!
December 20, 2024 at 7:56 PM
Still have mine from when I was small.
December 20, 2024 at 6:42 PM
Today’s #MSDyn365BC workplace.
December 20, 2024 at 3:57 PM