Re: I want to fetch CDS entity data of a particular view and store it in CSV file
Hi @Tourist,
You can achieve this by querying the Views table, which will contain the FetchXML definition that can be passed into a following List Records action against your table (e.g. Account). Example below:
In your List Rows action, specify that you just need the fetchxml column, then filter by the view name parameter.
To avoid an apply to each action, you can use the first expression to get the only item from the list rows action, and the fetchxml value, passing that into the FetchXML parameter.
Expression: first(outputs('List_rows_-_Get_View')?['body/value'])?['fetchxml']
Finally, you can use the Create CSV Table action, where you can either use all the columns from the output, or manually pick which columns you want in the CSV. Then you can use the OneDrive or SharePoint connector to create a file in a folder, using the CSV output as the content.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
