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

(0) Share

Report

Posted on by Englishweb

371

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

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

v-alzhan-msft on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Englishweb 371 on at

Like (0)

Report
Copy link

Link copied!

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.😞

Was this reply helpful? Yes No