![Power GI](/img/default-banner.jpg)
- Видео 121
- Просмотров 2 526 716
Power GI
Сальвадор
Добавлен 15 сен 2011
How to reconize Outlook hidden attachments with Power Automate | .eml | itemAttachment | Graph API
What to do if Power Automate doesn't recognize attachments?
You can also read a step-by-step tutorial in our blog: powergi.net/2024/06/18/how-to-recognize-eml-files-with-power-automate-hidden-attachments/
If you want to learn a different way to read the content of a .eml file, check out our other video: ruclips.net/video/2juupaojV0c/видео.html
URI: graph.microsoft.com /v1.0 / me / messages /
{message-id-from-trigger}/
attachments?$expand=microsoft.graph.itemattachment/item
Code for apply to each: @{body('Send_an_HTTP_request')?['value']}
Code for file name: @{first(items('Apply_to_each')?['item']?['attachments'])?['name']}
Code for file content: @{base64ToBinary(first(items('Apply_to_each')?['ite...
You can also read a step-by-step tutorial in our blog: powergi.net/2024/06/18/how-to-recognize-eml-files-with-power-automate-hidden-attachments/
If you want to learn a different way to read the content of a .eml file, check out our other video: ruclips.net/video/2juupaojV0c/видео.html
URI: graph.microsoft.com /v1.0 / me / messages /
{message-id-from-trigger}/
attachments?$expand=microsoft.graph.itemattachment/item
Code for apply to each: @{body('Send_an_HTTP_request')?['value']}
Code for file name: @{first(items('Apply_to_each')?['item']?['attachments'])?['name']}
Code for file content: @{base64ToBinary(first(items('Apply_to_each')?['ite...
Просмотров: 210
Видео
Read Excel data and download files from website | Dynamic selectors | Power Automate Desktop
Просмотров 2202 месяца назад
2 ways to upload files to SharePoint using Power Automate Desktop ruclips.net/video/gQobr4zWk4s/видео.html 0:00 - 1:28 Use case introduction 1:29 - 5:10 Record the base steps to perform for each row in the Excel file 5:11 - 9:05 Updating recorded steps to streamline and improve the desktop flow 9:06 - 9:58 Add Launch Excel actions to open Excel file 9:59 - 12:53 Read data from Excel file 12:54 ...
Get file content of nested attachments with Power Automate | Get PDF file from .eml attachment
Просмотров 3603 месяца назад
If what's shown in this video doesn't work for you, please have a look at this second approach: ruclips.net/video/fnyUaN6COic/видео.html Use Power Automtate to get PDF files from .eml email attachments. Power Fx formula used @{ base64ToBinary( first(split( replace( last(split( string(body('Send_an_HTTP_request')), 'base64')), decodeUriComponent(' '),''),' _') ) ) } You can also read this in our...
Use MySQL Views from Power Apps and Power Automate
Просмотров 5476 месяцев назад
Use MySQL Views from Power Apps and Power Automate
Solve reCAPTCHA challenge with Power Automate Desktop - no human intervention! (new version)
Просмотров 5066 месяцев назад
Learn how to use Power Automate Desktop to handle reCAPTCHA validation with NO human intervention! We use the Buster extension and Chrome to achieve this, but this solution can also be applied to Firefox and Edge. 0:00 - 1:24 Intro and solution explanation 1:24 - 3:18 Use the Recorder to capture the base steps 3:18 - 4:00 UI automation vs Web automation in Power Automate for Desktop 4:00 - 4:50...
Update connection reference for a managed solution
Просмотров 6716 месяцев назад
This video shows how to update connection references for a managed solution imported into a Prod environment.
2 ways to upload files to SharePoint using Power Automate Desktop
Просмотров 6 тыс.9 месяцев назад
Learn how to save files in SharePoint after being downloaded from the web. 0:00 - 0:30 Intro 0:31 - 1:10 Use case explanation 1:11 - 1:45 Quick set up to download file from a link 1:46 - 4:00 Get most recent file you just downloaded 4:01 - 8:05 Option 1 - You have a premium account 8:05 - 9:00 Upload the file with the same name as it was downloaded 9:01 - 12:29 Option 2 - You don't have a premi...
Center content in a Team SharePoint site
Просмотров 1,5 тыс.9 месяцев назад
Center content in a Team SharePoint site
Solve reCAPTCHA challenge with Power Automate Desktop - no human intervention!
Просмотров 2,1 тыс.Год назад
Learn how to use Power Automate Desktop to handle reCAPTCHA validation with NO human intervention! We use the Buster extension and Chrome to achieve this, but this solution can also be applied to Firefox and Edge. 0:00 - 1:24 Intro and solution explanation 1:24 - 3:18 Use the Recorder to capture the base steps 3:18 - 4:00 UI automation vs Web automation in Power Automate for Desktop 4:00 - 4:50...
Update rows in dynamic MS Excel files with Power Automate
Просмотров 9 тыс.Год назад
Learn how to WRITE rows to dynamic files here: ruclips.net/video/QHY-CqUetR8/видео.html Jump to 4:09 to see how to manage Excel actions with dynamic files. 00:00 - 0:55 Intro and use case explanation 1:13 - 4:09 Creating flow and generating base code for dynamic files 4:09 - 4:52 Peek code 4:52 - 5:53 Change the "List rows" action to use dynamic files 5:53 - 8:04 Change the "Add rows" action to...
Handle date pickers (date selectors) in Power Automate for Desktop
Просмотров 4,5 тыс.Год назад
Date pickers can work very differently depending on the web page you are interacting with! This video goes through 3 different examples of common date pickers I've seen while automating with PAD 0:00 - 0:10 Hi & Intro 0:11 - 4:23 Example 1, one date 4:25 - 7:54 Example 2, start date and end date 7:55 - 12:25 Example 3, date picker and web page URL 12:26 - 13:00 Good bye!
Add rows to dynamic MS Excel files with Power Automate
Просмотров 2,1 тыс.Год назад
Learn how to READ rows from dynamic files here: ruclips.net/video/Cm4h5_It7qo/видео.html (Disclaimer: video quality is not great!) Jump to 6:00 to see how to manage Excel action with dynamic files. 00:00 - 1:12 Intro and use case explanation 1:13 - 4:10 Creating flow and generating base code for dynamic files 4:12 - 6:00 Add steps to create a copy of template everytime the automation runs 6:00 ...
¿Cómo funciona Power Automate en realidad? - Sebastian Vallejo - Comunidad Power Platform
Просмотров 323Год назад
¿Cómo funciona Power Automate en realidad? - Sebastian Vallejo - Comunidad Power Platform
Automatiza tareas contables con Excel | Gabriel Quintanilla | Comunidad Power Platform El Salvador
Просмотров 174Год назад
Automatiza tareas contables con Excel | Gabriel Quintanilla | Comunidad Power Platform El Salvador
Conociendo DAX en Power BI | Dennis Ramírez | Comunidad Power Platform El Salvador #GPPB2023
Просмотров 140Год назад
Conociendo DAX en Power BI | Dennis Ramírez | Comunidad Power Platform El Salvador #GPPB2023
Tu primer Dashboard con Power BI | Bryan Henríquez | Comunidad Power Platform El Salvador #GPPB2023
Просмотров 168Год назад
Tu primer Dashboard con Power BI | Bryan Henríquez | Comunidad Power Platform El Salvador #GPPB2023
Generar documentos PDF desde Power Apps!
Просмотров 9 тыс.Год назад
Generar documentos PDF desde Power Apps!
Fill out MS Word templates with dynamic files using Power Automate
Просмотров 7 тыс.Год назад
Fill out MS Word templates with dynamic files using Power Automate
Power Platform: Anuncios durante Microsoft Ignite 2022 #MSIgnite #communityrocks
Просмотров 152Год назад
Power Platform: Anuncios durante Microsoft Ignite 2022 #MSIgnite #communityrocks
Resumen de la Microsoft Power Platform Conference - Septiembre 2022 #MPPC2022 #MPPC22
Просмотров 146Год назад
Resumen de la Microsoft Power Platform Conference - Septiembre 2022 #MPPC2022 #MPPC22
Nuevas funcionalidades para Power Apps - Septiembre 2022
Просмотров 269Год назад
Nuevas funcionalidades para Power Apps - Septiembre 2022
Anuncios y nuevas funcionalidades: Microsoft Power Platform Conference Sept 2022 #MPPC2022 #MPPC22
Просмотров 213Год назад
Anuncios y nuevas funcionalidades: Microsoft Power Platform Conference Sept 2022 #MPPC2022 #MPPC22
Login to website, download file and send through Email using Power Automate
Просмотров 24 тыс.2 года назад
Login to website, download file and send through Email using Power Automate
Calculate Business Hours using DAX (Working Hours in Power BI & Power Pivot - Excel)
Просмотров 15 тыс.2 года назад
Calculate Business Hours using DAX (Working Hours in Power BI & Power Pivot - Excel)
All about downloading files from the web using Power Automate for Desktop
Просмотров 34 тыс.2 года назад
All about downloading files from the web using Power Automate for Desktop
Handle empty combobox when filtering Galleries in Power Apps
Просмотров 4,6 тыс.2 года назад
Handle empty combobox when filtering Galleries in Power Apps
Embed images in emails sent from Power Automate (works for Gmail & Outlook)
Просмотров 10 тыс.2 года назад
Embed images in emails sent from Power Automate (works for Gmail & Outlook)
Inteligencia Artificial en Microsoft Power Platform (AI Builder & Power Apps) #GPPB2022
Просмотров 2,9 тыс.2 года назад
Inteligencia Artificial en Microsoft Power Platform (AI Builder & Power Apps) #GPPB2022
Automatiza tareas en Excel online con Office Scripts y Power Automate
Просмотров 8 тыс.2 года назад
Automatiza tareas en Excel online con Office Scripts y Power Automate
Brilliant! This worked perfectly, the only issue was that power query then has an error when trying to load the data table but if you open it up using excel there is nothing wrong with the file (weird). Anyway great solution and this is something I was stuck on for a while
Excellent. Regarding the second option, I have a small question: If your laptop is switch off, would PA still move your files from your local folder to the folder synced with Sharepoint? And if your laptop is switched off, would sharepoint files still sync with files in the mapped local folder ?
So awesome, I love you for this. Thank you.
I have the same problem. When the attachment is an .eml file the flow does not recognize the attachment?
Really nice video! What if we have an .eml attachment that contanis another .eml attachment that contains, finally, the .pdf?
simple the best...great idea. thank a lot - from brazil
Gracias¡¡ me has ayudado mucho con mi trabajo, y con una tarea pendiente, muy agradecido contigo
Thank you ! so much for the video. Can you make another video using client secret?
Esto funciona igual si uso dataverse? o solo se necesita usar sharepoint?
Very Helpful and Simple Your 5 mins video saved me 2 full days of research and scratching my brains :)
What if you have dynamic columns. I have a file that can come with 10 columns or max 50 columns. Is there a way to do columns dynamically as well?
Excelente ....gracias por el video..
You skipped the part where is creates duplicate plans that you never even specified
Thank you so much for this helpful video!
hi, my csv is on one column, with delimiter, can we do the same ? thanks
THANK YOU! I spent way too long trying to get this to work, you helped me fix this! Great explanation, easy to follow!
Awesome!! Ttthhhhaaannnnnkkkk you so mmmmuuuuuuccccchhhh!!
Excelente video, una consulta, si deseo descargar directo el archivo sin guardarlo, se puede?
Hi, thanks for the example! If I have 100 files with a defined variable-set of say 100 variable and each document uses different 10 of those 100 variables, can I still use the idea with that schema? What will happen to the word if there is no content in this field? Will it remove the content control in word ? Thanks for your help!
what's the same formula but for a custom column in Power BI?
Where to add networkdays formula for SLA
This is great information
Big help! Thank you. Is it possible also to have multiple key values? In your example your key value is just the email.
Hi there! Do you mean to have different columns that could have unique values?
Hola Graciela, buenas tardes, hoy voy a intentar aplicar tu enseñanza. Muchas gracias por compartir tus conocimientos, es muy importante para personas como yo, que recien estoy aprendiendo sobre Power Apps, tener este tipo de ayuda. Luego te comento como me fue. Saludos desde Argentina.
Siiii funcionó Una pregunta más. En Sharepoint el doc que envía, no lo reconoce como PDF. Alguien sabe cuál será el problema?
is it possible to format all the sheets in a book and update table name with sheet name?
Excellent. I had been searching a lot about this problem, and I finally found the solution here. Thank you very much.
hi William! Thanks a lot for your comment! Glad the video was useful!
This is excellent. Thank you so much for sharing your knowledge
not calculating correctly when the end day is different from the start.
Very useful! Thanks for the tips :)
Es un excelente video, pero cuando se realiza con imagenes grande llega en 1 sola hoja y a mitad, oshea no se aparecia completo, hay alguna forma de ajsutar la formula para adaptarse a la imagen de le agregar
very helpful thank you! <3
Thanks, you saved me hours of research!
Excelente Graciela!! Ya me parecía raro que no se pudiera 👏🏻👏🏻
Gracias por tu comentario!! Me alegro te haya servido!
Great great video.
Is there any official support saying client secret is not supported? ( in other word, only certificate is supported)
This has worked for me for over a year and last week something changed and now my first row shows the header column a and then the first column of the second row in column b
Does this work the same way with Groups Mailboxes?
very nice! I will needing this to implement in one of my PBI report
How can I update specific rows? My tables have different row names and need to be consolidated into one sheet
hola, muy buena explicación a partir de la cual yo realice una aplicación de reserva de puestos de comedor para la hora de almuerzo, pero estoy teniendo un inconveniente no se si me puedes ayudar. A pesar de que estoy realizando condicionales para que no me permita duplicar una reserva las realizo desde power apps, pero como tiene varios usuarios al mismo tiempo les permite crear varias reservas para el mismo puesto y el mismo horario.
Muy buen video, pero donde encuentro la parte 2 alguien que me lo diga por favorrr, que sin el dos estoy perdidaaaa
Hola hay alguna manera de que al nombre del archivo PDF lo tome de una variable? Gracias!!
I return to this video over and over again. Thank you!!
concat('List') to add the table name is not required in the latest Power BI. Just mentioning the Table name as List is enough.
Loads of Love and appreciation. Thank you so so so much Sensei !!
Thank you so much, this has supported me a lot😃
you are a life saver! Thank you so much
Cada que guardo un archivo PDF en sharepoint, me borra el pasado y lo remplaza por uno nuevo, en vez de crear varios PDF en la carpeta. Esto porque todos se están guardando con el mismo nombre. Saben cómo solucionar esto? :(
Thank you! I tried several methods from various sources including ChatGPT, and yours is the first one that worked!
Hi Dear, Nice one. Let us know how the power automate will auto pickup a statement or contents mentioned in the vendor's webpage after login (ex. Your Current VOIP Balance is: 20000.00 INR), then it should download the pdf or csv file from that login page , attach it in a email and write some default subject: user input + the current amount displayed, and some default message in body of the email and sent as to , cc .