Відео

Patrick! Maybe it's a Canvas Virus Crisis? 😆😆😆 Thanks Patrick hope to chat again soon!

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.

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.

They can be different, it may just cause some confusion but you can pass the names to different names in Word from SharePoint.

Thanks IllinoisREI, Thanks for your support hopefully we can get a few videos out of that functionality! Stay tuned 😀

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!

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.

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/

J Ray! Great to hear from you again. Thank you for watching!

Imran! Thank you very much once again!

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 😃

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.

You will need to calculate recurrence yourself. There are date formulas.

Thank you for watching!

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

Should work the same with Lists, especially how Microsoft is pushing out the new List look and feel inside all SharePoint lists.

Thank you! You too! 🥳

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

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

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

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

Hi Wade, I have done this before. It would most likely take a video to demo. I'll write it down

So more expensive than what?

Got it after some trials. Thanks for your time

@@yehunlavolontededieu322 Nice even better! 😊

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.

I can write this down to do.

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

Hi Sushil, in the properties of the tag in MS word. You can hide the tags in the template.

Thank you Angela !

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!

Bee sting actually, after working in our garden! 🐝 All good though, got stung a few times, ran inside

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.

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

haha yeah! Thanks for watching again! Temidayo

Thanks for watching Lee!

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 bee, thanks for the honest feedback! Thanks for watching!

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

Thank you again Tariq! You are too kind!

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.

Thank you Tariq, I appreciate that!

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.

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!