![Andrew Hess](/img/default-banner.jpg)
- 164
- 1 034 523
Andrew Hess
United States
Приєднався 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!
How to create a Collection from your Selection in Power Apps
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 useful topics you will learn:
1. How to AddColumn to a Datasource in a Collection
2. How to Add a Checkbox to a Gallery and Save the Data
3. How to Create a Collection Based on those Checkboxes
Below are formulas we used in this video:
Formulas:
Collect varCheckbox: ClearCollect(colDetails,AddColumns(Details,varCheckbox,false))
OnCheck: UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox})
OnUncheck: UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox})
Collection Selection: ClearCollect(colSelection,Filter(galDetails.AllItems,varCheckbox))
Chapters:
0:00 Introduction
1:40 Checkbox in the Gallery
2:22 Why you should create a Collection
3:45 AddColumns to Collection
5:10 Adding Checkbox in Gallery
7:35 Collecting our Gallery Selection
10:30 Conclusion
There are some extremely useful topics you will learn:
1. How to AddColumn to a Datasource in a Collection
2. How to Add a Checkbox to a Gallery and Save the Data
3. How to Create a Collection Based on those Checkboxes
Below are formulas we used in this video:
Formulas:
Collect varCheckbox: ClearCollect(colDetails,AddColumns(Details,varCheckbox,false))
OnCheck: UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox})
OnUncheck: UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox})
Collection Selection: ClearCollect(colSelection,Filter(galDetails.AllItems,varCheckbox))
Chapters:
0:00 Introduction
1:40 Checkbox in the Gallery
2:22 Why you should create a Collection
3:45 AddColumns to Collection
5:10 Adding Checkbox in Gallery
7:35 Collecting our Gallery Selection
10:30 Conclusion
Переглядів: 486
Відео
Extract Data from PDFs with Azure Document Intelligence & Power Automate - No Premium Licenses
Переглядів 889День тому
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)
Переглядів 67314 днів тому
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
Переглядів 76921 день тому
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
Переглядів 647Місяць тому
Creating news posts automatically with Power Automate can be achieved with a sequence of four HTTP requests. The first request copies the template for the news post, the second checks out the news post for editing, the third writes and saves a draft, and the fourth publishes the post. This streamlined process ensures efficient and accurate news posting with minimal manual effort. This was a com...
Emailing Gallery Selections in Power Apps with an Email Template
Переглядів 878Місяць тому
Want to select a few rows and email the owners their items auto-magically! Well now you can! This week we set up a Gallery to auto email our selected choice! In Power Apps, you can use a gallery to display a list of items with checkboxes, allowing users to select multiple items. By pressing checkboxes within the gallery, you can collect the selected items into a collection. This collection can ...
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
Переглядів 728Місяць тому
Hi Everyone! Today we create a new responsive email screen in Power Apps. I believe this can be a multi week project and the good news is each week we are going to have the app be downloadable! So you can follow along and then just download the end result! Here's the link: github.com/TheAndrewHess/2024 Creating a custom responsive email screen for Power Apps involves several key steps. First, d...
Write your Other Choice in a Combo box with Power Apps
Переглядів 723Місяць тому
This is a question directly from from of you and that is how to write your "Other" choice from a separate single line text to your Data source. Please keep the questions coming I love making videos and especially short little videos just like this one! In Power Apps, you can provide an "Other" option in a dropdown menu, and if selected, prompt the user to input their own text into a single line...
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
Переглядів 1,1 тис.Місяць тому
Microsoft provides a robust solution for Optical Character Recognition (OCR) through its integration of Power Automate, AI Builder, and Autofill Syntex. Power Automate allows users to create automated workflows that can process documents and images, extracting text and data using OCR capabilities. AI Builder enhances this by providing AI models that can be trained to recognize specific types of...
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
Переглядів 3162 місяці тому
Studying for the Azure AI 900 certification involves understanding the core concepts of artificial intelligence and machine learning on the Azure platform. It requires familiarity with various Azure AI services and their practical applications. Regular practice through hands-on labs and utilizing study resources, such as Microsoft's official documentation and online courses, can significantly e...
Simple Leave Request App for Teams | Power Apps or List Form
Переглядів 3,5 тис.2 місяці тому
Ok, this was a video that has been requested by many of you and it was time to re-do the video. This is another way to do leave approvals! Actually it's 2 different ways. It's a simple leave request app for MS Teams! Using it in Microsoft Teams I believe is the best way to do it because then everything lives right there in that Team. 1. We build a Teams Power App to populate a SharePoint list 2...
ChatGPT Whisper with Power Automate (Voice to Text)
Переглядів 6422 місяці тому
We have been conquering each piece of Chat GPT with Power Automate workflows. In my opinion that's where AI shines with a workflow. Using Power Automate we can streamline any process with an AI and cut down on the time spent with repetitive tasks. AI is all about efficiency! HTTP Call for ChatGPT Whisper-1 model, make sure to double check that a new more cost efficient model has not been releas...
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
Переглядів 4822 місяці тому
Download a copy and import in your environment: Calculator2024_20240609181205.zip github.com/TheAndrewHess/2024/ This video is a learning experiment for anyone new to Microsoft Power Apps. About 1.5 years ago we created a calculator Power App with classic themes. This year lets do a few things different! 1. Modern Themes 2. Using Out of the Box Template 3. Using Containers 4. Making it Responsi...
Use ChatGPT-4o Vision on Images with Power Automate
Переглядів 1,1 тис.3 місяці тому
This video is not just about Image Tagging but using an AI Model like ChatGPT-4o to pull back data based on your images. This includes: 1. Image Tagging 2. Generating Descriptions based on images 3. Transcribing Images 4. Translating Text in images 5. OCR Using the ChatGPT API to analyze images involves uploading the image file to the API, which then processes the visual content to extract rele...
Custom Connector Power Automate & Chat-GPT Images using Dall-E
Переглядів 6533 місяці тому
Custom Connector Power Automate & Chat-GPT Images using Dall-E
Connect Power Automate & ChatGPT-4o with Custom Connector
Переглядів 3,8 тис.3 місяці тому
Connect Power Automate & ChatGPT-4o with Custom Connector
Wait! Solve Delegation Easily! In Power Apps Search
Переглядів 5 тис.3 місяці тому
Wait! Solve Delegation Easily! In Power Apps Search
Making Containers work for You in Power Apps - Managing Layout and Consistency
Переглядів 1,9 тис.3 місяці тому
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!
Переглядів 1,8 тис.4 місяці тому
Convert Default Form to Custom Form in Power Apps - Defaults, DefaultSelectedItems, and More!
Creating an Edit Form and Fixing Defaults in Power Apps
Переглядів 5 тис.4 місяці тому
Creating an Edit Form and Fixing Defaults in Power Apps
Creating a Power App from a Blank Canvas - How To: Beginner Tutorial
Переглядів 3,1 тис.4 місяці тому
Creating a Power App from a Blank Canvas - How To: Beginner Tutorial
Creating Word Documents from MS Forms through Plumsail (Yes Premium Licenses)
Переглядів 9654 місяці тому
Creating Word Documents from MS Forms through Plumsail (Yes Premium Licenses)
Printing/Saving PDFs with Signatures and Images (No Premium Power Apps)
Переглядів 4,7 тис.5 місяців тому
Printing/Saving PDFs with Signatures and Images (No Premium Power Apps)
A Complete Feasibility Matrix in Power Apps for Project Management
Переглядів 2,3 тис.5 місяців тому
A Complete Feasibility Matrix in Power Apps for Project Management
Creating a Business Value VS Feasibility Matrix in Power Apps for Project Management!
Переглядів 8875 місяців тому
Creating a Business Value VS Feasibility Matrix in Power Apps for Project Management!
Choosing your Data Source in Power Apps - SQL, Dataverse, SharePoint, Excel, Dataverse for Teams
Переглядів 9865 місяців тому
Choosing your Data Source in Power Apps - SQL, Dataverse, SharePoint, Excel, Dataverse for Teams
Dynamic Repeating Combo boxes in Power Apps
Переглядів 2,8 тис.6 місяців тому
Dynamic Repeating Combo boxes in Power Apps
Populate PDF Documents No Premium Licenses with Power Apps and Power Automate
Переглядів 8 тис.6 місяців тому
Populate PDF Documents No Premium Licenses with Power Apps and Power Automate
Integrated Power App with our MS Word Template Project for 2024
Переглядів 1,5 тис.6 місяців тому
Integrated Power App with our MS Word Template Project for 2024
Complete MS Word Template Project for 2024 with Power Platform and SharePoint
Переглядів 2,5 тис.6 місяців тому
Complete MS Word Template Project for 2024 with Power Platform and SharePoint
GREAT tutorial! Unfortunately at the testing stage i get error info: The user XYZ does not have a service plan appropriate for the custom connection “ChatGPT4o”. Does it mean, that i need to have PowerAutomate Premium to use that custom CHAT GPT connector?
Awesome, Thank you for sharing. I am new to PowerApps and the resize was killing me. Thanks again.
So if you tried to vaccinate a Power App value - and failed - would that be Collection Selection Infection Protection Rejection? 😆 (Great video - sharing it with my coworkers)
Patrick! Maybe it's a Canvas Virus Crisis? 😆😆😆 Thanks Patrick hope to chat again soon!
Hey Andrew I a not able to mark the whole table and the properties do not show up blank so i can not add the start and end tag. Plus the table does not show up in the populate word template action. i only have my tags in the action and can add the dyamic content to it. plus it is not possible to open the app because it thows errors saying: word found unreadable content. any ideas?
Hey Markus, I think it would be important to be able to select the whole table. Have you tried with just simple single line text fields? It was a little difficult to select the whole table for me, there's just a certain way to click in there. The errors with unreadable content I believe is due to the content controls having an incompatible format.
Thx for this. Please consider the following power automate/collections use case. A user requires more than 20 ‘ask in Power Apps’ inputs for flow. Resolve issue by creating collection with perhaps 32 fields per record (eg, Name and attendance value for each of 31 monthly dates) and pass the entire record as a json string/object into a singular ‘ask in Power Apps’ flow input. Further requirements might include ForAll in collection to capture values for multiple students and subsequent related steps in Power Automate to parse/select records accordingly. I’ve managed this on my own once, but it was a mind-bender and I’m no longer confident that I can reverse engineer what I’ve done previously in order to repeat it now if I had to. Thanks for considering this as a future topic in case this sort of documentation would be beneficial to the community.😂😅😊
Hi gerald, Thanks for still watching the videos! I do think the way you did this is correct. To pass all the "20 ask in Power Apps" which has changed now to PowerApps V2 and instead pass it as a JSON table. Then once you have the JSON table you would use a select action in Power Automate. This select action can then be parsed to get each of the rows in a ForAll loop. My next video does some of these steps but then it takes that for all loop and creates a brand new excel file in the end. Instead of creating excel you could do other things with the data. Thank you though, I'm going to create a few videos on this topic, this seems like a good one.
Can the names be different in the word table and SharePoint? Does this create hickups in Automate?
They can be different, it may just cause some confusion but you can pass the names to different names in Word from SharePoint.
Really looking forward to seeing you use the collections straight into Power Automate. Great video!
Thanks IllinoisREI, Thanks for your support hopefully we can get a few videos out of that functionality! Stay tuned 😀
Hi Andrew. Great video on an useful topic. I am still in the learning mode and enjoy your content, so keep up the good work. Quick newbie question... how were the original Horizontal Container and Gallery elements created? Is there a video on how to set up this specific scenario? Specifically, how do the horizontal allery elements exist in the horizontal container with the individual container elements per gallery item. Is that a manual process? Any suggested videos or documentation would be appreciated. Sorry for the long comment/question. ~ Reggie
Hey Reggie, so I do have an older video and maybe its time to make a new one. But here is an older video:😀ua-cam.com/video/h3m-U7jQnMQ/v-deo.html&t I will write down to remake this video better!
So I'm not seeing the NumberCollection show up when I create my gallery. My only options for Select a data source is Tables and Connectors dropbox. In your app is not there.
Hey so NumberCollection is a collection that you would make. You can put it in a button click or onvisible. You can see that @5:03 ClearCollect(NumberCollection,["0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"])
@@andrewhess123 Did that, copy and pasted the NumberCollection syntax from the Description box
@@adamgrine247 So when you create the collection, did you put it in a button.. if you did put it in a button. Did you "test" the app and run the collection. Then check your variables on the left side where collections are. Does the collection exist? Collections can be used as a data source.
Thanks for the Video. Just a few questions. I would like to track the total number of days taken for leave of each user as a Colum in SharePoint. How do I also book out the leave in the users calendar? (Example if I want to book them for a meeting I can see the user is out of office or busy)
Hi HollowBl4de, So tracking the number of days would need to be a formula you would create when they book. You could probably find a date equation that subtract end date from start date and removes weekends and holidays. A tough one though as most "date math". And so for the second part, my only app that has done something similar was related to the template for "Book a Room" provided from Microsoft... but instead o seeing when the user was out it just would not let them book at that time. Here is that template it's worth a look: www.microsoft.com/en-us/power-platform/blog/power-apps/office-template-book-a-room-now-available/
Hey Andrew, you did a great job. Thanks for your work and willingness to share it!
J Ray! Great to hear from you again. Thank you for watching!
Hi Andrew, very nice, I liked the idea, selection, collection 😁, awesome, thank you for sharing your knowledge, it is very beneficial👍
Imran! Thank you very much once again!
Hopefully, you still read these. You said you don't recommend Excel as a backend, but what else can I use? I'm a student just learning power apps and databases. I would love to use a database, but I'm not a business. I'm one guy storing personal data. I can't afford crazy pricing plans. Is there a better option than Excel?
SharePoint is the easiest... and if you want to explore more you can do "Dataverse for Teams". Or if you want to learn even more you can sign up for a free subscription to Azure and set up a Dev Azure SQL Server.
@@andrewhess123 Thank you for that quick response. I have always had an interest in computers but I'm diving into a lot of stuff that is new and overwhelming because of how many products, languages, etc... are out there. It's hard to know where to focus. Thank you for the suggestion. Take care.
@@mike9512 Well what do you want to learn? What's your final goal? Is it to make money? Is it to get a job? Is it to improve the world? I would start there 😀. My goal is actually just to learn, I love just learning everything it's actually a problem... 😅 Start with what is free, there's so much free content online and things you can try out.
@@mike9512 another suggestion is tell ChatGPT what you like to do and where you want to go.. then ask it to give you like 20 suggestions. Then find one of those and go from there 😃
Hello Andrew! Great video! I have a more complexed case, and I hope you can help me. I have 10 different content types in my List(Migrated from old system created 10 ya), and in those content types I have some required fields that are not the same in all 10 content types. So when I create a form I can't define that some information is not required in the chosen content type, but is required in some of other 9 content types. Hope you can help!
Hi Ivana, So this would be a very large power app if you have 10 content types, but I think creating a completely custom form and using a Patch() statement instead of SubmitForm() may help. Another option if they are required in some, can you remove the requirements on all of them? Not sure if you can remove the requirement on the SharePoint side but then on the Power Apps side you could make the required depending on the content type. And finally a last option would be to recreate custom "cards" and then have the submitform with the custom cards. There are ways to do this but I do think it's a good bit of work 😄
@@andrewhess123 Thank you for your suggestion! I already tried to put in all required fields for every content type for submitform() and it has partially worked, it did populate my list, but an error message occurs. I thought that patch function would behave the same so I didn't want to invest a lot of time , but I will try it now! Also, I'm a junior developer on this project and I can not touch the structure of migrated lists, so the option to make fields not required is a no go.
@@IvanaMilovanovic994 Gotcha. Yes 100% Patch() will work.. but it will cause you a lot of work 😅. With patch you can write to which fields you want and you could probably create an array for... if the field is required or not, or even visible or not depending on which content type you are on.
I am unable to add inside the gallery text filed like TextInputCanvas2 can you guide me how to add text input inside the gallery.
can this handle recurrence? How?
You will need to calculate recurrence yourself. There are date formulas.
Thank you!
Thank you for watching!
Can we delete comments? 🤔
Hi Yehun, should be possible with an equation like: RemoveIf(datasource, primaryId = gallery.selected.primaryId). You could build a gallery instead also and say remove on thisitem.isselected. There are a few options
Hi Andrew, I just found this video very helpful. Does this work when populating lists in Microsoft Lists.
Should work the same with Lists, especially how Microsoft is pushing out the new List look and feel inside all SharePoint lists.
Awesome 😍😍😍
Thank you! You too! 🥳
Excuse me, I would like to ask you how you can make multiple filters work at the same time?I try one filter and it works, but when I try more than one it becomes a full selection and doesn't work.
你好 Zack! So yeah it was a problem for me too, but near @12:20 you can see we were multi filtering and one easy way to do it was concat on the Power BI side. Also at @8:44 we talk about using DAX. The easiest way for me was the concat way, I agree it was a little "buggy", but here is more documentation: learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
It is so useful thank you! it works fine with new and view forms but on edit form, I am struggling to set the defaultselecteditems value for the combo box
Hi Nebiha, I have another video on combo boxes. Since modern came out a few things have changed. ua-cam.com/video/ONPI9cf2JLQ/v-deo.html&t
Hi Andrew, thank you for the tutorial, do you have any idea to generate PDF contain chart?
Hi nindya, this is a good question. I have not done this yet, would be fun to try.
@@andrewhess123 i tried it, in screen it’s work but once I generated it in PDF, it turns out to blank or black :(
@@nindyasofiana hmmm, yeah I wonder. I do know that the PDF function is still a preview feature.
The Plain text control not removed after template is populated and created .docx file
In the template on the content control. Go to properties and turn off the bounding box.
Set to None. learn.microsoft.com/en-us/office/client-developer/word/content-controls-in-word#improved-visualization
Thanks @AndreWhess , but after data is loaded in content control if we want to edit , it is not edited, instead it removes value along with content control.
@@IAmaProgrammers Are you trying in browser or in client? Try actually opening Word in client? I am not seeing the same functionality where it does not allow you to edit and removes the value... If that keeps happening try on a very basic content control.. try to isolate the issue.
@@andrewhess123 Thanks for your time to explain to me , if you see the above video 17:33 the table is populated values and highlighted the text , can you try to edit the table cell values and see it is possioble to edit the values ?.
Hi. After you created and populated .docx file can we remove placeholder from Docx file ?
You can hide the content control properties in the template or afterwards in the word file. learn.microsoft.com/en-us/office/client-developer/word/content-controls-in-word#content-control-improvements-in-word-2013
Hey Andrew. Thanks for the video. Would you know how to create a table in word using Plumsail where a new row is added for each form response? So basically taking what you demonstrated here and then automatically adding rows and appending responses into the document.
Hi Wade, I have done this before. It would most likely take a video to demo. I'll write it down
so this is just a fancy ocr document reader but also more expensive ?
So more expensive than what?
Hey Andrew, Could you please help me to reorder the info 😞😞? Name, Date on new line comment. Just like SP comment section
Got it after some trials. Thanks for your time
@@yehunlavolontededieu322 Nice even better! 😊
Awesome content. I was just exploring Azure document Intelligence two weeks ago. it have me some issues cause the PDF's data which I wanted to extract had tables that were repeated with different values in it's columns
Thanks David! I'll write down that for the future to try out a table. It was an option in Azure the trick would be looping through each row in Power Automate from the JSON.
Hey Andrew can you do for more complex pdf like which has lot ofvalues in some form or anything?
I can write this down to do.
Thanks for the video. Is it possible to pull data from selected columns of the record (SharePoint list item) to print to the PDF file?
Hi CHAMONIX, should be possible. I can write down this idea for a video. You would create a collection based on columns that are selected then create an html table based on that collection, then print to PDF.
@@andrewhess123 Thanks. So the PDF function just does screen print, I need to get the desired output ready first.
@@CHAMONIX552 You can print certain Containers I believe too, not just the entire screen. And then inside that container you would have an HTML table with the selected columns.
@@andrewhess123 Thanks, not familiar with using container. Let me do some research
@@andrewhess123 Can I apply some logic to the container so some columns wont show if condition not met?
Hi Andrew, Thanks for your video! I’m working on a similar project, creating a 'sign-in form' Power App for guests, contractors, or groups of people visiting my company. The data is stored in a SharePoint list with the following structure: Company Name | Name of Employee | Signature | Date Each sign-in form accommodates 10-12 rows of data, with each form submission stored as a single record in the SharePoint list. I’m also planning to create another Power App solely for viewing or deleting records, using a gallery and an edit form. However, I’m struggling with differentiating between records, given that all sign-in details are stored vertically within these four columns. How should I structure the data to keep each form submission as a distinct, identifiable record?
Hi yy, your rows should have a unique ID in SharePoint, normally it is hidden. Would this give you the distinct, identifiable record you are looking for? You could also make a calculated field in SharePoint, Concat([Name],Text([Date])), something like that?
Great video! How can I remove the tags that still appears in the destination file after being populated. I want to edit the content further and these tags and populated content seems hindering. Any suggestions? Thanks
Hi Sushil, in the properties of the tag in MS word. You can hide the tags in the template.
Very clear. Thanks.
Thank you Angela !
Hi Andrew! really appreciate your content. What if YourName is combo box with multiple selections set to true, how can I make it appear in the table in separate rows. Do I need to use patch or this can be done with SubmitForm?
Hi Antonio, So lets see. A combo box with multi select and true/false. I would recommend Patch for this function. The issue would be if there was a change in the future how hard would it be to add a new option. If there are likely no changes in the future your work could be easier but if lots of changes it might be more difficult and instead choose to do many check boxes, individually. Like you click someone's name and then that brings you to the next screen with many check boxes for each person selected. It is possible, but this seems like a full app in itself 😄
Thanks you, ended up using patch, did struggle but it was worth it!
Great Content! I am practicing this currently. I'll definitely let you know how it went. I noticed from the video that you have a mark on your neck, did you hurt yourself, have breakout allergy to something? Anyways, I hope that you are better now. Do take care of yourself. P.s: Your No. 1 fan.
Bee sting actually, after working in our garden! 🐝 All good though, got stung a few times, ran inside
Also, the link to the video on creating a custom connector to ChatGPT-4o isn't in the description of the video. I don't know if it is possible to also create a custom connector to google Gemini AI using power automate. Thanks a lot. You are the man!
Hi David, Thanks added it in the description. Yeah I'm sure it should be possible to use Google Gemini AI, and if it's not available yet it will be in the future.
Awesome stuff per usual. Can you please make a video using Azure document intelligence for custom PDFs and Power automate to extract the data and an automation that sends the data to a SharePoint list. I tried doing this using the free plan for 500pages per month, but I kept hitting road blocks after i had trained the model and tried to work with the results in json format
Yep, I actually recently did this. Totally worth a video! Writing down now.
Hi David! Your video is ready 😄 ua-cam.com/video/ZPehHclHPO4/v-deo.html
Great Job Andrew. Please make sure Dr Evil does more volunteering....
haha yeah! Thanks for watching again! Temidayo
that is amazing! thanks a lot for your vedio.
Thanks for watching Lee!
I feel a good blend of both is perfect ... Basic to advance. You can ignore how long it'll take. You always give top-tier quality content. The video can be as long as necessary. So newbies get value and the pros can also get value.
Thanks for the feedback David. Yeah I think I'm trying to find that sweet spot and I should focus on Chapters and longer videos so people can skip around if they want. Thanks for watching!
Hi Andrew! I watch your content a lot, I feel like we should go a little deeper dive when starting the videos so not every video has the basics.
Hi bee, thanks for the honest feedback! Thanks for watching!
I feel like there was a little bit of filler at the beginning, sometimes people ask me to go over the basics more, sometimes people want me to speed up! Let me know what you think, so we can make videos even better in the future! Thanks for watching all, hope to meet some of you in Vegas at the Power Platform Conference 2024!
Any chance we can add an html table to a word document? I am looking to use a condition to look at multiple columns in a row for a true or false value, after a get items. Then put only false columns into a html table. So- is a category in or out of scope, then only show false in a table in the document. Not sure if possible to put html table into a column in the manner of your video, but looking for options to accomplish this without showing all the columns and the true or false status in one table- which I am doing currently. Really I only want to show the false items in a table in word. Seems to work for email, but can't figure out word. Thanks.
Hi Susan, in order to do this you will need the Power Automate Word connector most likely, which is premium. There are other options like going straight to PDF and putting your html table there which is not premium. But currently the print to PDF function is limited to 1 page per print.
Hi @Andrew, I really enjoyed your video! I have a question. Since Microsoft 365 Copilot offers similar functionality, such as reading attachment files and performing tasks based on a prompt, why don’t you use 365 Copilot? Does it not support APIs? I’m new to Azure and Power Automate, and I want to send a PDF file from an external source to Azure via REST, have AI read the file, generate data according to a prompt, and then send it back. Could you give me some advice on how to approach this?(Fully automated, no manual work even file upload or create promt) Thanks a lot!
Hi Le An, sadly Copilot 365 is still not available currently today in the GCC (Government Consumer Cloud). Also 365 Copilot is using Chat GPT as it's back end. The main goal is to completely automate it like you said, fully automated. Azure with REST, is probably the best way to do it. Using Azure Document Intelligence which used to be called Form Recognizer with a neural model was easy to set up with Power Automate. You would go to Azure, set up and train a model, then using Power Automate to call on that model and send you back data. I do think I should make a video on this. Would be great!
Hi Le An, I created a new video today you may want to check out on extracting data with Azure Document Intelligence: ua-cam.com/video/ZPehHclHPO4/v-deo.html
@@andrewhess123 niceeee, thank you!
Absolutely beautiful the way you explain it. I was going to start a form in powerapp I was not sure how i get Flexbox like funcionality and dynamic responsive form when hiding certain components. YOU SAVED ME RESEARCHING IT. thank again for you brilliant structured explanation. In my opinion you Aced it
Thank you again Tariq! You are too kind!
Excellent video. Can I use multiple lines of text in the sharepoint list. I am creating fields that exceed the single line. Is that too complex?
I easeetarget, when you need multiple lines of text you may need to go to the premium version of Power Apps or Automate. I have not tried this method in quite some time. It may be worth a try and if it doesn't work to instead use Power Automate Premium to populate a Word Document.
@@andrewhess123 thanks man. We don’t have premium at work so I was trying a work around.
Very nicely explained the components and logic. I have seen many people giving tutorials, in my opinion. You Shine keep it up Andrew
Thank you Tariq, I appreciate that!
how do you make it so sends email to the manager?
Hi Steven, in Power Automate there is a Get Manager action that you can pull in, you just populate that step with the current user email or ID and it will get the managers metadata necessary to send them an email.
Once you've configured your view - any way to adjust the order of fields as they appear in the input screen? The order of columns is correct but this is not reflected in the New Item (custom list Content Type) input screen. Thanks in advance.
Hi Lennos, if you go into settings > list/document settings > then click on the Content type then you will see a list of your columns, here if you arrange the order it should update on your Form and be in the correct order on the New Form. Let me know if this helps?
@@andrewhess123 It seems to work on the desktop, but getting no love on the lists mobile app… wondering if the app is getting conflicting column orders from the different content types or parent content type…
@@lennos81 Maybe.. this functionality is all the way from SharePoint 2010-2013, if not before that. Way before Lists Mobile was even around.
@@andrewhess123 Closure! I think I had 2 issues at play: The first was my choice to use a custom parent content type (rather than just using "Item" as shown in your video). I'm guessing that the column order specified in the list was conflicting with the parent content type column order (not specified in the list). The second issue is that lookup column types don't seem to be supported by the Lists App. So they were not appearing in the input forms. I've flattened my content type structure (parent = item), and converted lookups to choices, and all is well in the world again. Thank you.
@@lennos81 Ahhh nice! Thanks for sharing Shane, that makes sense!