Video

Woohoo! Nice Alex!

Hi Lokasher, that's a good idea for a video, but what you would do is you would have a textbox that is only visible when other is selected. And when you patch you would write an if statement, if other then write the text input, if you did a submit form, you would do it in the update property of the card, if other then write the text input instead of the selected choice.

Most likely can, probably just a mistake I made

Nice love the idea, but for some reason it kept making random special characters for me. I feel like if we just wait for 1 more release of a new LLM like GPT5, we can get it perfect! Other options could be like ask it to respond in the format of JSON? But love the idea of asking it to use the delimiter.

Thank you Saeed!

Thanks for your continuous support bee!

Hi Waleed! That would be amazing stuff to do! Got some learning to do!

Hi Hammad! Should work just the same from get attachment content. ChatGPT needs a base64 format where AI Builder did not need it. You could also push an attachment to SharePoint and have SharePoint Syntex run automatically on all documents.

@@andrewhess123 Thanks Sir. I will test it. Hopefully it works

I was thinking of making a video on this, but what you do is you use a timer and move the x or y value based on the timer * x or y, whichever you're moving. I do think I need a video on this though 😀

Hi Susan, Most likely the datasource is SharePoint and the submit button is just submit(form1). And I am writing the selection as a single line text

Hi L. Hana, when you go to settings - list settings? Do you see your content types there? Do you only see the Item Content Type? What do you see there in the content types section.

@@andrewhess123Hi! Thank you for your reply ❤ My apologies for the delay. I think the issue might be that I created a list app because a list didn’t populate. I couldn’t access the library because there wasn’t a list and created the list from the applications. It didn’t matter what kind of application I created, the results were the same. I’m not sure how to access the list if I don’t create the app though. I hope this is making sense…

@@andrewhess123also, aye. I see the content types and it even states that they’ll be viewable, but only the default populates. There’s no option to choose the other forms. Thank you again for your time and this great video!

@@LHana-eg1mj If you do a List, you need to have the Parent as type Item Content Type, and if you do documents then the parent needs to be of type Document Content Type. Both are do-able just need to make sure they are correct for whichever you do.

I don't think its currently possible, you could completely remake it and give it a new name. Which I have had to remake these chatgpt custom connectors at least 20-30 times now 😅There is a vote to add that functionality: ideas.powerautomate.com/d365community/idea/556cfa11-0089-4467-80de-39ed7f3a9ceb

Yes it should be doing that. The metadata is synced. So if you edit the data in SharePoint the document will reflect the changes. If you edit the word document then sharepoint will then see the changes.

Thanks for watching

Hi fromtoyama, Did you change the name of your Parse JSON? If you notice in the compose statement it uses the exact name of that step outputs('Parse_JSON')? Just a guess?

Hi preetima, you could make a pdf document or word document instead of embedding in the email?

Hi Wendy, Thanks for your continuous support! 😀 I'm wondering if you mean the <br> for break in HTML? Or maybe 2 line breaks with <br><br>?

@@andrewhess123 I would use <br> if I were hard coding multi-line text myself. I'm referring here to when the USER is inputting a comment that comprises multiple paragraphs - they would be working in the multi-line input field I've provided, and they would naturally hit the ENTER key if they wanted to create a new paragraph. However this is not translating across into what gets captured back into my SharePoint list, i.e. When their multi-paragraph comment saves to the rolling comments list, it's all just one paragraph.

@@wendymeyer1250 Hi Wendy! That's a really good question and I'm not sure of the answer to that yet. The issue must lie in the source. Where the comment is written, where are they writing?... in a text input field or an html text? Some how you need SharePoint to know that there's a space and Power Apps needs to recognize that space or break first before sending it.

@@andrewhess123 Ah, OK yes, I understand the issue now. Anyhow, after trying to implement a very complicated solution using Power Automate, I managed to solve the problem myself my simply swapping out your Text input in Power Apps for a Rich Text Editor input and then I adjusted your Patch statement to refer to RichTextEditor.HtmlText instead of TextInputCanvas3.Value. So Users can now capture multiple paragraphs. I'm ecstatic!! 😄

Yep! Here is my video on the topic. czcams.com/video/FdOQkDu1ZTs/video.html&t

And if that is not exactly what you are looking for, let me know

The repeating rows without premium, most likely can only be done with a pdf and not a word document.

