u/nanoki94

In my company, I’m pretty locked down when it comes to access rights.

Right now, I can only use canvas apps. I can’t use code apps or vibe.

My need is to create an app that lets employees place orders for office supplies, which would then feed a SharePoint list and a Power BI dashboard to track the status of each order.

The app would also include an attachment viewer and allow users to upload attachments. It would function like a mini e-commerce site, with a list of items and a shopping cart.

Is it worth building the whole thing in canvas?

Hi everyone,

I’m working on a Power BI app that tracks subcontracting spend in my company.

Right now the data is stored in SharePoint lists. It was fine at the beginning because it was easy to set up and people could edit the data directly, but we’re now getting close to 5000 rows and SP is starting to feel like the wrong tool for this.

The main issue is the item threshold, especially when users need to edit the list in grid view or maintain the data manually. I know SP can technically handle more than 5k rows with indexed columns and filtered views, but I’m not sure I want to build a business app on top of that long term.

The app is used to track things like committed amounts, dates, subcontracting work, projects, and budget follow-up. The data needs to be editable by users or admins, then consumed in Power BI Service for reporting.

We are already in a Microsoft environment: M365, Power BI Service and Fabric.

So I’m wondering what would be the best next step if we want something more robust than SP, but still Microsoft-native.

I’m considering Dataverse, Azure SQL, Fabric Warehouse/Lakehouse, or maybe something else I’m missing.
For this kind of use case, where the data needs to be edited by business users and then reported in Power BI, what would you recommend?
Would you go with Dataverse + Power Apps? Azure SQL with some kind of front-end? Fabric? Or would you still keep Sharepoint and just handle the threshold properly?
Curious to hear from people who had a similar setup and eventually moved away from Sharepoint lists.

Hello

Question sans jugement

Je lis souvent que le cabinet comptable c’est assez dur : charge de travail, périodes fiscales, clients qui envoient tout au dernier moment, outils pas toujours pratiques, pression des délais…..

Mais j’aimerais avoir des retours un peu plus concrets de personnes qui y travaillent ou qui y ont travaillé.

Quand on dit que c’est “l’enfer” ou que beaucoup finissent par partir, c’est quoi exactement le plus pénible au quotidien ?

Et à l’inverse, est-ce qu’il y en a ici qui aiment vraiment le cabinet ?

Si oui, qu’est-ce qui rend le métier intéressant malgré tout ?

Je pose la question pour comprendre la réalité du terrain derrière les clichés. J’ai l’impression qu’il y a un gros écart entre l’image extérieure du métier et ce que vivent vraiment les comptables au quotidien.

Curieux de lire vos retours, surtout les trucs très concrets du quotidien qu’on ne voit pas forcément de l’extérieur.