PowerApps - New learnings

 In Canvas apps, App ->Onstart like we have Formulas 

fxTabs = [] 

you can use this variable with in the app.

------------------------------------------------------------

Create a Solution in an environment, add a publisher, which is a unique to all the artifacts that are stored in the solution.

From Solution, Go to table, choose table, it will give options to create table, import 

import tabs of excel 

--------------------------------

1) Built generative pages in PowerApps using dataverse & sharepoint.
https://www.youtube.com/watch?v=sdRlLcHPK8g&list=PLTyFh-qDKAiHr7HwkvlHXpCNf73xNBqj_&index=4 

Create dataverse table

Create App model driven app

Describe by page

Build me a page using the design attached-  the data context should come from 

(provide table name) under add data. Eg: Event

Add design.png 

Click Generate.

Based on the context, app agent generate react page.

from My Events table.

Search for events functionality, filter based on confirences

Pulish the model driven power app and play it.

When read more is clicked, open a dialog and show details of the event.

Ask agent in left pane, 
When read more is clicked - Open a dialog show full details about the event. Also add options on top right of screen for user to add new event and edit an existing event that they selct in the gallery. The add/edit form should fly in from left to right of the screen.

Click on agent thoughts, to understand better.

Gen pages only work for dataverse currently

however, data in SharePoint or Sql table for example. I want to buld a gen page using this data.

Option1: Use dataflows where I can bring data in to the dataverse.

Option2:

I have Product Catalog List in sharepoint.

Create Dataverse table that should understand this SP list.

Create a Virtual table:

 A virtual table is one where the data lives in your data source like SharePoint, SQL, Azure databricks, Snowflake, Microsoft fabric, Salesforce, Oracle , PostgreSQL

It will create the schema. It will query your underlying data source to bring the data.

Lets try with SharePoint

Put SP URL and select List

Config screen, Update the schema name and map the columns.

Finish.

it will create a virtual table.

We can do full crud operations.

Table we can see.

From table, create an App, lets magic begin.

Product Catalog App based on virtual table.
Gen page we can create inside of the app based on design of png.

Give context, Attach design, add data ->table name, click generate.

React based page will get created.

How to show generative page in Modern sharepoint site?

In a SP site, go to site page with modern page.

Create a Page, name it
Add webpart, Add Embed 
add iframe code

appid means url of model driven app

Width and height

It will say embedding content is not allowed.

Settings->View all site settings

add iframe url

Now we can go back to page, try it.

Publish

------------------------------------------------------

Building Model-Driven Power Apps the Modern Way (2025 Tutorial)

https://www.youtube.com/watch?v=S3WVKpNWp2c&list=PLTyFh-qDKAiHr7HwkvlHXpCNf73xNBqj_&index=2

Modern way to create model driven apps

Out of the box app experience connected to views forms of the table

, create custom page.

Adding app components such as forms, view, dashboards, that are built in data verse using app designer tool.

Data model is important thing in Model driven app.

Tables->new Tables->advanced options(Classic way)

Modern option->

Copilot, Import, From blank

Copilot-> I need tables for tracking products and product related feedback.

Generate.

AI sugessted Product table and Product Feedback table

We can add more column manually or copilot.

Product column is a lookup in Product feedback table

Save and Exit

Tables, relatoinships, sample data will be created.

Product table and Product feedback we can see

Product table->Data experience section

Forms, View, Chats, dashboards

Create an app->

We can see app created in classic mode with Active products with pages.

Add new page->with Datavese table

It will ask table names to choose ->Product feedback table with product feedback page.

We also another option->Describe new page

I need an expense reporting solution for my team.

Agent will help for requirement agent, Process agent for business process, Data agent for data model and Solution agent for application support

It starts defining read it about everything.

Data model it will create in dataverse workspace.

Business problem it will show with description read it.

Requirement agent about requirements

Process agent about business problem

Data agent about data model with table and relationships

3 related tables

Solution agent->recommen solution about project

Task manager center

we can see standard view and form experience with pages.

Map relationships also we can see with associated tasks.

In app agent also available for end users.

Users can asks questions against the data

show me all the hight prority projects.

Data exporation agent will help here.

Visualize the data button -> data visualization agent helps.

In app agents 

Can we build canvas like experiences in Model driven apps?

With model driven apps design is based on components of the app.

More customzied expericence can be achived by build react based pages in PowerApps. which is knows as "Generative pages"

Tasks is the page below screenshow which has tasks that are assigned based on current loggedin users.

above screenshot is task board page.

We can filter based on projects, filter based on specific user
We can move tasks between swim lanes

As we move swim lane task is updated

Calendar view of task

click on event, color coded based on tasks status

Projects & tasks view page

open specific page, click on any item it will expand and collapse fashion with grid and count show number of tasks

Able to edit the task

Dashboard experience

Tasks by priority 

Lets get headover to "Tasks assigned to me" page in model driven app which we created.

Descirb you page, conect table

Descirbe 

App agent understand scheme and request and implement by agenet.

we have option to edit the code and manaully make updates to react code.

create new page->Descibe the page->
Project table, Prodive descirption, 
Build a page that showcases project data in card style and provide options for user to search for projects.