So my guess is if the file will not open, then the file is corrupt. I'm not sure exactly what you're trying to do, but I have a few other videos where we use Word Templates.

Hi molla, many times if I have a custom button I do my component then I overlay an invisible button over top of it outside the component to give it that extra functionality I want. For the invisible button I give it the same X and Y as the component. For component buttons I think you can have it change screens but not all the functionality of the OnSelect.

Hi Derrick, so instead of using the Get Items from SharePoint you would use the Get Items from Excel, to get items from excel the repeating section must be a table and then use the Select statement on Excel Get Items

If you want to have a form to select the doctors, most likely what you are trying to do I would create a Power App for the selection piece and to make it dynamic. It's not something easy to explain in a comment. Hope this helps some though!

Thanks for watching Jose!

Yes one option I would make a Power App that's connected to the SharePoint list or Integrate a Power App in the SharePoint list.

Thank you sir Darren! Compared to a year or two ago I'm starting to get much better at editing video and photos! Actually enjoy making the content

I didn't want to post this on your Power Apps Facebook, just because it was heavy Azure, but when I can.. I try to post to your channels! And In case anyone is wondering Darren here has amazing content on Power Apps and does LIVE demos constantly!

Thank you for watching Dileep

Interesting! Hi Michael! I do have a very old video where we do this. I do agree that it's time for a new video!

Nice! Perfect! 😁

Thanks so much Wendy! I'm glad the style and videos are making an impact! 🏆🏆🏆

Thank you once again Michael! Appreciate you!

@@andrewhess123 In 3 months Ive come from power 0 to power hero thanks to you and others so pleasure is all mine. Hell, like a month ago I was telling you how I was so proud to make a toggle change whats visible and now I just made a fully responsive app with like 15 screens and over 50 tabs. Its amazing the time you can put into these things. Still learning.

Works with V2

Appreciate it so much! Thank you Wendy!

Thanks so much Wendy! Hope to create many more videos that are just as helpful!

Hi George to get the body of a document I have used free 3rd party tools that convert the document to a .txt file. There may be other ways to do this but I do not currently have a video on that topic as of yet.

Thank you Michael!

Thanks so much mw! Hope you can make an ever better app than me 😀

Oh yeah those Forms in SharePoint are slick! Thanks for watching beecee!

Hi Ashkaan, that's a good question, I have actually not tried the double repeating sections but I feel like it should work. This is something I would need to test out. In the documentation here it does say you can "Nest" repeating content controls so I do not see any limitations as of yet. learn.microsoft.com/en-us/office/client-developer/word/content-controls-in-word My suggestion is to make sure you are using the Start/End tags when you do the repeating content control. Try to isolate the issue. Try putting the 2nd one first and switch the order, does the 2nd one then show up in Power Automate?

@@andrewhess123 Wow Andrew, such a quick turnaround! 😁 I have swapped the orders of the repeating sections and have gotten PowerAutomate to recognize the previously-unrecognizable section. I likewise used start/end tag notation for the repeating sections, but again, only one section gets detected. I’ve bypassed this for now by using the Encodian connector, which has simple syntax for adding fields (including arrays). Their documentation is also straight forward. I managed to populate multiple arrays this way, but they have a pretty hefty price tag if you want to go past their limited free tier services ($600 for 1 year up front). I’ll keep tinkering around with this. Hopefully someone out there has made it work out! I haven’t found anything in the stack exchange either. Regardless, thanks for all the help! Wouldn’t have gotten here without ya :)

Hi Marcus, I have run into this issue before, I would just try again. For some reason the rich text doesn't stick? Normally I just choose a multi-line text and turn rich enhanced text on in SharePoint.

I think what I did was make the points not visible if they are set at default, so you don't see them.

@@andrewhess123 It showed as selected for me but I solved it by adding {} to the default property of the risk matrix gallery. Thank you!

@@OptimalTrainingGroup Awesome! 😀

I feel like yes, but I may make some extra changes also. Someone else was asking for this too.

@@andrewhess123 you are awesome! I am trying to make it with the approval splitting into a yes track that fills the calendar and the no track emails back with a reason and for the life of me I can't get the flow to work. You vids are great for us visual learners, thanks again for great content!

Hi Max, I made a new video to do this a different way. czcams.com/video/IgK5YMSCRx4/video.html