You’re offline. This is a read only version of the page.
I have a Cognito form that I want to build a flow to export the entries weekly to an Excel file. The only connector that I see that looks right is to get file , but I'm not seeing anything on Cognito that would give me the file link.
Are you using the trigger for this? I would think you could use the When a new entry is created trigger to grab the form's data and insert it into an Excel file stored either locally or in a SharePoint site. I would think this works the same way that Microsoft Forms does, but I've never used Cognito Forms so I couldn't tell you definitively.
Alternatively, if you want an easier solution that isn't fully automated, because I personally don't like dealing with Excel, you can have the data go into a SharePoint list and manually export it to Excel from the list itself. But if you'd like to go down the fully automated route, there are plenty of resources out there that showcase how to do this. @RezaDorrani has a great video on this that can help you navigate the solution - Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email - YouTube
For a simpler and quicker approach, especially if you're going to have a lot of rows, you can take the data and place it into a SharePoint list. Then you can create a CSV table from the list, create a file in SharePoint using this table, get the file content of this newly created file, and finally send it to whomever you need to via email. Optionally, if you don't need to archive or keep the data, delete the file after it's emailed. If you aren't going to delete the file, make sure the file names will always be unique. I used the current timestamp to ensure this. My flow is using JSON as it's coming from Power Apps, but you should be able to utilize the Get items action instead. Here is a rough breakdown:
Hope this helps!
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
