Unanswered

plug-ins using Dataverse Accelerator (Power Fx)

(0) Share

Report

Posted on by alexy Microsoft Employee

Hello,

I have a task at hand where I'm exploring the feasibility of implementing a plugin using a low-code using Dataverse Accelerator (Power Fx).

The main objective is to prevent users from uploading files that do not conform to a predefined list of allowed file types stored in a dedicated table within Dataverse.

In simpler terms, before creating a file in the Annotation table, I need to extract the file's MIME type and verify that it exists in the list of allowed MIME types within the dedicated Dataverse table.

Do you believe this implementation is achievable through the low-code approach?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @alexy88,

Are you looking to restrict specific file types just for this table? I ask because there is a system setting to configure Blocked/Allowed MIME types, but this is applied at the environment level and not configurable per table.

That said, I don't see any specific formula limitations in low code plugins that would prevent you from performing this validation yourself.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
alexy Microsoft Employee on at

Like (0)

Report

Hi @ChrisPiasecki ,

Thank you for providing the information about Blocked/Allowed MIME types. Despite having several years of experience in the field, I was unaware of this, and I shared it with my community, who also found it to be new and valuable.

Regarding the development of a plug-in "from scratch" using Power fx to implement this functionality, it appears to involve a multi-step process. To achieve the desired outcome, I would need to:

(A) Intercept the file creation process in the Dataverse before it occurs. This step is referred to as "Pre-operation on create."

(B) Identify the MIME type of the file being created.

(C) Compare the identified MIME type with a list of allowed MIME types stored in an auxiliary table. If the MIME type matches an allowed type, proceed with storing the file in the Dataverse. If not, generate an error message to inform the user that the file type is not permitted.

This process seems more complex than simply using Power fX-based formulas, as indicated in the list provided Power Fx formula reference for Power Apps - Power Platform | Microsoft Learn.
what am I missing ?

Was this reply helpful? Yes No