Unanswered

Writing in real time to excel spreadsheet

(0) Share

Report

Posted on by MichaelYe

Hello,
I am building a manufacturing management systems using PowerApps as the client side and excel online as the database.
I want to show real time progress in the excel file while a user is filling in data in the app.

however, the data will not write in real time, I am required close the excel file while using the app or I get a merging error.

Is this even possible using the Office 365? I built something very similes in Google and it worked smoothly.

Thanks in advance for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

eka24 20,923 on at

Like (1)

Report

You will get real time output but the excel file has to be closed for it to be updated.

If you don't want to excel closed, then consider another Datasource like SharePoint or CDS or SQL.

Anyway why do you want the excel file opened while saving?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
MichaelYe 14 on at

Like (0)

Report

Because I want to show the manufacturing progression live on a monitor.
I build the thing in Google Sheets:

The file reads the data from different sources and shows a map of the process, the monitor is always on and shows the progress live.
Is there a way to recreate it using office 365? without the need of a SQL DB?

Thanks in advance

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Please clarify is the App connected to excel or Google sheets?
If is connected to excel and the dashboard is in Google sheets, then you can close the Excel.

A better approach is to do the dashboard in Powerapps. That way excel could be close while Powerapps update.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
MichaelYe 14 on at

Like (0)

Report

The entire app is connected to an excel spreadsheet, it's one large excel file that contains a table in each sheet, and one dashboard sheet that reads the data from all the others.
before using powerapps I built the same app using Google Script and Google Sheets, and now I am trying to recreate it in Office 365.
Google sheets allow's you to keep the file open 24/7 and still write data into it.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Well for excel you have to close the it while updating it. Some of the ways of going around it is what I have already stated.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No