how to export data from powerapps to excel(by user), I know there is CDM table export but I do not want user to see entire CDM table.
I need a functionality in powerapps that exports current screen set data to excel, pdf, word etc.
Solved! Go to Solution.
I still think the issue is with your Attachments Name parameter. I am not sure what DisplayName is, I do not see that option in my flow...
you are right!
I tried sample test without any attachment and its failing with same message-
Do you want me to recreate the steps?
thanks! What I am looking for is directly sending email to current user with search filter result in csv without having to put additional complexity of flow and one drive.
OK, did it!
Basically I have got rid of One Drive, but we still need Flow. That is not a major problem since Flow seems to work really well.
I have also discovered a bug that I have reported in a separate post, so it requires a hack.
another big issue-
Now I have 100k records and I added a filter with created by as me. Now when I export it only exports 500 records but with my username it has 40k records created by my. I need this 40k records exported in csv and send it via email. This is very important and I need good performance.
Hi, this is an issue. I have contributed to many posts in relation to the 500 item limit.
There is no easy way around this in PowerApps.
Then you could try an alternative approach. In Flow you can get all the records of your CDS entity and then create the email attachment with string functions in Flow using the For Each loop etc. However I don't know if this item limit also applies to Flow.
This is just an initial idea, sorry I can't be of more help.
Hopefully sometime soon we will have strored procedures in CDS and then it could be easier.
posted a new thread for this really imp. limitation-
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.