Power Automate

Demystified the Alternate Keys in Dataverse tables

When working with Dataverse, understanding Primary Keys, Primary Name Columns, and Alternate Keys is essential for designing efficient and user-friendly applications. This blog post explores the differences between these concepts, their use cases, and how alternate keys can significantly improve our workflows, especially in scenarios like external integrations and relational lookups. We will use two…

[Preview] Directly Calling SQL Server Stored Procedures in Power Apps: A Step-by-Step Guide

Power Fx now allows direct calls to SQL Server stored procedures, streamlining workflow and boosting app performance. With preview features enabled, create a new SQL connection, select stored procedures, and call them directly in Power Fx. Ensure proper access controls, consider complexity, and remember that the feature is in preview. Embrace the future of Power…

Something went wrong. Please refresh the page and/or try again.