- Видео 174
- Просмотров 1 185 931
Andrew Hess
США
Добавлен 2 авг 2020
I am a Governmental Power Platform Developer and have worked in multiple different levels of the Government located in the USA. Currently I am sharing my knowledge with the Power Platform, with PowerApps and Power Automate and much more. As we dive into other topics I love to create videos because it helps me retain knowledge and I get to share it with all of you! I love when others ask questions, that's how my channel started. So please feel free, ask a question and get a video!
My name is Andrew Hess I am a Microsoft Certified Professional and I can't wait to meet you!
My name is Andrew Hess I am a Microsoft Certified Professional and I can't wait to meet you!
Send files with Power Apps V2 Trigger to Power Automate and Beyond!
There were 2 previous videos before this one about the V2 Trigger:
ruclips.net/video/GQOLW7G16OI/видео.html
ruclips.net/video/MLVJx8ejbBQ/видео.html
In this tutorial, we'll show you how to use Power Automate to move files from a Power Apps attachment control directly into SharePoint or add them as attachments in Outlook. This step-by-step guide will cover setting up the flow, configuring triggers, and creating a seamless link between Power Apps and other platforms. Perfect for enhancing productivity and automating file management in your Power Platform solutions!
Formula:
WeWillUseThisTitle.Run(
TextCanvas1.Text,
{
file: {
contentBytes: Last(myFile.Attachments).Value,
name: Last(myFile.Attachm...
ruclips.net/video/GQOLW7G16OI/видео.html
ruclips.net/video/MLVJx8ejbBQ/видео.html
In this tutorial, we'll show you how to use Power Automate to move files from a Power Apps attachment control directly into SharePoint or add them as attachments in Outlook. This step-by-step guide will cover setting up the flow, configuring triggers, and creating a seamless link between Power Apps and other platforms. Perfect for enhancing productivity and automating file management in your Power Platform solutions!
Formula:
WeWillUseThisTitle.Run(
TextCanvas1.Text,
{
file: {
contentBytes: Last(myFile.Attachments).Value,
name: Last(myFile.Attachm...
Просмотров: 450
Видео
Power Apps V2 Trigger (When Power Apps calls a flow V2)
Просмотров 938День назад
Let's take an even deeper dive into the Power Apps V2 Trigger! Here is last weeks video: ruclips.net/video/MLVJx8ejbBQ/видео.html The "When Power Apps calls a flow (V2)" trigger in Power Automate is a powerful feature that enhances the flexibility of app-building within Microsoft’s Power Platform. This trigger allows you to seamlessly initiate a Power Automate flow directly from a Power Apps ap...
Power Apps V2 Trigger More than 20 Fields
Просмотров 1,1 тыс.14 дней назад
Hey everyone! 👋 Today, we’re tackling a PowerApps limitation that many of us have faced: the 20-field limit in the V2 trigger! If you've tried passing more than 20 fields to Power Automate, you know it can be a real roadblock! But there’s a simple workaround: we’re going to pass our data as JSON! By converting your collection into JSON, we can bypass that limit and send as much data as we need....
Customizing the JSON of the SharePoint Gantt Chart (Project Management)
Просмотров 82821 день назад
It's time for part three! First we added the Gantt Chart to a SharePoint list. Then we overlaid Power Apps on top of the Gantt. Now it is time to customize the Gantt's JSON. Let's get into it! In this video, we dive into customizing the JSON of a SharePoint Gantt chart to create a visually compelling and functional project view. Learn how to use JSON to style task the bars, adjust color schemes...
Power Apps Integrated with a SharePoint Gantt Chart
Просмотров 1,6 тыс.Месяц назад
Today we have a continuation of the custom JSON Gantt Chart in SharePoint. We will create a Power App that defaults Project Start and Project End. There are couple more adjustments like hiding TaskStart on a Milestone and changing progress into a progress bar. All of these customizations are just a start, I'm sure you could come up with more! Link to Part1: ruclips.net/video/qrH3bGq0YQ4/видео.h...
Turning a SharePoint List into a Gantt Chart
Просмотров 2,2 тыс.Месяц назад
Hey everyone! 👋 In today’s video, we'll be walking through how to implement a JSON provided by Geert de Kooter into a SharePoint list. Along the way, we’ll cover some key tips and changes to watch out for. This is part 1 of a 2-part series, so make sure to stay tuned for video #2, where we’ll be integrating Power Apps! I'm super excited about this one! Don't forget to subscribe and hit the noti...
Using Ungroup for Flattening your Data Source in Power Apps (Data Manipulation)
Просмотров 547Месяц назад
Last week we made a video based on Flattening your dataset and we used ForAll, and after a realization maybe it's better to use Ungroup. Here is last weeks video: ruclips.net/video/244WMVLuZck/видео.html Ungroup may be a better alternative, but in my opinion learning both is the most important! Discover a simple method to ungroup a multi-select field in SharePoint! In this tutorial, we break do...
Flattening a Data source in Power Apps (Data Manipulation)
Просмотров 1,2 тыс.Месяц назад
From a user request we are going to flatten out a data source in Power Apps. Formulas are in the description below! Learn how to flatten a table in Power Apps by transforming multi-choice fields into separate rows for each selection. This quick tutorial will show you how to restructure your data to create a more simplified and accessible format, perfect for reporting and analysis. Whether you'r...
Creating a Responsive Gallery in the Thumb Friendly Zone
Просмотров 5422 месяца назад
When designing responsive Power Apps, it's important to consider the thumb-friendly zone-the area on a mobile screen that's easiest for users to reach with their thumb. Now you do want to think about right-handed, left-handed, or if both hands will be used for your application. Sadly right now I normally create apps for right handed people, but maybe this is something you want to do different t...
Create Brand New Excel File Based on Gallery Selection in Power Apps
Просмотров 1,8 тыс.2 месяца назад
Ever need a brand new Excel file or .csv from a selection in Power Apps. In this tutorial, we will show you how to create an Excel file directly from a Gallery selection in Power Apps! Learn how to capture data from your app's gallery and export it into a neatly formatted Excel file with just a few clicks. This step-by-step guide is perfect for anyone looking to improve their app's functionalit...
How to create a Collection from your Selection in Power Apps
Просмотров 2,5 тыс.2 месяца назад
In Power Apps, creating a collection based on a selection allows you to store and manipulate a set of items chosen by the user. This is typically done by using the Collect() function in response to an event, such as selecting an item in a gallery or selecting multiple items in a gallery. This can be extremely useful when you want to manipulate or view certain data. There are some extremely usef...
Extract Data from PDFs with Azure Document Intelligence & Power Automate - No Premium Licenses
Просмотров 3,4 тыс.2 месяца назад
Hi All, Today we are using Azure Document Intelligence to read PDF data and extract the data into a SharePoint list. This video is EXTREMELY valuable! The best thing in my opinion you can do with AI is increase productivity. Today we are going to do exactly that. In this video, we explore how to leverage Azure's Document Intelligence to extract data using a custom model tailored to your unique ...
Create a Power App with 3 Screen Templates (Beginner Tutorial)
Просмотров 1,2 тыс.3 месяца назад
This is a beginners tutorial of how to create a responsive Power Apps in under 30 minutes. The app is completely responsive and uses 3 templates provided to us from Microsoft. Most basic Power Apps that are created follow a 3 screen method using Microsoft Responsive Templates. The most common screens are: 1. Home 2. Gallery/Table 3. Form We start of creating a responsive Form using a template. ...
How to Easily Create a Left Side Navigation in Power Apps
Просмотров 1,2 тыс.3 месяца назад
Hi All welcome back this is the 3rd video creating this Power App! The links to the entire app creation are below. Creating a left side navigation in Power Apps using a gallery involves adding a gallery control to your app and setting it to a vertical layout. You can populate the gallery's Items property with a table that includes the navigation options. This approach allows you to easily manag...
Create News Posts with Power Automate and SharePoint Automagically
Просмотров 1,7 тыс.3 месяца назад
Create News Posts with Power Automate and SharePoint Automagically
Emailing Gallery Selections in Power Apps with an Email Template
Просмотров 1,5 тыс.3 месяца назад
Emailing Gallery Selections in Power Apps with an Email Template
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
Просмотров 9954 месяца назад
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
Write your Other Choice in a Combo box with Power Apps
Просмотров 2,1 тыс.4 месяца назад
Write your Other Choice in a Combo box with Power Apps
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
Просмотров 2,7 тыс.4 месяца назад
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
Просмотров 4274 месяца назад
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
Simple Leave Request App for Teams | Power Apps or List Form
Просмотров 8 тыс.4 месяца назад
Simple Leave Request App for Teams | Power Apps or List Form
ChatGPT Whisper with Power Automate (Voice to Text)
Просмотров 1,1 тыс.5 месяцев назад
ChatGPT Whisper with Power Automate (Voice to Text)
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
Просмотров 7265 месяцев назад
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
Use ChatGPT-4o Vision on Images with Power Automate
Просмотров 1,5 тыс.5 месяцев назад
Use ChatGPT-4o Vision on Images with Power Automate
Custom Connector Power Automate & Chat-GPT Images using Dall-E
Просмотров 7605 месяцев назад
Custom Connector Power Automate & Chat-GPT Images using Dall-E
Connect Power Automate & ChatGPT-4o with Custom Connector
Просмотров 6 тыс.6 месяцев назад
Connect Power Automate & ChatGPT-4o with Custom Connector
Wait! Solve Delegation Easily! In Power Apps Search
Просмотров 9 тыс.6 месяцев назад
Wait! Solve Delegation Easily! In Power Apps Search
Making Containers work for You in Power Apps - Managing Layout and Consistency
Просмотров 3,1 тыс.6 месяцев назад
Making Containers work for You in Power Apps - Managing Layout and Consistency
Convert Default Form to Custom Form in Power Apps - Defaults, DefaultSelectedItems, and More!
Просмотров 2,3 тыс.6 месяцев назад
Convert Default Form to Custom Form in Power Apps - Defaults, DefaultSelectedItems, and More!
Creating an Edit Form and Fixing Defaults in Power Apps
Просмотров 8 тыс.7 месяцев назад
Creating an Edit Form and Fixing Defaults in Power Apps
My flow seems to be failing at the 'Parse JSON' step. Are there specific parameters that need to be included with that JSON? I was struggling to extract a sample structure from the test run described in the step before, so if I can understand the required JSON format I could rather just type it up myself and plug it in manually. Thanks for the video though.
Thank you for good tutorial, why in my excel the date is 1 hour before? Thank
I am a beginner in power apps and I liked you tutorials 1 & 2 and I have a question. If I make a new list I can make one based on an existing list, is it possible to import the power app form I made in the first list to the second list or do I have to make the form allover again.
Is it possible to create a customised chat bot using this powerapps ?
I have one doubt, Is there any restrictions on applying multiple filters like 4 to 5. Is there constraints in using the 'In' operator while embedding the Report URL inside power apps Tile URL property?
Thank you for this. Could you possibly make a video on how to export to excel? using the new flow?
There have been a few requests using Excel. So I should make one in the future.
Data not showing up: Office365Users.SearchUser({searchTerm:ComboBox1.SearchText,top:10})
Thanks, very useful, I ask but can the Word template be a shared template?😊
This is perfect for what I am trying to do! Thank you! One question/problem... I am doing this with an invoice and I need the invoice total. Since it is a dollar amount, I am getting an error when I get to the last step (Updating SharePoint file properties). The error is "Input parameter 'item/AmountDue' is required to be of type 'Number/double'. The runtime value '"$850.00"' to be converted doesn't have the expected format 'Number/double'." How can I fix this? Thanks in advance!
Thanks, I have the opposite problem, I have 23 records that represent flat information of a customer order and I have to build a JSON file to pass through API structured in head, detail and tail Document with different nested sections of JSON template to pass via API.🤔🤔🤔 I need to build a new Jason from a model
I followed every steps and everything seems fine. But, on my Gantt chart, on the Task Bar, it doesn't show the Project Start Date and End Date like yours (10/1 and 10/31). Also, on my Gantt Chart, it doesn't show the Progress Bar. Any idea why? I have watched the video about five times already. LOL. Thanks.😆
Hmmm, normally it's from a small misspelling and then you rename a column. The gantt chart will be built on the initial naming. And maybe it's the start date or end date fields? There's no spaces at all. But thank you for watching 5 times 😆 let me know if you get it, I'll keep trying to help
@andrewhess123 you are the BEST! I deleted everything and followed everything....boom, problem solved. Now, I watched 6 times. 😎😆 Thanks again!🙏
great stuff
Thank you Dr. Zhang! 谢谢你
Hi, can we define a category ?
Hi kikoumimi, you mean your own category in your meeting invite? Yes you should be able to update fields or create custom fields in your line item.
Thanks for this video Andrew! I’ve been working on creating an asset version history feature on my Power App, which contains a SharePoint list as my data source. I was wondering if you had any insight on parsing the JSON back into the Power App and potentially formatting it so it says something along the lines of this: 12/11/2024 at 14:00 Status was changed from “Active” to “Faulty” Status in this case is one of my choice columns. Cheers
Interesting, so every time someone changes a choice field and saves. It then saves the change to a separate data source, which is a SharePoint list? So do you have 2 data sources or 2 different lists? 1 for the assets, and a separate 1 for the asset version history?
@@andrewhess123 At the moment, I have one data source with all my assets (the SharePoint list). The changes are currently saving to a collection, using the Collect function, which I’ve named ‘colAllItems’. This is to test if it stores the data correctly. I was thinking about using a SharePoint list to store the changes, which you’ve mentioned, instead of a collection, but my main focus is to be able to show the changes between each version of the item in a user friendly format. Basically, I need to compare the outputs of each version of the same item and only show the difference in a text label or something that the user can read. I have a unique barcode column which can track the item between two lists rather than using ID if needed. I’ve tried getting SharePoint’s built-in version history to appear in Power Apps, but I’ve had no luck either, and there aren’t a lot of tutorials out there.
Amazing video bro! I've been struggling with PowerApps , and this video was very helpful! Thank you so much, you've earned a new sub! And I will continue learning with the rest of your videos.
Nice! This is an old one but a good one 😀 been asked to remake it. May do that soon, probably next month
I wasn't sure if I should of deleted the first 3:21 because it wasn't necessary, but left it in there anyways 😀 Chapters are there just in case!
Hi Andrew. I'm getting an error and have no idea how to fix it. ''Invalid number of arguments: received 2, expected 1." I would really appreciate a little help. Thanks.
This is on the flow call maybe? or some other fx formula? But you are sending 2 parameters and it is expecting one. So in a formula you are using a "," in between () I would assume and sending 2 parameters and it only wants 1.
Great simple video Andrew. I've been doing this the old school way by populating Word templates with data, saving to Sharepoint, and then having to convert to PDF in my flows .. and this just blows it all away with either using Galleries, Containers, etc. Thanks again for showing this
Awesome B, glad it's simple and working well this way. Yeah the old school way used to be fun 😊
Great video. I really love that you read comments and make videos based on them, always interesting to see.
Thanks, I think it makes it more interactive. And also thanks for letting me know, that way I can keep doing it more too 😃
I appreaciate this video, really interesting. I have a question, one of my searchs have 1576 results and this are not shown in the gallery, if I search for something different it appears but in this case I have this problem, I tried your solution and works in all the cases, less in this one
thanks you for this video, but i have a probleme. I want to create for my contant type a cascade dropdown. The choice of the first drop down will influance the contant of the second drop down. anyone now how to do this?
To me the easiest way to do this is with Power Apps. Integrate a Power App and create a cascading dropdown.
Helped a lot, especially the part where you changed the default mode to new, because that is exactly where I was stuck and could not understand why. When you write the formula for the button (Submitform...) what if I have two lists? One is the database where I would like the info to be saved after hitting submit and another list where the data comes from to create the form. How do I have the info saved to the database and not to the other list. Thank you. Because in your video you created one list.
Hi Andrew, great video - thank you. Is your mic on your desk? Every time you type, it creates a thumping sound - and this sounds worse when using headphones 🎧 Keep up the good work
Dang hmmm I did get a new mic. I wonder if it's fixed with the new mic. I could get one of those mic arms too though so my mic is above me. But yes you are right it's on the desk. Thanks for letting me know though, I do want to get it right.
@@andrewhess123 i believe a boom arm, with a shock absorber should make a big difference. All the best
@@OptimaMrL You're right, I plan on doing a few more upgrades in the near future (1-2 months). I will be looking for this. Thanks for the understanding and tip!
Thank you for great video! Only problem the People Picker script is not working ... any idea what i have to check ? ( we have new setup of office 365 Business Premium )
Did you add the connector as a Data Source learn.microsoft.com/en-us/connectors/office365users/
I got error message at Apply to each " Action 'Add_a_row_into_a_table' failed: A value must be provided for item." What should I check?
I would check for null values, especially dates or other types of fields that are not single line text.
Wow, This is just awesome thank you so much this was helpful and fun as well😂
Excellent! Thanks for the question Tyler, this was a good issue to conquer.
I think next week we will go into a deeper dive of the Power Apps V2 Trigger. The important piece in this video is to build a collection pass it as JSON to Power Automate and then parse. See you next week! 🤩
Is it possible to populate images inside a repeating section? In other word, repeating images?
I don't think the Word Connector can do this, I believe you would need a 3rd party connector or create something custom.
What if you just wanted to dump a mix of different documents into a single location (e.g. a OneDrive folder), and have it automatically separate the documents into their respective types. Can these tools do that? Perhaps ChatGPT would be best at “sorting”?
So you have 2 main options I can think of, #1 is SharePoint premium. It's going to be able to do this very well. The other option is ChatGPT with the api you just have the AI model look at the document and attach metadata to a column and have your sorting built into the columns. I think SharePoint premium is the better options it's worth looking into. techcommunity.microsoft.com/t5/sharepoint-premium-blog/introducing-sharepoint-premium-the-future-of-ai-powered-content/ba-p/3981076
Thank you. Very helpful.
Thanks for watching Kyle.
Interesting
Hello sir, my html text large scrollable table while using this pdf method is only viewable half of table not complete table in one pdf.
I think you can put the html table in a container? Does that help?
Yes,as this method i followed html text in container still not get completed data in one pdf
@@andrewhess123 tnks sir it worked
@@karthikeya6508 Awesome! Nice job!
I am also interested in the delete function
Hello Andrew, First of all, thank you for the video, very well explained, but I have the issue when saving, it is pointing to my OneDrive, how can I make save it and rename it correctly to the SharePoint Doc library instead ? Thanks
Hi Myama, this may be due to credentials. Make sure in MS word you are logged into the correct account that has access to SharePoint. Then when you do save as, save to the SharePoint library. It should appear there when you have access. If that doesn't work try saving a file in SharePoint and opening word in client from there. See how it saves to SharePoint.
@4:51 Hi , in here you reference an older video which you have already demonstrated this method : 1. can you comment here the link to that video , 2. I think in that video you have referenced website from which you take most of your SVG icons , can you post that as well ? TNX
Hey Adlai thanks for watching! These videos are decently old but here is the other video: ruclips.net/video/32zBBxHIPsc/видео.html&t. I should create a new one. 😀 if I mentioned icons most likely it was from this site: icons8.com/icons/set/house
This was super useful, thank you! How would you go about creating the draft but using the structure of a more complex News Post template? I've retrieved the HTML from my template but there's something about the syntax of the HTML I get or the way I paste it in the PA step that doesn't work. Thank you in advance for your help!
Great stuff... Maybe you have a video on how to do this... I have 4 columns also. Column 1 is TEAM, 2 is SUB TEAM, 3 is ITEM, 4 is SUBITEM. How can I get TEAM to appear only one time for each team, same for SUB TEAM. So, basically I don't want any of the cells to repeat. Even ITEM may have 4 SubItems. I want it to appearppear like a PowerBi Matrix. Thanks
Can’t wait for part 3!
Wooo! 🤣 Thanks for watching Em!
Thank you so much for the tutorial, it’s indeed helpful. I followed all the steps but got stuck at publishing. Everything is as it is, after clicking on publish, if I try to add new item on SharePoint, it still shows as the default SharePoint form and not the powerapp we created. A workaround I’m exploring is using adding the submit button on powerapp so it populates to SharePoint. Can you please help with that?
why does it seem no one shows how to prevent this is sql server databases?
Good question and this is getting requested more and more. Most Power Apps developers are being pushed towards Dataverse so I believe SQL becomes less of a topic. I'm not saying I don't like SQL, honestly I prefer SQL. Also, SQL has less delegation issues compared to using a SharePoint backend, so I think that's why no ones talking about it as much. But I do think yes! We should be talking about using SQL more. I'm going to write it down.
Hi Andrew, exactly what I'm looking for and you are just a savior... I have a question about using the type of flow in Power Automate. Can we make use of the 'Desktop' flow in Power Automate for this integration instead of using the Cloud flow?
Most likely yes, but you could always integrate a cloud flow with the desktop flow? But I still have a ton of learning to do myself with desktop flows
Unable to read data. The end of input stream is encountered error in copyto send an http request to SharePoint action
Can someone plz help on this
Is there a way to change the format of the data after it has been sent to the word doc template?
I don't think so, not sure of a use case for that. You could add more steps to the power automate and change the format to send it to somewhere else? But not sure about inside the document.
I have just started PowerApps and this is a great video to start of with. Can you guide me to any of your videos wherein the Users can edit their submitted responses and the database be it SharePoint List or Dataverse would also capture the name and email address of the User along with his Manager? That would help. Many thanks.
Hi Shubhabrata, there are a few different ways to do this, I'm not sure I have the exact video you are looking for... but this is something I should create. But what you would do is default your user field to User().Email, and to grab manager you may have to pull in another connector. But I will write this down, thank you for the idea.
Hi there! Seems like this video has become outdated, Power Automate doesn't offer the "ask in Powerapps" option anymore. Have you find a way to replace this workflow? A year ago, this would've helped me immensely, but in typical Microsoft fashion, they've made their platform harder to use.
True true you need to use the V2 trigger. I will write down to remake
Bless you!!!! Thank you so much for this!!! You are a rock star!!!
Thank you! You too! 😄
you nail it finally. but can I do it in .jpg and one last thing can I move around the signature on the file so, I can insert the signature on the file and resize it base on the sign of the file? Wow man. I subscribe
I got it !!! I had to remove the button & re-write the collection ... Thanks.
Woot woot! Nice glad you got it!
Yes I did name it Screen, the intelligence picked up the "Screen" keyword when I was doing ThisItem. but then "Screen" becomes error
Hi Andrew, great video as always, question ... I have followed each step and got the collection right, but why am I getting error on "Screen on this formula → Navigate(ThisItem.Screen, ScreenTransition.Fade) . thanks, your fan.
Hmmm.. When you did the table did you name your variable "Screen"? When you do ThisItem. does the intellisense pick up the "Screen" keyword?