Thank you for your clear explanation. Now my issue is resolved and i got what exactly want
@andrewhess12310 сағат бұрын
Nice! That's always great! Thanks for watching
@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Күн бұрын
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Күн бұрын
this feels like css flexbox
@andrewhess123Күн бұрын
I am also noticing the similarities as I have been writing some React code.
@roma90263 күн бұрын
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?
@andrewhess1233 күн бұрын
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
@roma90263 күн бұрын
@@andrewhess123 that worked. Thank you so much for your help.
@kennethgottfredsen7673 күн бұрын
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.
@andrewhess1233 күн бұрын
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.
@manjunathak48225 күн бұрын
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.
@3Voc5 күн бұрын
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?
@andrewhess1235 күн бұрын
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.
@3Voc5 күн бұрын
@@andrewhess123 awesome, thanks for confirming!
@Sophie-fh3lh5 күн бұрын
Hi Andrew Hess, Do you have to pay a subscription to ChatGPT or AI Builder?
@andrewhess1235 күн бұрын
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-fh3lh4 күн бұрын
@@andrewhess123 Thank you Andrew!
@KCKristi6 күн бұрын
I've been working on doing this with a pdfviewer for at least a couple days.....Thank you so much!!! This works!!!
@andrewhess1236 күн бұрын
Woohoo! Nice Kristi glad it's working for you!
@kayonmontaque59676 күн бұрын
Can you share the formula you created for the app?
@ayakanyki7 күн бұрын
Can we do this but with Checkboxes?
@andrewhess1237 күн бұрын
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.
@imran002ali8 күн бұрын
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!
@andrewhess1237 күн бұрын
Thank you Imran as always! Appreciate your support!! Ha the Avengers Marvel were too busy watching the new Wolverine/Deadpool movie 😆
@imran002ali7 күн бұрын
@@andrewhess123, you are welcome! lol.. that is good one "..too busy watching the new Wolverine/Deadpool" 😁
@rudivanderlocht32128 күн бұрын
Hi Andrew, very nice demo!!! Can you provide the link to your Github. thx Rudi
@andrewhess1238 күн бұрын
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.
@ZubyAbedin9 күн бұрын
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?
@SisaaTech10 күн бұрын
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?
@andrewhess12310 күн бұрын
Power Apps is mostly for internal use, internal inside your organization. There are ways for external use but not really how Power Apps works.
@SisaaTech8 күн бұрын
@@andrewhess123 So it's possible to publish so that people can see my app, right?
@andrewhess1238 күн бұрын
@@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-fh3lh11 күн бұрын
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?
@andrewhess12311 күн бұрын
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.
@starbusttweety11 күн бұрын
In power automate cloud the model is taking too long to train. The internet is fine. What should I do?
@andrewhess12311 күн бұрын
AI Hub with AI Builder? Depending on how many fields and how many documents its trained on, it could probably take several hours.
@pinaldesai524213 күн бұрын
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?
@andrewhess12313 күн бұрын
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
@SaikrishnaMaila14 күн бұрын
Hi Andrew, can you make a video connecting enterprise GPT with O365.
@Soulebi0314 күн бұрын
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?
@andrewhess12314 күн бұрын
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".
@DanielChristian1915 күн бұрын
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!
@andrewhess12315 күн бұрын
Ooo can't wait to see Daniel! Power Apps is moving so fast, honestly I love it! Love the hustle!
@temidayolonge456615 күн бұрын
Great Video Andrew
@andrewhess12315 күн бұрын
Thank you Temidayo !
@Soulebi0318 күн бұрын
great work andrew does this still apply today?
@andrewhess12318 күн бұрын
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
@MikeDellNZ18 күн бұрын
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
@mdevil157019 күн бұрын
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).
@ansarmehmoodyt19 күн бұрын
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
@pinghwakuang404620 күн бұрын
Very very good video. Thank you so much!!!!!
@andrewhess12319 күн бұрын
Thanks for watching Ping !
@SkMustafijurrahaman78620 күн бұрын
Awesome. You just fulfilled my criteria. Thank you ❣
@andrewhess12319 күн бұрын
Nice perfect! Hope you crush your goals!
@CedarRidgeRoughnecks21 күн бұрын
Thank you so much!
@andrewhess12319 күн бұрын
Thank you too Cedar Ridge!
@kooled224521 күн бұрын
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!
@andrewhess12319 күн бұрын
Interesting would love to make this!
@lukasvolkel669621 күн бұрын
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?
@andrewhess12319 күн бұрын
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-A22 күн бұрын
Hey Andrew, Thanks for uploading this mate. I will try this out and let you know how I get on 👍.
@martinpetrek216622 күн бұрын
Good work! Perfectly explained.👌
@andrewhess12322 күн бұрын
Thanks, an oldie but a goodie
@user-mc1cs5jw3f24 күн бұрын
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
@andrewhess12324 күн бұрын
谢谢!很高兴这个视频能帮到您!
@alondraespinal511525 күн бұрын
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.
@andrewhess12324 күн бұрын
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.
@bluric025 күн бұрын
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?
@PondyBS26 күн бұрын
Thank you Andew! For your video is a stunning easy to understand, I like to appreciate you.
@andrewhess12326 күн бұрын
Thank you so much!
@imran002ali26 күн бұрын
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!! 👍👍
@andrewhess12326 күн бұрын
Level up!
@imran002ali26 күн бұрын
Hi Andrew, great information, appreciate sharing your knowledge. 👍
@andrewhess12326 күн бұрын
Thank you Imran for still watching! Appreciate you!
@gerardoojeda808927 күн бұрын
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 ?
@andrewhess12327 күн бұрын
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 .
@mounirzouita110127 күн бұрын
@andrewhess how can we patch empty value in combobox and patch that to the optionset in dataverse or sharepoint please ?
@AlexFergus-t7t28 күн бұрын
Thank you so much for mentioning about the AllowNewAPI right off the bat. Drove me nuts until I found your video. Thank you
@andrewhess12328 күн бұрын
Woohoo! Nice Alex!
@manjunathak48225 күн бұрын
same case, thanks for mentioning about AllowNewAPI
@Lokasher-A28 күн бұрын
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?
@andrewhess12328 күн бұрын
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-A27 күн бұрын
@@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 🤣.
@andrewhess12327 күн бұрын
@@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-A27 күн бұрын
@@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?
@andrewhess12327 күн бұрын
@@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.
@begumdost38128 күн бұрын
why dont we close the <tr> with </tr>
@andrewhess12328 күн бұрын
Most likely can, probably just a mistake I made
@MCSurvivalMode28 күн бұрын
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.
@andrewhess12328 күн бұрын
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.
@saeedsm5728 күн бұрын
100% Useful! Thanks Andrew!
@andrewhess12328 күн бұрын
Thank you Saeed!
@beecee920729 күн бұрын
Thank you Andrew this is amazing stuff!
@andrewhess12329 күн бұрын
Thanks for your continuous support bee!
@waleedkhan250029 күн бұрын
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
@andrewhess12329 күн бұрын
Hi Waleed! That would be amazing stuff to do! Got some learning to do!
@fanyuan29 күн бұрын
Hey Andrew, would like to check how to do the inverse? Availability Calendar?
@andrewhess12324 күн бұрын
Hi Fanyuan, there is an old template that uses room reservations that does this. Would need to reverse engineer that template.
@hammadyounas268829 күн бұрын
Great Work Sir, Did it work for get attachment content?
@andrewhess12329 күн бұрын
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.
@hammadyounas268829 күн бұрын
@@andrewhess123 Thanks Sir. I will test it. Hopefully it works
@starbusttweety11 күн бұрын
In power automate cloud the model is taking too long to train. The internet is fine. What should I do?