Always good to see the extensibility through things like this. It fills gaps in the product. Thanks. Yash for creating them and for April for explaining how to install and use them. Great work
@AprilDunnam
3 жыл бұрын
Thanks Phil!
@zaidkashour
3 жыл бұрын
I used to do this but with Power Automate but now this saves us time. This is the best tutorial I have seen this year!
@AprilDunnam
3 жыл бұрын
Wow thanks Zaid!
@马勒-n3y
Жыл бұрын
@@AprilDunnam Do you know what is the difference between this way and power automate flow? which one should be the best practice
@hchemas1
2 жыл бұрын
Excellent component, Works perfectly, only improvement I see is send numeric data a numbers in Excel instead of text. But this one is definitely much better and cleaner than creating a Power Automate Flow to export data from a gallery to Excel.
@handekurtur2518
3 жыл бұрын
It is really nice feature but it gives an error when i import zip file to solutions :( Solution "BTD-ExportExcel" failed to import: Import Solution Failed: CustomControl with name contoso.excelexport failed to import with error: Principal user (Id=8d .....
@MakePositiveImpact
3 жыл бұрын
Love it; April. This is exactly what I was looking for. Thank you !!
@AprilDunnam
3 жыл бұрын
Awesome - glad it was helpful Ramesh!
@juansepowerplatform
3 жыл бұрын
Thank you. This functionality was really needed.
@AprilDunnam
3 жыл бұрын
Glad it helped!
@maefinrodriguez6285
3 жыл бұрын
Amazing! I've tried it and it really works well. This is a really big help, thank you so much for sharing this April.
@AprilDunnam
3 жыл бұрын
Glad it was helpful and it working for you!
@juandavila4035
3 жыл бұрын
Thank you to share your knowledge , that is perfect.
@AprilDunnam
3 жыл бұрын
Glad it was helpful!
@komanguy
3 жыл бұрын
Merci beaucoup. I was looking for such a solution and you made my day. One again, thank you very much!
@AprilDunnam
3 жыл бұрын
You're very welcome - glad it was helpful! 🙂
@ShihChiWang
3 жыл бұрын
Good to know this. But unfortunately, my company doesn't give me the authority to import this solution to our environment. I have tried this in my personal trial environment, it's workable. Hope they can help with this and then I can implement it in my current apps. Thank you for sharing.
@AprilDunnam
3 жыл бұрын
I hope you can get someone to import the component for you!
@kittydoes7600
3 жыл бұрын
@@AprilDunnam same case here. Is it possible for us to recreate the component inside Powerapps?
@prakashcrank6185
3 жыл бұрын
The works good in desktop browsers, but in mobile app not working. Any idea?
@Test27344
3 жыл бұрын
Love it! Thank you and Yash so much!!
@AprilDunnam
3 жыл бұрын
Glad you enjoyed it!
@bregan507you
Ай бұрын
Hi April, thank you for posting this video. I've implemented this and it works great, but I've noticed that the Rich text input can sometimes cause problems...and it happens if the user inputs a TAB or a NEWLINE. The code below will overcome this problem. It escapes double quotes, filters out html, removes TAB, NEWLINE and CARRIAGE RETURN. I hope this can help someone else. Thanks. Substitute( Concatenate( "[", Concat( colData3, "{" & Char(34) & "RichTextInput" & Char(34) & ":" & Char(34) & Substitute(Substitute(Substitute(Substitute(PlainText(RichTextInput),"""",""),Char(9),""),Char(10),""),Char(13),"")& Char(34) &"}," ), "]" ), ",]", "]" )
@elmasinvisible007
2 жыл бұрын
Hello April, thank you for your videos, I followed the instruction step by step. I see the previous the data to export but I click on Export to excel button no data come up in the excelsheet. Also, only on Microsoft edge the popup export comes up.
@joepthomassen
3 жыл бұрын
Great, I was looking for this and it brings almost exactly what I needed. Only see an issue with exporting numbers, Excel doesn't see them as numbers and then it cannot do calculations with this. Obviously it can be solved in Excel but would be great if the list can be exported with numbers straight away. Do you have any idea/suggestion for that? Thanks.
@rameshmr931
2 жыл бұрын
Thank you April. It really helped a lot. I have one doubt though. While i was using the component some of the text fields inside the gallery is using lookup conditions in their default properties. So how can I give it in the dataexport property ? Hope you will help me with this.
@chaule9529
2 жыл бұрын
Thank you so much April!! This has worked great for me but I can't seem to get the multi-line text field or even a long text field to export. When I comment them out, the file export just fine. Can you give me some help on this?
@jayantkhushalani8639
3 жыл бұрын
Thank you April for such a great video and Yash for building a great component. However, there is one issue with all the export to excel functionality which is the output part. It does not come formatted, how can we make that happen since the output that comes out in the file is pretty much like csv.
@leeandy2326
3 жыл бұрын
The component worked great in creating the excel report. But I have a small question: If I want to hide the component and call it from another control like the button Select(). Is it possible? (I want to do it because the design of the component doesn't look so attractive for me ;) )
@AprilDunnam
3 жыл бұрын
Hmmm I'm not sure that there's a way to do that because the trigger is on the component itself
@jarekgazik
3 жыл бұрын
Hi April. Thx for this. Indeed super useful. I'm new to PowerApps. Do you know how to add this component to "trusted components" (or something similar") to get rid of annoying "this app might contain unsafe code" warning?
@wllsouza
2 жыл бұрын
Hello .. tks for that explanation!!!! So, I have a "collect" from that an Ibiuld .. I s it possible to do there too ?
@IvanaMilovanovic994
Жыл бұрын
Hello! Thank you for this video. I have a question. How do I write the code if one of my columns is multiple lines of text (I use SP lists)?
@lumierenk5652
3 жыл бұрын
Thank you sooooo much April. I have a question please. If the list is huge; more than 800 items will it still export it all in excel?
@AprilDunnam
3 жыл бұрын
I would have to test it to say for certain but I think it will
@MattSchuessler
3 жыл бұрын
What does a maker need to consider when using a PCF? For example, is there a scenario where a piece of tech that was used in the PCF has been updated or deprecated and could break the component or app?
@kmuralikrishna1582
3 жыл бұрын
Really appreciate April.. How to dynamically generate json code .? Instead of hardcode JSON entering manually
@AprilDunnam
3 жыл бұрын
In the video I am dynamically producing the JSON by looping through a collection of items
@sundrapillay6668
3 жыл бұрын
Thanks April thanks for sharing
@AprilDunnam
3 жыл бұрын
Thanks for watching!
@chuatrum17
3 жыл бұрын
Thanks for your great video! By the way, Do you have any advice for Import process ?
@AprilDunnam
3 жыл бұрын
Imports can typically be done at the data source layer and that would depend on what data source you are using.
@chuatrum17
3 жыл бұрын
@@AprilDunnam since our client want to import data directly from Powerapps and the only with I can think of is using “Patch” and the performance is really slow... FYI, the export pcf component seems not work with native app - Clicking the export button does nothing with Desktop App
@kiptanoi4422
Жыл бұрын
Does it need to be in gallery or collection to be able to export data from Power Apps to ex. Excel?
@mustafahussainmohsin320
3 жыл бұрын
Hello April, Thanks for the video but I want to create the Excel file in a table Structure it looks like a CSV. any help?
@AprilDunnam
3 жыл бұрын
This component won't do that as-is. I'm not aware of a component that's built that does that. I would check powerusers.microsoft.com and see if anyone has a community component that does that.
@diegoalias2935
2 жыл бұрын
Amazing, thanks a lot!
@AprilDunnam
2 жыл бұрын
You're welcome - thanks for watching!
@ahmedmoataz1534
3 жыл бұрын
thanks for your effort, and kindly if you can share how to create tree view in power apps
@AprilDunnam
3 жыл бұрын
Hey Ahmed - Todd Baginski has a good video showing how to create a tree view: kzitem.info/news/bejne/qW6IsX6kgXeIp4I
@toddmacpherson
Жыл бұрын
I have attempted this today and it does not work and no errors,. Not sure where to look to fix it. Any ideas? Thank you.
@agustinmisaza
3 жыл бұрын
Hello April, Thank you, I am not able to use it on my phone. The buttom does not press. Any solutions to this?
@carlosgarcia1780
3 жыл бұрын
The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported.
@comotiborges716
3 жыл бұрын
Hello, i dont know if you can help me, but i'm have a problem to export data from a text card with multiple lines. if I click on enter to skip a line for example it doesn't export, but if I'm typing without skipping lines it exports normally, would you know how to help me?
@gianlucagiudici1444
Жыл бұрын
Good Morning and very thank's to April!a question... it's ok un desktop version (by Browser) but don't match on App Mobile, is it possible? I use an Android device and if i use browser it all ok, but if i use by App (Power Apps) don't match... you can help me please???
@desiabhay
3 жыл бұрын
There's a 2000 record limit in powerapps which renders it useless for data intensive apps that have 5k-10k rows. How do I handle the export of 2k+ rows to excel?
@jhonatanorabadillo
Жыл бұрын
Hello April. Please, could you help me with a question about the plugin. It happens that from one moment to another it stopped working, that is, at the moment of clicking on the button, Excel is no longer downloaded, the strange thing is that when I insert a new component, it does download, but it accepts fewer columns. Another point is that if I want to add new values (For example a multiline type column), it doesn't work either. Beforehand thank you very much! Cheers, Jonathan Ora Badillo
@mallikarjunjk219
2 жыл бұрын
Hi Can you please help me with possible solution for the below problem. Purchase Schedule Qty Exp. Goods Receipt Date 50 31-Mar 50 30-Apr 50 31-May 25 30-Jun Sales Schedule Qty Exp. Ship Date 125 01-Jun 50 15-Jul Input- Purchase schedule and sales Schedule Output- Table reflecting how Purchased Qty and from which Goods Receipt Date can be consumed from purchase schedule to meet the sale schedule. ie. To meet sale schedule of Qty 125 for of 1st Jun, we need to consume whole qty of 31st March and 30Th Apr and 25 qty from 31st May. And left out 25 qty of 31st May will used for 15th Jul sale schedule.
@hungbuithanh556
3 жыл бұрын
Export Excel error When I try to export a data gallery, export not work if the data contains multiple line
@greciamunoz600
Жыл бұрын
Thank u so much!
@AprilDunnam
Жыл бұрын
You're welcome!
@comotiborges716
3 жыл бұрын
here it is an example: "test test test test test test test test test test test test test test test test test test test test " - this way it exports normaly "1. test test 2. test teste" - but this way it doesn't export
@aprilmills5925
Жыл бұрын
I work in an environment that won't allow us to open zipped files from outside the company network. Anyone know a way to create a buton that will kick off a flow to create an excel?
@qctrainingsolutions
3 жыл бұрын
The component only seems to work with very small amounts of data. As soon as I remove a filter from my gallery it fails without an error. Do you have any ideas?
@ristoharkonen
3 жыл бұрын
I found the same issue when gallery contains more rows. I changed the source of DataToExport to use same collection as gallery is using instead of using directly the gallery as datatoexport source. It solved the issue for me. Now export button exports all rows without any issues.
@joacoc5329
3 жыл бұрын
Hi April, I need the Excel encoding to be UTF-8, is this possible with this method, without having to modify it manually ?
@AprilDunnam
3 жыл бұрын
Hi there - unfortunately I don't think so :/
@rashidkhalid2010
3 жыл бұрын
Thanks April! However, it does not work in MS Edge. Any workarounds anyone found for that?
@anilrambhajan936
3 жыл бұрын
Hi Rashid, I just implemented this in MS Edge and it works as expected.
@EJA1969
3 жыл бұрын
I was able to successfully use this component less than a week ago, but today when I try to import it into an existing or new Canvas App, it fails without an error.
@AprilDunnam
3 жыл бұрын
There was probably a change in Power Apps that broke something with the component. Since this is a community built connector you can't guarantee that there won't be a breaking change as stuff is updated. You are probably better off utilizing Power Automate to export to Excel
@Saadssk94
3 жыл бұрын
for some reason this is not working for me on andoird but works fine on a browser does anyone face the same issue?
@martinwhite2369
3 ай бұрын
Anyone ever tried sending an image column to Excel like this? Or had any luck sending lookup values?
@6himanshusharma
3 жыл бұрын
Good, But Microsoft dynamics 365 version are not supported. Pls support.
@AprilDunnam
3 жыл бұрын
I'm not sure what you mean, do you mean it isn't working in a model driven app?
@6himanshusharma
3 жыл бұрын
@@AprilDunnam Yes. And May I export CSV on local desktop? 🙏
@investblog9790
3 жыл бұрын
Do you know how long time to import the solution? I gues my power app stuks on this step.
@AprilDunnam
3 жыл бұрын
It shouldn't take any longer than a half hour to import. If it's taking longer then there's probably another underlying issue like not having components turned on or not having the right permissions to add a code component in that environment.
@vidanaweer1662
3 жыл бұрын
Thanks, April, When I click on the export button it won't download the excel. Basically doing nothing. Any idea? Thanks.
@AprilDunnam
3 жыл бұрын
Are there any errors in the app? It's most likely an error with what you are passing in. The component is created by a community member so if there are any issues that come up I would reach out to them (Yash). But if you don't want to rely on the component then it might be best to leverage Power Automate to do the Excel export
@davidpiedrarojas
3 жыл бұрын
I had the same problem and was a problem on the JSON code, an extra "," at the end. Just doble check the JSON code.
@tuffley2175
3 жыл бұрын
👏👏👏👏
@AprilDunnam
3 жыл бұрын
Thanks!
@bzqp2
Жыл бұрын
Most of the options showed here don't even exist on the Teams version of Power Apps :(
@AprilDunnam
Жыл бұрын
Yeah unfortunately there isn't 100% feature parody with the Teams version and the stand alone version
@nibeditabarat4664
3 жыл бұрын
Hi April, I have clicked on Import button after selecting the zip file but it is 6 hours passed and still showing - Currently Importing Solution "BTD-ExportExcel".
@AprilDunnam
3 жыл бұрын
Usually when that happens it's a permissions or settings issue. You need to be a system customizer permission level to import a code component solution like this. The other thing it could be is settings on the environment you're importing into
@nibeditabarat4664
3 жыл бұрын
@@AprilDunnam Thanks April. I'll check it.
@nibeditabarat4664
3 жыл бұрын
@@AprilDunnam I am able to resolve the permission issue and now the solution is imported. But in app clicking on Import Component, no code section or component are shown.
@knoweverthingsuccessfullif7937
3 жыл бұрын
Hi April , while importing solution, I am getting error .solution "BTD-ExportExcel" failed to import , custom control with name controls.excelexport failed to import with error : principal user ..... etc.. can you help me to fix this error. This is my exact requirement.
@AprilDunnam
3 жыл бұрын
Did you enable the canvas code components feature in your environment? That's most likely the issue - here's a link that talks through how to do that: docs.microsoft.com/en-us/powerapps/developer/component-framework/component-framework-for-canvas-apps
@raulcabezasestrada1877
3 жыл бұрын
When i import there is an error message "Import Solution failed: CustomControl with name contoso.excelexport failed to importi with error: Principal user ...." What can i do?
@AprilDunnam
3 жыл бұрын
Double check if you enabled component framework for Power Apps in the admin center. Also, you might be better off leveraging a flow to export to excel as that has less restrictions.
@titusjv360
3 жыл бұрын
where can I able to find out that print function??
The user has not been assigned any License ~ getting this error while importing
@AprilDunnam
3 жыл бұрын
HI Shubham - That is because you need to have a Power Apps paid plan to import a solution
@leomaredcampos4941
2 жыл бұрын
I can't upload the file
@AprilDunnam
2 жыл бұрын
More details would be helpful. Are you getting an error? Most likely this is because there's a setting that needs to be enabled in your admin center to allow uploading these types of components (PCF).
@ishaanijk5822
Жыл бұрын
Not offended or anything Just trynna help you out While saying his name you're saying it the way you'd say 'rash' but with a y Instead say it like you'll say 'rush' but with a y
@AprilDunnam
Жыл бұрын
Thanks, I appreciate it
@elvisbazan57
3 жыл бұрын
No me funciono segui los pasos tal cual
@elmehdielyassmine3384
3 жыл бұрын
Hello April. i have a problem with this character (é or à...) when i export my file excel any help?
@AprilDunnam
3 жыл бұрын
Hey there - It's probably a special character encoding issue. You might have to escape that special character with a numerical code. I believe the correct one for an accent is `. This site show all the escape codes for different special characters: fantasai.tripod.com/FHQR/Characode/EscCodes.htm
Пікірлер: 108