Unanswered

Using a Power App to save to excel but need a new page

(0) Share

Report

Posted on by SH0lm3s

Hi our maintenance guy has to do various health and safety checks of racking etc. He currently takes a semi pre-populated printed out spreadsheet to record these check. Now each rack needs (so I'm informed) its own sheet that shows the checks it went through that week and currently these are all kept in a hard copy file, is there a way of using a power app to populate this data (therefore our maintenance guy can use his phone) and save the check to a printed out form (pdf) for audit purposes? Would I need to have a power automate involved as well as the power app? The only way I know how to save data to a spreadsheet is by having it already associated with a table in it.

Any help pointers much appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

subsguts 1,259 Moderator on at

Like (1)

Report
Copy link

Link copied!

As far as your first question, I would create a PowerApp so the checks can be done and stored in a datasource. If anyone wants to audit it, etc. you can create reports, etc. from PowerBI and/or a Audit Screen inside another PowerApp or a screen within the PowerApp you write for the maintenance guy.

On your second question, I've only see exports to excel from PowerApps using PowerAutomate and creating a flow. Maybe it's possible without PowerAutomate, but that appears to be the standard way and there will be lots of examples on how to do this.

Hope this helps point you in the right direction.

Was this reply helpful? Yes No
SH0lm3s 46 on at

Like (0)

Report
Copy link

Link copied!

Thanks @subsguts, I hadn't thought of using PowerBI to get the data out, I think that that would work well. Much appreciated.

Was this reply helpful? Yes No