- Видео 162
- Просмотров 1 589 661
abm abm
Великобритания
Добавлен 22 июн 2014
Welcome to my Power Automate tutorial channel.
If you find these tutorial videos are useful please share & subscribe my channel.
Any question related to Power Automate post in Microsoft Power Automate community and tag me (@abm).
Microsoft Power Automate Community Profile
@abm
powerusers.microsoft.com/t5/user/viewprofilepage/user-id/2721
Microsoft Power Automate Community Channel
powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Twitter:
mydevexperience
Websites:
mydevexperience.wordpress.com
www.powerautomatetraining.co.uk
If you find these tutorial videos are useful please share & subscribe my channel.
Any question related to Power Automate post in Microsoft Power Automate community and tag me (@abm).
Microsoft Power Automate Community Profile
@abm
powerusers.microsoft.com/t5/user/viewprofilepage/user-id/2721
Microsoft Power Automate Community Channel
powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Twitter:
mydevexperience
Websites:
mydevexperience.wordpress.com
www.powerautomatetraining.co.uk
Power Pages - How to upload multiple Web files in power pages using power automate
This video explains how to upload multiple Web files in power pages using power automate
Просмотров: 686
Видео
Bing Maps Integration in a Model-Driven App
Просмотров 1933 месяца назад
In this video, I’ll walk you through the core concepts of integrating Bing Maps into a Model-Driven App, focusing on real-world scenarios such as displaying geographic locations stored in your Dataverse database. portal.azure.com/ learn.microsoft.com/en-gb/azure/azure-maps/how-to-manage-account-keys samples.azuremaps.com/?sample= Sample code github.com/ajbspinhope/BingMapIntegration
Power Pages - How to upload a file in SharePoint using Power Automate?
Просмотров 8153 месяца назад
This video explains how to upload a file in SharePoint using Power Automate. Sample file download github.com/ajbspinhope/Power-Pages Custom-HTML-Code-and-File-upload-JScript
Power Pages - How to customise profile link?
Просмотров 1513 месяца назад
This video explains how to customise profile link of Power Pages website.
Power Automate - How to retrieve attachments from DEVOPS work item using API?
Просмотров 6904 месяца назад
This video explains how to retrieve attachments from DEVOPS work item using API. Expressions and API endpoint I used are: /_apis/wit/workitems/{replace here your work item id}?$expand=all&api-version=7.1 last(split(outputs('Compose'),'/')) _apis/wit/attachments/{replace here attachment id}?api-version=7.1 outputs('Attachment_Details')?['$content'] base64ToBinary(outputs('Attachment_Content')) M...
Power Automate - Trello API attachment
Просмотров 3504 месяца назад
This video explains how to use Power Automate to interact with the Trello API for attaching files to a card. Power Platform Community Thread: community.powerplatform.com/forums/thread/details/?threadid=9a5c4483-356c-ef11-bfe2-000d3a9e52a3
Power Automate - How to Retrieve the Filename from a Dataverse File Data Type?
Просмотров 8844 месяца назад
This video explains how to retrieve the filename from a Dataverse file data type.
Power Pages - Liquid Validation for Dataverse inactive record or Missing query string IDs
Просмотров 1204 месяца назад
In this video, you'll learn how to use Liquid in Power Pages to validate whether a page is inactive or if a required query string ID is missing from the URL. This tutorial covers essential techniques to ensure users are redirected appropriately, improving your site's navigation and user experience. Perfect for anyone looking to enhance the reliability and security of their Power Pages.
Power Pages - Retrieve portal user documents from SharePoint and download (Power Automate & JScript)
Просмотров 4994 месяца назад
This video explains how to retrieve SharePoint documents using Power Automate and JScript. Note: Beginning of the video I started creating the flow direct from make.powerautomate.com. Later I found out that I couldn't add those flows under Power Pages. So please start creating the flow from the Power Pages Designer - Setup - Integrations - Cloud flows You can download the JScript from my github...
Power Automate - How to check MS Form file is uploaded or not via Power Automate?
Просмотров 2694 месяца назад
This video explains how to check whether the file is uploaded in MS Forms via Power Automate.
Power Automate - How to Dynamically Create a Table in an Excel File Without Column Headers?
Просмотров 6574 месяца назад
How to Dynamically Create a Table in an Excel File Without Column Headers Using Microsoft Graph API and Power Automate?
Power Pages - How to Retrieve Option Set Text and Value in Liquid?
Просмотров 4015 месяцев назад
This video demonstrates how to retrieve Dataverse option set text and value using liquid under Power Pages. I have blogged about this subject. Please visit the below link. mydevexperience.wordpress.com/2024/08/19/microsoft-power-pages-how-to-retrieve-option-set-text-and-value-in-liquid/
Power Automate - How to select one file from document library and send email?
Просмотров 5725 месяцев назад
This video explains how to select one file from a document library and send email.
Power Automate - How to resubmit all the flow runs via API?
Просмотров 4975 месяцев назад
This video explains how to resubmit all the flow runs via API. This is based on a community question: community.powerplatform.com/forums/thread/details/?threadid=25b26c9d-8d4e-ef11-a316-000d3a171baf Redirect URL global.consent.azure-apim.net/redirect Later change this value once the connector is registered. (See the video how to change the value) Authorization URL login.windows.net Resource URL...
Power Automate - How to capture SharePoint Trigger based on a particular column modification only?
Просмотров 8847 месяцев назад
This is based on a community question about how to capture SharePoint trigger based on a particular column only? powerusers.microsoft.com/t5/Building-Flows/Flow-to-be-trigger-when-status-changes/m-p/2800708#M314652 Expression used in this video. @and(not(equals(triggerOutputs()?['body/Last_x0020_Update_x0020_Status/Value'], triggerOutputs()?['body/Status/Value'])),or(equals(triggerOutputs()?['b...
Power Automate - Community Question - How to iterate files from doc library including sub-folders?
Просмотров 4877 месяцев назад
Power Automate - Community Question - How to iterate files from doc library including sub-folders?
Power Automate - How to auto increment an id when a new item is added - Community Question
Просмотров 2,2 тыс.7 месяцев назад
Power Automate - How to auto increment an id when a new item is added - Community Question
Power Automate - How to filter Excel rows and create new excel files and contents based on a filter?
Просмотров 6 тыс.7 месяцев назад
Power Automate - How to filter Excel rows and create new excel files and contents based on a filter?
Power Automate - Community Question - Read Excel Column name with special characters
Просмотров 78110 месяцев назад
Power Automate - Community Question - Read Excel Column name with special characters
Power Automate - Community Question - Metric Totals
Просмотров 86310 месяцев назад
Power Automate - Community Question - Metric Totals
Power Automate - Community Question - Read Excel sheets based on email subject
Просмотров 92511 месяцев назад
Power Automate - Community Question - Read Excel sheets based on email subject
Power Automate - Approvals without using emails - Deep Dig
Просмотров 1,2 тыс.11 месяцев назад
Power Automate - Approvals without using emails - Deep Dig
Power Automate - How to send email with category using Graph API
Просмотров 1,6 тыс.11 месяцев назад
Power Automate - How to send email with category using Graph API
Power Automate - Microsoft Forms upload documents and attach to SharePoint Document Library - Part I
Просмотров 2,7 тыс.Год назад
Power Automate - Microsoft Forms upload documents and attach to SharePoint Document Library - Part I
Power Automate - How to retrieve more than 5000 records from Dataverse?
Просмотров 2,8 тыс.Год назад
Power Automate - How to retrieve more than 5000 records from Dataverse?
Power Automate - SharePoint DateTime Null value update. New designer bug?
Просмотров 3,2 тыс.Год назад
Power Automate - SharePoint DateTime Null value update. New designer bug?
Power Automate - Community question JSON Filters
Просмотров 523Год назад
Power Automate - Community question JSON Filters
Power Automate - Community Question - SharePoint move files based on specific rules
Просмотров 2,4 тыс.Год назад
Power Automate - Community Question - SharePoint move files based on specific rules
Power Automate - Community question related to arrays
Просмотров 464Год назад
Power Automate - Community question related to arrays
Power Automate - Parse JSON Action Tips
Просмотров 6 тыс.Год назад
Power Automate - Parse JSON Action Tips
Great explanation! Thanks!
Thanks a lot abm abm. I had a major blocker and an urgent issue which got resolved.
Thanks for the useful information. Could you please do a study on creating and deleting records in bulk at once?
Thank you for this! I am also trying to put the responses in an email that gets sent out to my team. How can I add this to the email? When I try to add it, I cannot seem to add 'Output' from the dynamic content list?
Hi! I Thanks for your help. I created a similar flow, but in the last step in the Add a row into a table, I had this error message Invalid request clientRequestId: e93a3ddd-ad8e-4d8e-9a30-562a5fc930b7 serviceRequestId: 2858f444-9b79-42a5-b4b4-08e110890846"
You are the only one who properly explain this point, Thanks a lot
Great video - further question - how would you increment the numbers but re-set back to one if a new category is selected. So for example I would want A0001, A0002 etc. but then when category B is selected it would go B0001, B0002 etc.?
How to do Vlookup between when a new message is posted in teams group chat with excel table which is in one drive by using cloud workflow power automate. If lookup value matches it should post in the same teams group chat as Prod server
Hi, thank you so much for this video. I have implemented this solution and it works for attachments. However, the flow fails at the HTTP Post action with the error “unable to parse base64 encoded bytes, when I add embedded images to the email. Do you have any advice of how to resolve this error please 🙏🏾
Thank you!
how can we post version history when we create another duplicate list with items ?
I've got a thumbnail column in my SP list, it partially works, for any reason, it retrieves only few of my picture, do you have any idea why ?
That was really helpful!!
I have excel sheet in SharePoint document library and i want convert in table and i want to upload this file in SharePoint list and the previous data in SharePoint list qill be delete and new data create in SharePoint list how can do this any idea
How to use dynamic array while creating the table?
Hi, I'm referring your video and done but on last part while doing patch it's sending and error called, invalid Url and I think now version is also change can you please give updated code.
How to handle email threads ..if the customer and support team responding on the same email thread should update the work item discussion
THANK YOU VERY MUCH! I've spent 5 hours trying to figure this out, and I finally got my list to work. You are the best. !!!
What if I have another Power Automate flow that reroutes the emails to different subfolders? This flow often fails because the email is already rerouted from the inbox to another folder.
Hi Under the trigger When a new email arrives (V3) you can see Folder. Change the Folder to the subfolder you want. Thanks
@ but in my case I want it to be any and all sub folders despite the situation
Do you have WhatsApp
Check my channel about section and send me an email.
www.youtube.com/@abm4975/featured Click more then you can see view Email address.
Hello are you from India? I need to talk to you
Check my channel about section and send me an email.
@@abm4975i didn’t find the email. I‘m from Germany and I‘m looking for an Indian guy who helped me out with power automate 3-4 years ago. Are you this person?
I am not sure. Click this link www.youtube.com/@abm4975/featured Click more then you can see view Email address.
@@abm4975 this is not true. I can’t find ur email anywhere ..
This worked BEAUTIFULLY for multiple choices form but wondering how to do the same for a single field. How can I apply this to extract one value from a text field and display it in a currency format as a total?
Hi Could you please explain a bit more about your requirements? Thanks
This does not work!! I've been trying to filter MSSQL datetime for 3 days now. I've tried everything chat suggested, it gave up. I've tried your solution, it returns null. I've tried many other suggestions. My datetime includes fractional seconds. Flow doesn't consider those and will fail if they exist in the SQL data. I've even tried your trick as in date(DTMUPD) ge '2024-12-19' This returns null data set. Am I doing something wrong? Any help you can offer would be greatly appreciated.
Hi Could you please send me some screenshot of your database values and the flow you built. Check my channel about section where you can find my email. Thanks
Hi, I am getting the below error in "create file" at the flow when I try to trigger the flow manually. Could you please help me how I can resolve this error InvalidTemplate. Unable to process template language expressions in action 'Create_file' inputs at line '0' and column '0': 'The template language function 'base64ToBinary' was invoked with a parameter that is not valid. The value cannot be decoded from base64 representation.'.
The best way is to download the HTML file and the JavaScript file *exactly as is* from the link given in the description. And create the Power Automate exactly as mentioned in the video. Don't change anything. Even the titles in the steps of the flow should be the same and it will work. After it works play around to make changes as you need.
@ Thank you. I will try to do this.
@@edencanada When I try to do as is, the flow is triggering and running successful only if I have the flow till compose, but when I have create file in the flow, the flow doesn't work. Any idea on what could be the problem.
What should I do if I need to automate the date changing process in an invoice that I generate every month
Its working with date only, not with datetime. It would be great if we have a solution for that!
but still images in the attachments are showing as broken i followed all the steps
Check my channel description. There is an update. Thanks
Thanks.... for this video
Most welcome
Hi Sir this Murtuza from India I watched this video and it was really knowledgeable video But as you extracted name from email body My task is extracted 1. State 2. City 3. Channel PartnerID 4. Customer ID in loop Process -> if email arrives then check with state first if folder exist in Sharepoint Library then skip to City Extract City if city folder not exist then create new folder under that state folder then skip to channel partner id check for folder if exist then skip to customer id and if folder not exist then create customer folder under that Channel Partner folder how to achieve this sir please help me out with this
Hi Did you manage to extract the data from Email? Do you need help with SharePoint for searching folder exists or email extracting the data? Thanks
This is great. Can you please show if your email has text and then a table. I want to extract data from table where column 1 is header and column 2 has its value
Best video I have seen on using table data in powerautomate, thank you! Incredibly useful
Glad it was helpful!
thank you, this helped a lot
Glad it helped!
can I use AD app name or some identity in Editor or Author?
Using this flow I am able to send the email with attachment... But the attachment fails to open... It shows 'We can't open this file... something went wrong..." Can anyone please help
hi, do you know how to do this by week - such as from Monday to Friday
Try using addDays() expression and extend the filter.
Thanks for sharing this video. Helped me a lot.
Glad it helped
Thank for leaving code in description!
Thanks a lot for your support.
Great video, question how can I change the user that creates the Azure Dev Ops Item, example the sender of the email
Not sure you can do that. In your case you could collect the email and map under the Azure DevOPS as a custom field.
Nice and helpfull, Thx.
Thanks a lot
How to connect MS form responses download a copy in excel to connect sharepoint
Are you looking to collect the MS Form responses in an Excel sheet which is stored in SharePoint?
thanks i came into one issue, one column name is lookup type, the internal name Field=Lab_x0020_Name_x003a_Country, i try the Lab_x0020_Name_x003a_Country/Id eq 'xx' , bad request: Column 'Lab_x0020_Name_x003a_Country' does not exist. how can i fix this ? is that the bug from Sharepoint, i have no idea if it is something wrong with intern name. i checkd some videos, it said the internal name should be without space ot any special. that would make get items easily........
thanks your video, i came into one issue, one column name is lookup type, the internal name Field=Lab_x0020_Name_x003a_Country, i try the Lab_x0020_Name_x003a_Country/Ttile eq 'xx' , bad request: Column 'Lab_x0020_Name_x003a_Country' does not exist. how can i fix this ?
Hi thank you for your video. This doesn't seem to work if the choice is set to "multiple choices allowed". Is there a way to make this work for "multiple choices allowed"?
i want to create condition if amount is greater than Rp.10.000.000 auto reject and if less than Rp.10.000.000 approve. pls tell me about this. thank your sir
hi. can we have data from the attachment to be populated in the Azure DevOps Description box of Work Item?
Do you mind telling me what would be the best options for my flow: - I have a flow to save a file received from email and save them with ID number - All records of the file name and ID are saved on an excel file - I want to create a new flow with details as such: 1. Flow is manualy trigger 2. if column a say yes, it will pull information of ID and search the folder for such file id (pdf file) 3. the pdf file will be retrieve and add text based on the information of next column b and column C 4. resave file on different folder 5. mark on the same row for column D with “Yes” the file has been processed Is this flow possible with power automate and adobe add text features? I can’t try it as i dont have access for the adobe premium yet and would like to know
Hi, we have a sharepoint tenancy with over 400 subsites that contain document libraries i.e. Documents, Library n1. We are trying to block uploads of specific file types (e.g. exe, bat, ini) to the libraries. We created a flow to retrieve names of these document libraries, is there anyway to create a flow to block uploads of these file types for all subsites. As there are so many subsites, it is not feasible to create individual flows for all the subsites. Thanks for any ideas.
Hi, is it working with "sent a notification by e-mail (V3)"?
at 5:10 you print the outputs from "Join"; how can you use those values if I need to include a step in the flow to CREATE ITEM and include those values into a column with the same setup (MULTIPLE CHOICE)?
It has been very helpful. Only thing I am struggling with is how to put the recipient name in greetings.