I’ve gone through all the comments and scenarios shared above. If your requirement is only to generate the CSV file and you don’t want to download it directly or save it to SharePoint/OneDrive, you can email the CSV file directly to the requester.
Suggested approach:
#1. Add one more parameter in the Power Apps -> Flow trigger to pass the logged-in user’s email address. In Power Apps, the User().Email function returns the currently logged-in user’s email, which you can pass directly to the flow.
Your Power Automate trigger with user email parameter.
after adding this login user parameter in automate just refresh the Power Automate in PowerApps.
PowerAutomate.Run(User().Email);
//Your Power Automate trigger should be configured like this. Inside the trigger, add a parameter so that you can pass the value from Power Apps.
User().Email //This function will return current login user email..
#2. After the Create CSV table step in your flow, use Send an email (V2).
#3. Attach the CSV output directly as an email attachment (use the CSV table output as file content).
#4. Set the file name using the same value you already created in the Compose file name step.
#5. From Power Apps, after triggering the flow, just use the Notify() function to show a message like:
Notify("Your file is being generated and will be sent to your email within 1–2 minutes.");
This way, the flow knows exactly which user requested the file and can use that email address later to send the generated CSV as an email attachment.
Hope this helps!
📩 Need more help? Mention@Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.
