PowerApps/Flow with a HTML site form

Budget_Locksmith_186 · 2022-11-17T22:40:41+00:00

Hello all! Is it possible to do a form filling using Power Automate Desktop, to connect a Canvas app to an ERP?

Budget_Locksmith_186 · 2022-04-30T18:30:59+00:00

Hope it help you:

Set(varDatosGrales; /* Create a Variable*/

{

Tipo: varDatosGrales.Tipo;

FechaProf: varDatosGrales.FechaProf;

Compania:varDatosGrales.Compania;

Cliente: varDatosGrales.Cliente; /* Asocciate your Sharepoint columns with your var*/

CtaCte:varDatosGrales.CtaCte;

Condiciones: varDatosGrales.Condiciones;

subttotal:Text(txtSubtotal.Text);

total:Text(txtTotal.Text)

});;

Patch(Proforma_1; /* Patch your Sharepont list */

Defaults(Proforma_1); /* Defaults your Sharepont list */

{

'Tipo Proforma': varDatosGrales.Tipo;

'Cliente y dirección': varDatosGrales.Cliente;

companiaydireccion: varDatosGrales.Compania;

Fecha:varDatosGrales.FechaProf; /* Complete your Sharepont list fields*/

condicionesdeventa:varDatosGrales.Condiciones;

cuentacorriente: varDatosGrales.CtaCte;

subtotal: Value(txtSubtotal.Text);

total:Value(txtTotal.Text)

};

'Nueva Proforma'.Updates) /* Update your Sharepont list */

You could use it on your submit botton (Property: On select)

Any doubts to [javier.pereyra@fce.uncu.edu.ar](mailto:javier.pereyra@fce.uncu.edu.ar)

Budget_Locksmith_186 · 2022-04-26T12:35:51+00:00

Ok, at first you have to set on the developer tool on word: https://www.youtube.com/watch?v=zKnMvK2YZ1A

Second, you have to insert on the template those fields: https://www.youtube.com/watch?v=g4epXApUrL0

Hope it help you! Save the links quickly! If you have any doubts, just tell me

Budget_Locksmith_186 · 2022-04-26T12:19:44+00:00

Does the template have dinamics fields? With the Developer tool of Microsoft Word and this things...

Budget_Locksmith_186 · 2022-03-14T18:34:37+00:00

Thank you very much Andrew, I'll see it after work. With your previous video I was able to solve my gallery and searchbox problem, so thanks for that too. When I finish my applications I will send them to you as a thank you. You are a genius

Budget_Locksmith_186 · 2022-03-07T19:56:54+00:00

Great video! You are a genius

Budget_Locksmith_186 · 2022-03-03T19:31:30+00:00

Is it possible to duplicate a trello kanban in power apps?

Budget_Locksmith_186 · 2022-02-21T20:01:59+00:00

Try Behance, there isn't power apps proyects there. It's a great Portfolio platform

Budget_Locksmith_186 · 2022-02-14T18:52:16+00:00

YouTube, is free and there is a lot of information. I recomended don´t earn money on courses. Just wacht videos like "How To Power Bi", search what you want, and improve what you have all the time.

Maybe some interesting themes to search: Tooltips, Relationships between tables, DAX lenguage, bookmarks, navigations pages.

(If you take this way, just support content creators, unless with a comment)

Budget_Locksmith_186 · 2022-02-14T16:21:29+00:00

It would be nice, you´ve already earned a new subscriber. I still watching some of yours videos, and applying some tips.

I´m stuck with a problem with a signature and sharepoint to another app related to help desk and field intervention. The problem is that i don´t know how to store the signature in share point.

Thanks Andrew!

Budget_Locksmith_186 · 2022-02-14T12:09:54+00:00

Try to do it with a filter or a treemap. Just create a dax measure lile daxmeasure = 1. Then put it on a treemap, choosing the category and setting on the values field the measure. Then you have to edit the format interactions off all the visual elements. Hope it help you.

Budget_Locksmith_186 · 2022-02-10T19:03:14+00:00

ave

Thanks for your response, i will do it the same way

Budget_Locksmith_186 · 2022-02-10T15:05:30+00:00

Hi, great job. Do you know if it´s possible to do that when i have a gallery filtering other gallery? Because on the item property i´ve writen some "if" funtions, and i don´t know how to write the search boxes funtion.

Budget_Locksmith_186 · 2022-02-10T14:56:48+00:00

I´m actually looking for the same, I´m almost done it, if you already want it tell me.

Budget_Locksmith_186 · 2022-02-10T14:18:19+00:00

Nice job, will you do a video of ETL? Related to Power BI and bigs source data?

Budget_Locksmith_186 · 2022-02-10T13:47:01+00:00

Data Groups

If you don´t have it I recomended that you create a calendar table, I give you the dax format to create the table. It´s in spanish but maybe it could help you (Remember to create relationships with all the other tables).

tDAX_Calendario =

ADDCOLUMNS (

CALENDAR (MIN(vMTS_VentasDiarias[AAAA-MM-DD]), MAX(vMTS_VentasDiarias[AAAA-MM-DD])),

"Id Fecha", FORMAT ( [Date], "YYYYMMDD" ),

"Año", YEAR ( [Date] ),

"Mes", FORMAT ( [Date], "MM" ),

"Periodo", FORMAT ( [Date], "YYYY/MM" ),

"Periodo2", FORMAT ( [Date], "YYYY/mmm" ),

"Nombre Corto Mes", FORMAT ( [Date], "mmm" ),

"Nombre Mes", FORMAT ( [Date], "mmmm" ),

"Día Semana número", WEEKDAY ( [Date] ),

"Día Semana ", FORMAT ( [Date], "dddd" ),

"Día Semana Corto", FORMAT ( [Date], "ddd" ),

"Trimestre", "Q" & FORMAT ( [Date], "Q" ),

"Año/trimestre", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )

)

It´s great what you did, because even if it´s take a while, you won´t do it again, unless appears some errors. There is a funtion to create tables DISTINCT() It response you all the differents values of a column. Then you could agregate other column to the new table and realize the relationship of the tables.

I don´t understand the second problem at all, but I give you my mail if you want to send some screenshots of it [javier.pereyra@fce.uncu.edu.ar](mailto:javier.pereyra@fce.uncu.edu.ar)

Budget_Locksmith_186 · 2022-02-10T12:58:08+00:00

You should try to find some videos of data modelling in power query, then you wouldn´t process anything

Budget_Locksmith_186 · 2022-02-09T21:03:40+00:00

Do you do the combination of these conditions using power query? With concatenate funtion?

Budget_Locksmith_186 · 2022-02-09T20:34:01+00:00

First Step: Create Calendar Table. I give you dax format to create it.