App agents starts generating.

---------------------------------------------------

AI agents in PowerApps. Changing the way users intract with Business apps.

https://www.youtube.com/watch?v=za94pbtrafo

---------------------------------------------------

https://www.youtube.com/watch?v=4_pN9jHaNUQ&t=343s

Get Items - 

to query sp list items

select sp site, sp list

Filter Query:

Use OData query operations in SharePoint REST requests [https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests]

Priority which is choice column. 
Priority eq 'Critical' 

add an action

Compose->

get items actions body of content print and save it.

we can total items count.

add another filter now.

Priority eq 'Critical'  and Progress ne 'Completed'

now this Filter Query can get help with AI.

Manaully trigger a flow action has parameter to add Text.

add it.

This is used for user to add describe what they want filter query

Add Get items query and rename it as "Get List Schema"

/_pai/web/lists/getbytitle('listname')/Fields

While test this flow, run the flow 
it will automatically ask to describe your secnario

enter test and run it.

Show raw outputs, we can see entire fields, raw data entire schema of the list

Now add another action.

Under AI capabilities->

Run a Prompt

Create a new prompt

It is run on LLM GPT

we can also add custom models.

Now add instruction (Get started with copilot)

You are tasked with generating an OData filter query for SharePoint based on a given list schema definition.

Submit it

Copilot will give some instrcutions, we can select keep it if we fine with it.

we can add some inputs here to the instructions

### Inputs:

SharePoint list schema definition:

here once we do test run, we can see scheme of sample body copy it and paste it.

We can also test it prompt itself on top right corner.

OData query logic to be peformed.

add text of priority filter etc..

[Me] in query prompt under ###Instructions add one more line as "Me is user email. <CurrentUserEmail> as input pass any test email.

Today's Date is <TodayDate>

it will follow standard OData synta

we can add inputs dynamically

Text Input

rename it as schema

Tex input rename it as Query

### Output Format:

Only provide the OData filter query as a plain text string.

Rename the prompt as "OData query generate"

Run it, it will ask few prompts input values

----------------------------------------------

https://www.youtube.com/watch?v=jnV7h-0bu7o&t=23s

1) App builder:

with Copilot, no connector, no powerapp studio, just Natural Langauge.

M365 copilot page, we have App Builder (Frontier program)

We can simply describe.

Users need M365 copilot license.

Creators of this app and users who shares with needs copilot license.

App builder agent (frontier)

Suppose if I type "Build an app where people can submit ideas. It should capture idea title, description, impact, and let others vote on the idea" a simple app.

App builder starts creating...

In action it shows coding..

All data stored in SP site

IdeaForge named

It can show us Idea with title, desc, vote button

We can share this app with in our org.

2) Low code:

Makers choice

using PowerApps studio

Connector eco system

Dataverse, SP, SQL

make.powerapps.com

Context of solutions, ALM, env, 

Lets make a plan is the interface

Agents starts like

Requirement agents, lists down required things

Data agent, frame data model and flexible to change columns, add, remove, create relationships etc..

Technology agent

objects like model driven app, canvas apps, agents, pages are recommendation it will deal

Which object I will like to use by technology agent, we can choose like between Canvas, model, pages.

Canvas has selected..

We can modify the app as we want.

Similary We have model driven powerapp with modern form, view and dashboard expere with full crud support.

In model driven app we have vibe coding experience that is through gen pages.

we have to add a page inside model driven app, we can add new page

We have describe a page option.

It is a react page.

Attach image, Add context like claim table, 
"Build a model gallery page for claims. Color code the items based on the claim status."

App agent will be build a page.

which is react page.

To make changes, we can type in to the agent.

"add option for user to create a new claim, edit existing claims or delete a claim. The claim form should flyout from the right"

We also get access to the code.

We can make edits to the code.

Compare the code with prev version this another option for developers.

3)Vibe Code:

Makers/Developer:

vibe.powerapps.com

Gen pages in model apps.

it allows to build a full stack app.

Dataverse, It is not canvas or model app it is a vibe app

In make.powerapp.com, we have option for new experience which is named as vibe.powerapps.com

Try now

It is brand new experience to create applications

Enterprise scale,

Full stack,

App built on solution context and environment supported.

4 agents will work to start creating the app.

Requirement agent

Data agent

Code agent

Solution agent

data model, customizable by us, code agent build full stack react app.

solution agent analysis business logic uses help generate design of the app.

Plan, Data model, Technology 

"Protfolio Overview app".

We can explore the code, design.md, src->assets, react components, pages etc..

We can save app, publish in dataverse with in our environment. with prefered solution.

We can share to our users.

Context of env, go to apps, which is code type app.

3) Pro Code:

If we want beyod full stock with our own code, own controls with react with IDE of visual studio code of choice, leaverage power platform connector eco system and then  deploy as a codeapp in power platform eco system.

prerequisites:

we can run it locally in vs code, data source is SP list, we can run and check in locally.

we can do changes in code updates, styles of the table changed, we can  run again.

pac code run

pac code push

push means, 

In Power Platform admin center, we can seee Inventory tab.

Which is Maker Inventory.

We can filter App  Builder Apps,

Canvas app, Code apps.

------------------------------------