Travel Settlement and Expenses - application - is PowerApp good for it?

(0) Share

Report

Posted on by Toms

welcome,

case is simple, to create an app where user can create a settlement / travel report.

now we are using a big excel - with lots of calculation inside. (attachments)

is a PowerApp a good choice for this? as i need to do a lot of calculation inside PowerApps.

2020-03-04 12_08_22-Business Travel Settlement Template (1) - Excel.png

2020-03-04 12_10_42-Business Travel Settlement Template (1) - Excel.png

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

SkiDK 1,016 on at

Like (1)

Report
Copy link

Link copied!

Definitely. There a lot of controls to create clean layouts for your case and you can do a lot of calculations.
Maybe take a look a Model-drive apps as well, which is more form-like but a lot faster to build. With canvas apps though, you have more flexibility and control over the layout.

Was this reply helpful? Yes No
Toms 59 on at

Like (0)

Report
Copy link

Link copied!

Thanks !
i would like to go with Canvas.
what would be desired database? SharepointList is fine?

Was this reply helpful? Yes No
SkiDK 1,016 on at

Like (0)

Report
Copy link

Link copied!

Yes, SharePoint list is perfectly fine. That also makes it more easy to share it with whoever you need it to share with.
I actually have created something similar, so that employees can add business trips and then it gets stored in two SharePoint lists, one with data(primary one) and another Calendar list to link with Outlook.
Of course, it is important to look at the size of your lists if you want to work with a canvas app. Will it have over 2000 records?

Was this reply helpful? Yes No
Toms 59 on at

Like (0)

Report
Copy link

Link copied!

dont think so.

goal is, to create a report of out this data and sign this is by User and Manager(Accountant)
so after report is created - records are not so important

need to find some video tutorial how to start 🙂

Was this reply helpful? Yes No
SkiDK 1,016 on at

Like (0)

Report
Copy link

Link copied!

Oh, then it should be perfectly fine. Nothing important to take into account. PowerApps is great for the size of such cases.
Not very hard to learn as well. There should be a lot of good documentation, definitely take a look at this site: https://docs.microsoft.com/en-us/powerapps/powerapps-overview

Good luck!

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

Like (2)

Report
Copy link

Link copied!

With the structure of your report as the end product, I would suggest you either go with Excel or any other datasource plus Power Bi. In this case power Bi will be used to restructure the report to look similar as shown.
With excel for business and based on the scenario you have given I think I will be much easier.

Was this reply helpful? Yes No
Toms 59 on at

Like (1)

Report
Copy link

Link copied!

@eka24 i will consider excel as a datasource - never done this.
lets rock!

Was this reply helpful? Yes No