cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Englishweb
Level 8

Flow to import / update SP list from Excel, but Powerapps locked (cannot save data)

Hello

I have a flow which imports and updates from an Excel spreadsheet to a SP list.

I've created an app which uses the same Excel spreadsheet as its datasource.

However, when the flow is turned on PowerApps cannot save data  (I get a 'locked source' message). (As soon as the flow is disabled I can write to the spreadsheet again)

I presume the problem is linked to Excel and PowerApps referencing the same datasource.

Is there a solution / workaround for this?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Englishweb
Level 8

Re: Flow to import / update SP list from Excel, but Powerapps locked (cannot save data)

Hello @v-alzhan-msft 

Thanks for your reply. Your answer confirms what I supsected!

I was hoping that the spreadsheet would only be locked when the flow is actually running (eg once a week), but it seems that the spreadsheet is locked permanently.😞

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Flow to import / update SP list from Excel, but Powerapps locked (cannot save data)

Hi @Englishweb ,

 

I'm afraid that there is no workaround for the issue since when the excel is used in the flow, it would be locked by the flow and wouldn't updated by any other apps at the same time.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Englishweb
Level 8

Re: Flow to import / update SP list from Excel, but Powerapps locked (cannot save data)

Hello @v-alzhan-msft 

Thanks for your reply. Your answer confirms what I supsected!

I was hoping that the spreadsheet would only be locked when the flow is actually running (eg once a week), but it seems that the spreadsheet is locked permanently.😞

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,209)