Пікірлер
@minaturecookbook3342
@minaturecookbook3342 10 сағат бұрын
Thank you for your clear explanation. Now my issue is resolved and i got what exactly want
@andrewhess123
@andrewhess123 10 сағат бұрын
Nice! That's always great! Thanks for watching
@thomasnichols8374
@thomasnichols8374 Күн бұрын
Wonder if we can make this work with a function that connects to an rss feed. I hate that that web part is no longer available - though I might have been the only person who used it!
@andrewhess123
@andrewhess123 Күн бұрын
You are not the only person, this was a major issue at my company too. And Yes I do think it would be possible to use it to connect to an Rss Feed.
@alexotoous
@alexotoous Күн бұрын
this feels like css flexbox
@andrewhess123
@andrewhess123 Күн бұрын
I am also noticing the similarities as I have been writing some React code.
@roma9026
@roma9026 3 күн бұрын
Thanks for the excellent video. For some reason, I can not bring the container inside my gallery. Do you know how I can overcome this?
@andrewhess123
@andrewhess123 3 күн бұрын
Make sure to click inside the first row and insert a container there? It should just pop right in there, not limitations for a container in a gallery
@roma9026
@roma9026 3 күн бұрын
@@andrewhess123 that worked. Thank you so much for your help.
@kennethgottfredsen767
@kennethgottfredsen767 3 күн бұрын
Hi Andrew, is it possible to reproduce this when the SP column is a number instead of text? I have a use case where a ID column has to stay as a number type.
@andrewhess123
@andrewhess123 3 күн бұрын
Hi Kenneth, should be possible with a number column. You can see the first column is {ID: Value(Value.ID)}, where the first Value() actually makes sure that the ID field is a number column.
@manjunathak4822
@manjunathak4822 5 күн бұрын
Hi Andrew...i have embedded a power bi report in powerapps, now added this app as tab in teams, now if i am trying to access the app, am unable to login to the bi report in powerapps, however in powerapps environment am able to login and get data, but am trying from teams am unable to login to bi report,it asking to sign in , when i click on sign in it loads a white page , unable to login, note i have proper permissions for both app and report, any suggestion. many thanks in adavnce.
@3Voc
@3Voc 5 күн бұрын
Very nice instruction as always. Thanks! For the Sharepoint intergration to work, all users would need read/write access to the Sharepoint list, correct? Or are the permissions done via the service account that creates the app? Just asking because our users are not allowed to see vacation requests of other users. Only way around would a flow, triggered by the power app I guess?
@andrewhess123
@andrewhess123 5 күн бұрын
Yes they would need read/write access to SharePoint this way. You could go to dataverse instead and build security that way. Or like you said, yes, you could use Power Automate instead to write to the list using a service account.
@3Voc
@3Voc 5 күн бұрын
@@andrewhess123 awesome, thanks for confirming!
@Sophie-fh3lh
@Sophie-fh3lh 5 күн бұрын
Hi Andrew Hess, Do you have to pay a subscription to ChatGPT or AI Builder?
@andrewhess123
@andrewhess123 5 күн бұрын
Hi Sophie! ChatGPT API is based on consumption. I put 10$ in and dev'd for months and only spent like $2.00. I believe ChatGPT has a new model 4o-mini and the price dropped significantly. AI builder comes with credits with premium Power Apps, once again it's based on credits. So if you have a few users with Power Apps premium you can have a bunch of credits already. If you don't have Power Apps premium at all it does cost extra. There is another way not mentioned I've been testing in Azure Document Intelligence and you can currently do 500 pages for free per month.
@Sophie-fh3lh
@Sophie-fh3lh 4 күн бұрын
@@andrewhess123 Thank you Andrew!
@KCKristi
@KCKristi 6 күн бұрын
I've been working on doing this with a pdfviewer for at least a couple days.....Thank you so much!!! This works!!!
@andrewhess123
@andrewhess123 6 күн бұрын
Woohoo! Nice Kristi glad it's working for you!
@kayonmontaque5967
@kayonmontaque5967 6 күн бұрын
Can you share the formula you created for the app?
@ayakanyki
@ayakanyki 7 күн бұрын
Can we do this but with Checkboxes?
@andrewhess123
@andrewhess123 7 күн бұрын
Oh yeah, sounds totally possible. Things may be a little different because this flow is old before Power Apps V2 trigger, but totally possible with a checkbox.
@imran002ali
@imran002ali 8 күн бұрын
Hi Andrew, nice video and helpful!! I guess you gave day off to Avengers/Marvel, they didn't get any email today 😊 As always, thank you for sharing your knowledge, it is very helpful. Thanks again!
@andrewhess123
@andrewhess123 7 күн бұрын
Thank you Imran as always! Appreciate your support!! Ha the Avengers Marvel were too busy watching the new Wolverine/Deadpool movie 😆
@imran002ali
@imran002ali 7 күн бұрын
@@andrewhess123, you are welcome! lol.. that is good one "..too busy watching the new Wolverine/Deadpool" 😁
@rudivanderlocht3212
@rudivanderlocht3212 8 күн бұрын
Hi Andrew, very nice demo!!! Can you provide the link to your Github. thx Rudi
@andrewhess123
@andrewhess123 8 күн бұрын
Hey Rudi! Doh forgot to add the link, it is now there in the properties also here: github.com/TheAndrewHess/2024 Also, the gallery is not responsive yet, something we will work on in the future. Also you can't export a SharePoint list, so the gallery control most likely needs to be recreated.
@ZubyAbedin
@ZubyAbedin 9 күн бұрын
What if we select add values manually in Sharepoint, what do we need to do in power apps when using modern form to add data manually where it doesnt exist in the list and it could be random and new to add to the choice?
@SisaaTech
@SisaaTech 10 күн бұрын
Is it possible for me to publish an app independently where I can send the link to my app and I can send this link so that people can access my app?
@andrewhess123
@andrewhess123 10 күн бұрын
Power Apps is mostly for internal use, internal inside your organization. There are ways for external use but not really how Power Apps works.
@SisaaTech
@SisaaTech 8 күн бұрын
@@andrewhess123 So it's possible to publish so that people can see my app, right?
@andrewhess123
@andrewhess123 8 күн бұрын
@@SisaaTech I'm not sure what you mean? Yes, it is possible for people in your M365 tenant to see your app. If you want people outside your M365 tenant they need a Power Apps license in their own tenant.
@Sophie-fh3lh
@Sophie-fh3lh 11 күн бұрын
Hi Andrew, for Sharepoint columns that I have created, can they sync with File Explorer view when I don't access the files from the Sharepoint website? Or are there any alternatives to keep this metadata?
@andrewhess123
@andrewhess123 11 күн бұрын
Hi Sophie, I do not believe the columns can sync with File Explorer view. Although MS Word Docs I do believe if you go to File > Properties you can still find the metadata in the client version on each individual word doc.
@starbusttweety
@starbusttweety 11 күн бұрын
In power automate cloud the model is taking too long to train. The internet is fine. What should I do?
@andrewhess123
@andrewhess123 11 күн бұрын
AI Hub with AI Builder? Depending on how many fields and how many documents its trained on, it could probably take several hours.
@pinaldesai5242
@pinaldesai5242 13 күн бұрын
Hi Andrew, great video. Whilst creating the Power Automate flow the dynamic content is not available for me. Any clues as to my this is the case?
@andrewhess123
@andrewhess123 13 күн бұрын
Ask in Power Apps has changed to a Power Apps V2 trigger. There are many videos out there on this change, it was just a change by Microsoft
@SaikrishnaMaila
@SaikrishnaMaila 14 күн бұрын
Hi Andrew, can you make a video connecting enterprise GPT with O365.
@Soulebi03
@Soulebi03 14 күн бұрын
hello Andrew, if the input for the word document is from the sharepoint list, does the users has to have contribute access to the document template too?
@andrewhess123
@andrewhess123 14 күн бұрын
So this depends on how the Power Automate is set up, depending on the trigger if manually ran (for selected item or list) yes, would need access. If, scheduled or automated only the account running the flow. I believe also the only user that needs access to the document template is the account that runs the action Populate the Document Template action in Power Automate. Which is a premium action. This is difficult question because the answer actually is: "It depends".
@DanielChristian19
@DanielChristian19 15 күн бұрын
Nicely done. I have a similar video coming out in two weeks which walks you through how to enhance the out-of-box responsive design that comes with the container controls. Stay tuned!
@andrewhess123
@andrewhess123 15 күн бұрын
Ooo can't wait to see Daniel! Power Apps is moving so fast, honestly I love it! Love the hustle!
@temidayolonge4566
@temidayolonge4566 15 күн бұрын
Great Video Andrew
@andrewhess123
@andrewhess123 15 күн бұрын
Thank you Temidayo !
@Soulebi03
@Soulebi03 18 күн бұрын
great work andrew does this still apply today?
@andrewhess123
@andrewhess123 18 күн бұрын
Hi Soulebi, yes, Microsoft does change some things but I believe everything in this video still currently applies today. You can double check the licensing guide because it does change: learn.microsoft.com/en-us/power-platform/admin/pricing-billing-skus
@MikeDellNZ
@MikeDellNZ 18 күн бұрын
Hi Andrew, I am having issues with the Modern combo box, not initializing, go back and forth and it then generates the list etc. Is there a fix. Thank You
@mdevil1570
@mdevil1570 19 күн бұрын
Hey man love your videos thanks for everything. Quick question any idea on how to print the PDF viewer? I know its still experimental but i tried a couple of things and nothing worked ( I am sure there's a solution that might went over my head).
@ansarmehmoodyt
@ansarmehmoodyt 19 күн бұрын
Your content is impressive, It should be seen by much more Audience and regarding this i have some serious and proven strategies to grow your channel to wider audience. and before you think me as scammer i would like to mention that i am verified on both upwork and fiverr and have my own portfolio website you can and read what people saying about me. I specialize in KZfaq SEO and authentic promotion strategies that can help your channel reach a wider audience and achieve sustainable success. waiting for your response So, we can discuss in details
@pinghwakuang4046
@pinghwakuang4046 20 күн бұрын
Very very good video. Thank you so much!!!!!
@andrewhess123
@andrewhess123 19 күн бұрын
Thanks for watching Ping !
@SkMustafijurrahaman786
@SkMustafijurrahaman786 20 күн бұрын
Awesome. You just fulfilled my criteria. Thank you ❣
@andrewhess123
@andrewhess123 19 күн бұрын
Nice perfect! Hope you crush your goals!
@CedarRidgeRoughnecks
@CedarRidgeRoughnecks 21 күн бұрын
Thank you so much!
@andrewhess123
@andrewhess123 19 күн бұрын
Thank you too Cedar Ridge!
@kooled2245
@kooled2245 21 күн бұрын
Thank you Andrew this is so helpful ! would you please make a video for left navigation pane that has hamburger, home button, edit button for edit gallery and add for add a new content and trash button to delete gallery template selection? Huge respect and appreciation for all your videos!
@andrewhess123
@andrewhess123 19 күн бұрын
Interesting would love to make this!
@lukasvolkel6696
@lukasvolkel6696 21 күн бұрын
Great video Andrew! What do you have to change if it is a multiselect combobox and you want to add the "other" input plus the selected options in one field in sharepoint? In this case, is it possible to remove the word "other" from the field and separate the options with a comma?
@andrewhess123
@andrewhess123 19 күн бұрын
Should be totally possible! Would def add some complexity, but I see no reason it would not work. You'd have to convert your multi select to a string and then delimit with a comma, then if someone selected other you would replace it. How to do it off the top my head exactly not 100% sure, would have to get in there and start creating it 😆. There would be some differences like is your field a multi select or a single line text on the backend. But then pulling back the options so you could edit would be even harder.
@Lokasher-A
@Lokasher-A 22 күн бұрын
Hey Andrew, Thanks for uploading this mate. I will try this out and let you know how I get on 👍.
@martinpetrek2166
@martinpetrek2166 22 күн бұрын
Good work! Perfectly explained.👌
@andrewhess123
@andrewhess123 22 күн бұрын
Thanks, an oldie but a goodie
@user-mc1cs5jw3f
@user-mc1cs5jw3f 24 күн бұрын
that's help a lot! i spent one day to figure out why it only show number when i use collection as Modern combo box datasource
@andrewhess123
@andrewhess123 24 күн бұрын
谢谢!很高兴这个视频能帮到您!
@alondraespinal5115
@alondraespinal5115 25 күн бұрын
Hello, great video. Instead of creating new site columns, is it possible to just add the list columns I already had? And make them into site columns so I don’t need to recreate all 200 list columns again since it already has data in it.
@andrewhess123
@andrewhess123 24 күн бұрын
Hi Alondra, I do not know if that's possible I'm thinking not. There is probably something with power automate you could do to repopulate the data though.
@bluric0
@bluric0 25 күн бұрын
Is it possible to transpose the data in Microsoft word. So that I have the Headers on the left and the values on the right? Is there a way to do this?
@PondyBS
@PondyBS 26 күн бұрын
Thank you Andew! For your video is a stunning easy to understand, I like to appreciate you.
@andrewhess123
@andrewhess123 26 күн бұрын
Thank you so much!
@imran002ali
@imran002ali 26 күн бұрын
Hi Andrew, you have explained a lot within 12 minutes of video, appreciate it. This method can be applied in may different apps, I have learned many things from your videos and have taken to the next level, thanks again!! 👍👍
@andrewhess123
@andrewhess123 26 күн бұрын
Level up!
@imran002ali
@imran002ali 26 күн бұрын
Hi Andrew, great information, appreciate sharing your knowledge. 👍
@andrewhess123
@andrewhess123 26 күн бұрын
Thank you Imran for still watching! Appreciate you!
@gerardoojeda8089
@gerardoojeda8089 27 күн бұрын
Hello Andre, I hope you're doing great! I had an issue when parsing the image JSON using the reference you pinned in the comments, "message": "Required properties are missing from object: serverRelativeUrl, id, serverUrl, fieldName, type, fieldId.", I dont know if powerautomate removed them, but i cant make it work. do you have any ideas what could it be ?
@andrewhess123
@andrewhess123 27 күн бұрын
Take output and ask ChatGPT to parse it or another AI tool, itll parse it for you. There was some change that happened and it wasn't parsing correctly .
@mounirzouita1101
@mounirzouita1101 27 күн бұрын
@andrewhess how can we patch empty value in combobox and patch that to the optionset in dataverse or sharepoint please ?
@AlexFergus-t7t
@AlexFergus-t7t 28 күн бұрын
Thank you so much for mentioning about the AllowNewAPI right off the bat. Drove me nuts until I found your video. Thank you
@andrewhess123
@andrewhess123 28 күн бұрын
Woohoo! Nice Alex!
@manjunathak4822
@manjunathak4822 5 күн бұрын
same case, thanks for mentioning about AllowNewAPI
@Lokasher-A
@Lokasher-A 28 күн бұрын
Hi, Thanks for this video, it works perfectly for me. However, one of my options is 'Other', how can I open a textbox underneath if that option is selected?
@andrewhess123
@andrewhess123 28 күн бұрын
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.
@Lokasher-A
@Lokasher-A 27 күн бұрын
@@andrewhess123 Hi Andrew, Thank you for the quick response. I am new to PowerApps so I am not aware fully about the patch terms etc but I will try to give this a shot. Let me know if you upload a video about this lol 🤣.
@andrewhess123
@andrewhess123 27 күн бұрын
@@Lokasher-A Yeah, so there are 2 answers and it depends on how you set up your form 😅. If you use the out of the box "Form" then you use SubmitForm, if you place all of your text inputs and components custom-ly then most likely you use Patch. Will let you know Thanks for watching!
@Lokasher-A
@Lokasher-A 27 күн бұрын
@@andrewhess123 I created a Combo-Box with manually entered items which are being saved on SharePoint. I have manually entered the items but for the end user it will be seen as a dropdown option. One of the options are 'Other', Which way do you think will be better for me so that once that is selected a textbox opens below for them to add the response manually?
@andrewhess123
@andrewhess123 27 күн бұрын
@@Lokasher-A I'm going on vacation this next week, but I don't want to promise 100% but I will try make this video and auto-release it on Monday.
@begumdost381
@begumdost381 28 күн бұрын
why dont we close the <tr> with </tr>
@andrewhess123
@andrewhess123 28 күн бұрын
Most likely can, probably just a mistake I made
@MCSurvivalMode
@MCSurvivalMode 28 күн бұрын
If you want to extract specific fields using ChatGPT, use compose but make sure you have a delimiter like a semicolon and grab the text in between using Split. split(split(outputs('Compose'), 'VendorName: ')[1], ';')[0]. Please let me know if anyone has a better way.
@andrewhess123
@andrewhess123 28 күн бұрын
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.
@saeedsm57
@saeedsm57 28 күн бұрын
100% Useful! Thanks Andrew!
@andrewhess123
@andrewhess123 28 күн бұрын
Thank you Saeed!
@beecee9207
@beecee9207 29 күн бұрын
Thank you Andrew this is amazing stuff!
@andrewhess123
@andrewhess123 29 күн бұрын
Thanks for your continuous support bee!
@waleedkhan2500
@waleedkhan2500 29 күн бұрын
Awesome tutorial again Andrew! Have you considered working with the assistant API and bringing forth vector stores for training or GL tracking? Would love to see how to make that work with Power automate
@andrewhess123
@andrewhess123 29 күн бұрын
Hi Waleed! That would be amazing stuff to do! Got some learning to do!
@fanyuan
@fanyuan 29 күн бұрын
Hey Andrew, would like to check how to do the inverse? Availability Calendar?
@andrewhess123
@andrewhess123 24 күн бұрын
Hi Fanyuan, there is an old template that uses room reservations that does this. Would need to reverse engineer that template.
@hammadyounas2688
@hammadyounas2688 29 күн бұрын
Great Work Sir, Did it work for get attachment content?
@andrewhess123
@andrewhess123 29 күн бұрын
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.
@hammadyounas2688
@hammadyounas2688 29 күн бұрын
@@andrewhess123 Thanks Sir. I will test it. Hopefully it works
@starbusttweety
@starbusttweety 11 күн бұрын
In power automate cloud the model is taking too long to train. The internet is fine. What should I do?