cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mp3909
New Member

Export Data to Excel File

I am new to Flow.

I would like to know if Microsoft Flow can be incorporated into any steps mentioned below:

 

1). Have a button in my power app that can check if a csv file exits in a local directory

2). If file does exist then import the contents of that csv file into Power BI Desktop

3). Do some manipulation to the data in Power BI Desktop

4). Then have a button in my app that would output the contents from Power BI Desktop to an xlsx file and save that file in a local folder with naming convention of the file containing datetime stamp

5). Have a button in my app that would send this file to a predefined distribution list of receipients. 

 

Thank You.

 

1 REPLY 1
v-zhos-msft
Solution Sage
Solution Sage

Hi @mp3909 ,

I think MS flow can achieve the first three steps currently.

You can transfer the csv file name from App to flow.

Then use the condition if the file is in the local directory.

Then add data to the PowerBI.

I have made a flow for your scenario, please check it for a reference.

Capture10.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (34,972)