Power GI
Power GI
  • Видео 121
  • Просмотров 2 526 716
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...
Просмотров: 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
Power Apps Components
Просмотров 224Год назад
Power Apps Components
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

Комментарии

  • @stormengelbrecht1995
    @stormengelbrecht1995 2 часа назад

    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

  • @Chris-tj4es
    @Chris-tj4es 2 дня назад

    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 ?

  • @adammorra3813
    @adammorra3813 3 дня назад

    So awesome, I love you for this. Thank you.

  • @rorydunbar5881
    @rorydunbar5881 4 дня назад

    I have the same problem. When the attachment is an .eml file the flow does not recognize the attachment?

  • @emanueledelzoppo5164
    @emanueledelzoppo5164 8 дней назад

    Really nice video! What if we have an .eml attachment that contanis another .eml attachment that contains, finally, the .pdf?

  • @RodrigoMartinsSilva44
    @RodrigoMartinsSilva44 10 дней назад

    simple the best...great idea. thank a lot - from brazil

  • @alfonsomorales9233
    @alfonsomorales9233 10 дней назад

    Gracias¡¡ me has ayudado mucho con mi trabajo, y con una tarea pendiente, muy agradecido contigo

  • @jojiparayidathilcherian9792
    @jojiparayidathilcherian9792 11 дней назад

    Thank you ! so much for the video. Can you make another video using client secret?

  • @sergiogalarzalopez5288
    @sergiogalarzalopez5288 11 дней назад

    Esto funciona igual si uso dataverse? o solo se necesita usar sharepoint?

  • @sreenivas651
    @sreenivas651 24 дня назад

    Very Helpful and Simple Your 5 mins video saved me 2 full days of research and scratching my brains :)

  • @erinann7833
    @erinann7833 25 дней назад

    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?

  • @ricardocontreras
    @ricardocontreras 26 дней назад

    Excelente ....gracias por el video..

  • @deedeebojack6042
    @deedeebojack6042 27 дней назад

    You skipped the part where is creates duplicate plans that you never even specified

  • @gosiaciszewska7085
    @gosiaciszewska7085 Месяц назад

    Thank you so much for this helpful video!

  • @gregoirepesenti
    @gregoirepesenti Месяц назад

    hi, my csv is on one column, with delimiter, can we do the same ? thanks

  • @ecooney007
    @ecooney007 Месяц назад

    THANK YOU! I spent way too long trying to get this to work, you helped me fix this! Great explanation, easy to follow!

  • @recliner_36
    @recliner_36 Месяц назад

    Awesome!! Ttthhhhaaannnnnkkkk you so mmmmuuuuuuccccchhhh!!

  • @hugoxoft
    @hugoxoft 2 месяца назад

    Excelente video, una consulta, si deseo descargar directo el archivo sin guardarlo, se puede?

  • @jonaskoniger3337
    @jonaskoniger3337 2 месяца назад

    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!

  • @EmileSteenkamp-v6o
    @EmileSteenkamp-v6o 2 месяца назад

    what's the same formula but for a custom column in Power BI?

  • @srinidhistiwari8507
    @srinidhistiwari8507 2 месяца назад

    Where to add networkdays formula for SLA

  • @triforceofmelody7397
    @triforceofmelody7397 2 месяца назад

    This is great information

  • @jennusi8317
    @jennusi8317 2 месяца назад

    Big help! Thank you. Is it possible also to have multiple key values? In your example your key value is just the email.

    • @PowerGI
      @PowerGI 2 месяца назад

      Hi there! Do you mean to have different columns that could have unique values?

  • @juanactis2991
    @juanactis2991 2 месяца назад

    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.

    • @juanactis2991
      @juanactis2991 2 месяца назад

      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?

  • @ugandhar115
    @ugandhar115 2 месяца назад

    is it possible to format all the sheets in a book and update table name with sheet name?

  • @Iam_Will
    @Iam_Will 2 месяца назад

    Excellent. I had been searching a lot about this problem, and I finally found the solution here. Thank you very much.

    • @PowerGI
      @PowerGI 2 месяца назад

      hi William! Thanks a lot for your comment! Glad the video was useful!

  • @paulskelton8799
    @paulskelton8799 2 месяца назад

    This is excellent. Thank you so much for sharing your knowledge

  • @KnightFM-Ops
    @KnightFM-Ops 2 месяца назад

    not calculating correctly when the end day is different from the start.

  • @c.mdsalih
    @c.mdsalih 3 месяца назад

    Very useful! Thanks for the tips :)

  • @BreidyOsorioLondono
    @BreidyOsorioLondono 3 месяца назад

    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

  • @xolaniceeyah3589
    @xolaniceeyah3589 3 месяца назад

    very helpful thank you! <3

  • @oyindaadedoyin2535
    @oyindaadedoyin2535 3 месяца назад

    Thanks, you saved me hours of research!

  • @migesualdo
    @migesualdo 3 месяца назад

    Excelente Graciela!! Ya me parecía raro que no se pudiera 👏🏻👏🏻

    • @PowerGI
      @PowerGI 3 месяца назад

      Gracias por tu comentario!! Me alegro te haya servido!

  • @headmaster10231
    @headmaster10231 3 месяца назад

    Great great video.

  • @legendgod
    @legendgod 3 месяца назад

    Is there any official support saying client secret is not supported? ( in other word, only certificate is supported)

  • @LucasDoseck
    @LucasDoseck 3 месяца назад

    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

  • @flytyme
    @flytyme 4 месяца назад

    Does this work the same way with Groups Mailboxes?

  • @user-kd6hl4hj6z
    @user-kd6hl4hj6z 4 месяца назад

    very nice! I will needing this to implement in one of my PBI report

  • @noodlebrains
    @noodlebrains 4 месяца назад

    How can I update specific rows? My tables have different row names and need to be consolidated into one sheet

  • @cev626
    @cev626 4 месяца назад

    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.

  • @greisvillenamateo8506
    @greisvillenamateo8506 4 месяца назад

    Muy buen video, pero donde encuentro la parte 2 alguien que me lo diga por favorrr, que sin el dos estoy perdidaaaa

  • @albertomatar4860
    @albertomatar4860 4 месяца назад

    Hola hay alguna manera de que al nombre del archivo PDF lo tome de una variable? Gracias!!

  • @ssccservlearn
    @ssccservlearn 4 месяца назад

    I return to this video over and over again. Thank you!!

  • @krishnakumarchidambaram2581
    @krishnakumarchidambaram2581 4 месяца назад

    concat('List') to add the table name is not required in the latest Power BI. Just mentioning the Table name as List is enough.

  • @sampheonix
    @sampheonix 4 месяца назад

    Loads of Love and appreciation. Thank you so so so much Sensei !!

  • @ahmedbenyahia6853
    @ahmedbenyahia6853 4 месяца назад

    Thank you so much, this has supported me a lot😃

  • @vc5940
    @vc5940 4 месяца назад

    you are a life saver! Thank you so much

  • @carlomendozamartinez1512
    @carlomendozamartinez1512 4 месяца назад

    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? :(

  • @michaelclemens7643
    @michaelclemens7643 4 месяца назад

    Thank you! I tried several methods from various sources including ChatGPT, and yours is the first one that worked!

  • @seekhoaursikhao4046
    @seekhoaursikhao4046 4 месяца назад

    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 .