Power platform midlevel interview questions

1. Is it possible to use SharePoint as a direct data source for a Model-Driven App?

Answer:
No, it is not possible.

Model-Driven Apps in Microsoft Power Apps are built only on Microsoft Dataverse.
SharePoint Online cannot be used as a direct data source.

However, SharePoint can be integrated indirectly using Power Automate or APIs.

---

2. If a user has access to a Model-Driven record, will they automatically have access to the SharePoint file?

Answer:
No, not automatically.

• Dataverse controls record access
• SharePoint controls file access

Both have separate security models. Access must be explicitly configured or synchronized.

---

3. Can we make fields mandatory dynamically in a Model-Driven App?

Answer:
Yes, it is possible.

Using JavaScript in Microsoft Power Apps with the method:

• setRequiredLevel("required")

This allows fields to become mandatory based on runtime conditions.

---

4. What is the maximum number of records returned in a non-delegable query?

Answer:

In Canvas Apps:

• Default limit: 500 records
• Maximum configurable limit: 2000 records

This applies to non-delegable queries in Microsoft Power Apps.

---

5. Can we move a connector from Blocked to Business in DLP?

Answer:
Yes, it is possible.

In Microsoft Power Platform:

• Admin can modify the DLP policy
• Move connector from Blocked to Business

This requires appropriate admin permissions.

---

6. What is Business Process Flow (BPF)?

Answer:
A Business Process Flow is a feature in Microsoft Power Apps that:

• Guides users through predefined stages
• Enforces steps and data entry rules
• Ensures consistency in business processes

Example: Lead → Qualification → Approval → Closure

---

7. What happens if a flow violates DLP policies?

Answer:

In Microsoft Power Automate:

• The flow will fail to run
• It may be automatically turned off
• Users will see DLP violation errors

This typically happens when restricted connectors are used together.

---

8. What is the primary data source for CoE Kit?

Answer:
The primary data source is Microsoft Dataverse.

It stores governance data such as apps, flows, environments, and users.

---

9. What types of Power Apps are used in CoE Kit?

Answer:

The Power Platform Center of Excellence Starter Kit uses:

• Model-Driven Apps for administration and governance
• Canvas Apps for user-friendly interfaces

---

10. Can we install CoE Kit in a Dataverse for Teams environment?

Answer:
No, it is not supported.

Dataverse for Teams has limitations such as:

• No admin connectors
• Limited storage
• Restricted capabilities

The CoE Kit requires a full Dataverse environment.