วีดีโอ

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.😆

great stuff

Hi, can we define a category ?

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

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.

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.

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

Great video. I really love that you read comments and make videos based on them, always interesting to see.

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?

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

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 )

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?

Wow, This is just awesome thank you so much this was helpful and fun as well😂

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?

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”?

Thank you. Very helpful.

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 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

@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

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!

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?

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?

Unable to read data. The end of input stream is encountered error in copyto send an http request to SharePoint action

Is there a way to change the format of the data after it has been sent to the word doc template?

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 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.

Bless you!!!! Thank you so much for this!!! You are a rock star!!!

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.

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.

I have been migrating and rebuilding InfoPath forms from scratch to PowerApps (SharePointIntegration type), and I suggest designing them vertically, with a screen height of 1000 or 1080 (you can adjust this value as needed). It’s not ideal to use a landscape layout when there are only a few fields-first, it looks less aesthetic, and second, it blocks much of the background view (the SharePoint list). You should also consider that the form may be viewed on: - Different monitor sizes. - Different screen resolutions. For example, the experience is not the same on a 27” monitor at 1920x1080 as on a 15” laptop screen with resolutions like 1920x1080, 1366x768, 1600x900 (HD+), or 1280x720 (HD). It takes some trial and error to find the optimal settings. Also, light background colors such as white, yellow, or cyan are extremely irritating to the eyes and should be avoided. It’s better to use softer or light pastel shades. Take care!

Hi Andrew, thank you very much for the excellent video. This is exactly the kind of solution I was looking for. I have successfully trained a model in Azure. Then I wanted to programme the flow. Unfortunately, I can't find the right action when I search for "form recognizer" (I use English language in the studio). My studio version (chrome) only finds "Analyze Custom Form" (no see more option) and not the "Analyze Document for Prebuilt or Custom models (v3.x API)". When I implement this, I get an error message that the model ID is wrong, though I have copied definitely the right one. I assume the reason is the wrong action. How can I find the right action? Is it called different today?

Thanks - have been waiting on part2 :)

Hello can you make a tutorial on how can we get more than 20 inputs PowerApps(V2) trigger pls I need a solution

Oh look! Someone with their face + pointing in a thumbnail! How original! Just think about how many more clicks you’ll get now that you look exactly like every other unimaginative lemming moron on TH-cam! 😂

Awesome video, would be great if you did an updated video focusing on a 5x5 Matrix with probability 1-5 instead of 1-10 from the get go to make it less confusing!

You can also use the Sequence Function for # of days: // Collect # of Days to Repeat ClearCollect( NumberCollection, ForAll( Sequence(51), Text(Value - 1) ) );