cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Termigez1
Helper I
Helper I

Save an excel file based on data from CDS

Hello,

 

I create a model-driven app. I have an entity "Project Periods"  (each project can have different periods)

Period Project
JanProject1
FebProject1
MarProject1

 

and entity "Volumes"

PeriodProjectModelVolume
JanProject1X1
JanProject1Y2
FebProject1X3

 

and entity "Models"

Model
X
Z

 

The flow will be run from "Project" entity using button on embedded canvas app. It needs to get current record's ProjectID and as a result save an excel/csv table that using tables aboce will look like this:

 

ModelJanFebMar
X13 
Y2  
Z   

 

It is easy for me to filter and list all necessary data but I really have no idea how to make the final step and pivot this data and save it to an excel file. The idea is that a user can export a blank table with listed models and periods as a columns (and if there are any already filled volumes they will be there too), fill it and import it again to app (but this is not the case for now, right now I just need to make it possible do export a file)

 

 

1 REPLY 1
rohentz
Community Support
Community Support

Hi @Termigez1 how are you?

 

@Termigez1 I think that you can create a Power Automate flow and call it from Power Apps passing some parameters, please check this article https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

 

At the flow, use the connector for Excel, SharePoint or One Drive to create the file, add a table to the file an add the information from those entities. 

 

Please let me know if this information helped on your question.

 

Regards.

Rodrigo Hentz

Microsoft Support Engineer

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,167)