Power Platform Community Forum Thread Details

I have a power app that allows users to input data into a SharePoint List. I want this data to be imported to a new sheet on a pre existing excel file from within the app. The reason for this is to connect the SharePoint List to the other sheet on the excel file to perform calculations.

Is this possible? If so what are the steps, thanks.

Categories:

Using flows

Hi @Jeff_J8

Are you saying that every time they "save" a new item (row in SharePoint list) or update it from within the Canvas App, you also want to write it to the Excel file?

Also you said to a New Excel spreadsheet, but how does the app determine if it should or shouldn't create a new sheet.

Need more concrete details, but you can certainly update an excel.

1. You can add a Trigger Flow to the SharePoint list that fires when an item is created or updated then have that flow write to excel (including creating a new sheet if you need)

2. or do it in your app

just need more details
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey