cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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
Highlighted
Post Patron
Post Patron

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
Highlighted
Community Support
Community Support

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.

Highlighted
Post Patron
Post Patron

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
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Users online (4,574)