13
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.
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
#1
WarrenBelz
146,708
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,030
Most Valuable Professional
Share
Report
All responses (
Answers (
