web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :

Transform any code to PowerFx with Copilot

SpongYe Profile Picture Posted by SpongYe 5,616 Super User 2025 Season 2

Introduction

Efficiency is key. PowerFx, the powerful formula language for Microsoft Power Platform, has revolutionized the way we approach coding. But what if you could elevate that efficiency even further? Enter Copilot, your coding companion that translates any code into PowerFx, ensuring you code smarter, not harder.

 

I created a Canvas app to demo and enter the code and then show the results.

Here are some examples of the code translation:

 

PHP example 1:

 

 

$cars = array("Volvo", "BMW", "Toyota");
echo count($cars);

 

 

In the app:

SpongYe_1-1718226907606.png

Results:

SpongYe_2-1718226975868.png

 

PHP example 2:

 

$favcolor = "red";
switch ($favcolor) {
 case "red":
 echo "Your favorite color is red!";
 break;
 case "blue":
 echo "Your favorite color is blue!";
 break;
 case "green":
 echo "Your favorite color is green!";
 break;
 default:
 echo "Your favorite color is neither red, blue, nor green!";
}

 

In app:

SpongYe_4-1718227057514.png

 

Results:

SpongYe_3-1718227046041.png

 

Python example 1: 

 

x = 5
print(type(x))

 

In app:

SpongYe_5-1718227252758.png

Results:

SpongYe_6-1718227350660.png

 

Python example 2: 

 

["apple", "banana", "cherry"]
print(len(thislist))

 

In app:

SpongYe_7-1718228715259.png

Results:

SpongYe_8-1718228760290.png

 

AI prompt:

I created a AI prompt to give an answer to transform the given input code.

The prompt has 2 input parametes: the code type and the code itself. 

SpongYe_9-1718228837594.png

 

Conclusion

PowerFx with Copilot represents a significant leap forward in app development. By bridging the gap between different coding languages and PowerFx, Copilot ensures that your coding journey is as efficient and effective as possible. Embrace the power of Copilot and transform the way you code with PowerFx.

Categories:

AI Builder topics Canvas Apps Copilot

Comments