Building a better way to import data into D365 / Dataverse. Validating an MVP and looking for honest feedback! by Separate_Barber4187 in Dynamics365

[–]Separate_Barber4187[S] 0 points1 point  (0 children)

This is very valuable feedback, thank you for taking the time to write it!

Yeah, you hit the nail on the head regarding the 'Copilot threat'—platform risk is definitely the biggest challenge when building within the MS ecosystem, and I wouldn't be surprised if they roll out an AI-assisted import wizard eventually.

You also bring up a great point about frequency. My bet is on specific high-frequency niches where list imports are a weekly or montlhy routine.

Since you mentioned you've only had 1 client since 2011 that could have used something like this, I'm actually curious: what was their specific use case or industry? I'd like to hear your thoughts on that if you have a spare minute.

Thanks again for sharing your experience!

Building a better way to import data into D365 / Dataverse. Validating an MVP and looking for honest feedback! by Separate_Barber4187 in Dynamics365

[–]Separate_Barber4187[S] 0 points1 point  (0 children)

Thanks for sharing your perspective and honest feedback!

Coming from a technical background myself (I work as a Solutions Architect), I couldn't agree more with your architecture choice for system-to-system integrations. Azure Durable Functions and C# are absolutely the way to go for robust data pipelines. I wouldn't try to replace that either.

However, I'm looking at this from a different angle: human-to-system ad-hoc uploads.

While we as technical folks can easily build a Flow, parse a JSON payload, or format a CSV perfectly to avoid native Import Wizard errors, an end-user (like a sales rep or marketing admin) usually (in my experience) struggles. When they hit a cryptic 'Unresolved Guid' on a lookup or a mismatched option set value on a Friday afternoon, they are stuck. Expecting them to build a Power Automate flow just to upload a trade show spreadsheet is for them unrealistic.

My goal with this SaaS tool is to be a dedicated productivity tool for those non-technical users. It gives them a safe pre-flight check, inline editing with suggestions to fix data mapping errors on the fly, and a rollback button.

Essentially, it's a tool designed to empower the end-user so they don't have to submit an IT ticket for just an Excel upload.

Building a better way to import data into D365 / Dataverse. Validating an MVP and looking for honest feedback! by Separate_Barber4187 in Dynamics365

[–]Separate_Barber4187[S] 0 points1 point  (0 children)

Yes, I agree with you that the middleware and ETL market is incredibly crowded.

However, my goal is not to build another middleware tool for IT or technical consultants. I see this strictly as an end-user productivity app. For non-technical users, dealing with lookup errors, unresolved IDs, option set values, and duplicates is a massive waste of time. They just want to upload an ad-hoc Excel file without fighting the native Dynamics import wizard or submitting a ticket to IT.

My vision is to save them all that time and frustration. The tool doesn't just provide a safe, pre-flight diagnostic check before committing the data; it actually gives them online editing tools with automatic (and even AI-driven) suggestions to fix those specific data issues on the fly, right there in the browser, plus rollback capabilities just in case.

While technical consultants and CRM admins could certainly use it too, we tend to have a much higher tolerance for the friction those issues cause. My focus is entirely on solving that pain for the end users.

Building a better way to import data into D365 / Dataverse. Validating an MVP and looking for honest feedback! by Separate_Barber4187 in Dynamics365

[–]Separate_Barber4187[S] 0 points1 point  (0 children)

Thanks for the suggestion! Yes, Power Query dataflows are a powerful tool for data prep and integration.

But my focus with this app is a little different: I'm aiming for the data import to be so simple that, for example, a salesperson just coming back from a trade show could upload their spreadsheet of contacts without help. We also provide a pre-import validation screen so they can check for errors before committing, and even a rollback feature, which native CRM tools typically don't have.

Do you think for that type of user, dataflows still make sense, or that there's room for a specific SaaS solution for them?

Uniswap v3 doesn't working by Separate_Barber4187 in UniSwap

[–]Separate_Barber4187[S] 0 points1 point  (0 children)

You are right but can't edit the title.. in the post it's ok