Matthew Perren

@matnav.co.uk

#MSDyn365BC senior consultant. Reporting specialist #PowerBI #JetReports #SQL #Cosmos Professional profile of @matthewperren.bsky.social

I’m returning laptops and screens to my old employer tomorrow. My new employer has sent me a single small screen. I’m currently working with two Dell 24” monitors and my laptop (16”). Any recommendations for replacements. What are the big curved screens like? Any good?

I have a customer wanting to use the Power BI template reports for #MSDyn365BC Can anyone tell me how I can get the dates to display as UK format dates? It seems to be a very elusive setting if it exists at all!

Mate’s in the middle of a go-live and has found a weird bug They have some custom roles set up. A user has found that in one role they can create a new Project Planning Line but in another, they can’t. Error says Project Task No. Is required. Permissions are by user so what’s going on? #MSDyn365BC

I got asked to speak at a “thing” that I’ve spoken at before. I’ve spent a couple of days of personal time preparing slide decks and demo environments The organiser has been uncommunicative to put it lightly (unlike previous occasions). The agenda is out and I’m not on it I’m somewhat pissed off

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?

Start Time (Use dynamic content/Expression): Concat(formatDateTime(utcNow(),'yyyy-MM-dd'),'T17:00:00+08:00Z')
	•	End Time (Use dynamic content/Expression): Concat(if(equals(dayOfWeek(utcNow()),5),formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd'),formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')),'T07:59:59+08:00Z')

Someone on LinkedIn bigging up copilot for knowing how a MID function works in excel. Oddly enough, google knows too. Not sure what the value copilot added there but our correspondent wants us to know about it.

I have a shared diary at work. All the project managers have the right to edit. I’d like to put an approval workflow in place that requires them to ask for my permission to add or edit an entry to the diary. I’ve googled and the words “outlook” and “approval” bring up a LOT of irrelevant stuff

Client: we need a feature that does “this” Us: Builds a feature that does “this” C: Oh, it needs to also do “that” Us: Adds “that” C: Why can’t it do “x” I’m sure we asked for “x” (they did not) Us: Gives them “x” C: We’ve decided that you’ve made it too complicated and we don’t want it.

Just created a new #MSDyn365BC feed and I’m testing it out. It includes #BCALhelp and a couple of other common hashtags but I could do with a reminder of others we might commonly use. I’m testing it in a sandbox before publishing it to replace the now defunct one.

Wrote a #PowerBI dashboard for a client. The guy I wrote it for was sacked shortly after for… reasons Today I got a support ticket. The company they have hired to write the *same* dashboard (that they clearly don’t know they have) need me to explain the relations between tables in #MSDyn365BC