0

I'm envisioning having an agreed upon budget that I store on the cloud and having folks submit 'invoices' based off that budget.

Question 1) I want to have the invoicer be able to select from multiple types of expense, draw from multiple piles of funds, and have input validation assure them that they are inputting correctly. Which back-end data service is best? OneDrive via an Excel file? Some kind of Sharepoint resource I should look into?

Question 2) I completed the PowerApps tutorial and they had me copy-pasting code. What language of code is this? Is it possible to do everything without code?

Question 3) Where's the best place to ask PowerApps questions besides this subreddit? Stackexchange?

Thanks!

Improve this question

1 Answer 1

Reset to default
0

PowerApps is a good approach to start this. Consider based on on-going budget and almost write less code or no code solution

  1. SharePoint - Because you can use the same license with PowerApps plan(other are definitely good but it will gonna cost little bit extra. There is no straightforward metadata extraction you need to open the files manually to correct the code to do this process. But if you use SharePoint list then can directly go there and edit item as appropriate). Also, If you choose SharePoint it comes with OOTB Workflow and CMS capabilities.

  2. PowerApps is no-code or rather less-code(depend upon needs in your use case) platform but gives us the rich capability to design screen. However to apply business logic we need to use easy excel like forumlas with an in-built function for easy to complex tasks.

It also provides rich set of connectors from MSFlow to Azure Functions.

Related Articles:

  • Create an app from scratch - here, here

  • Custom connectors - here

  • Building flows - here

Improve this answer
2
  • thanks @little_big_thoughts (apparently the @ mentions don't work on Stack Exchange) Anyway, this is great, I'll get started. Any go-to resources for how to correctly do SharePoint Lists? For example, when I was dabbling in MS Access a few years ago, I learned about normalization and naming conventions.
    – zzzjoshzzz
    Commented Dec 22, 2017 at 17:18
  • Glad that it helps you! Refer Detailed Microsoft recommendation/steps/Known issues to use SharePoint as a Datasource for PowerApps. docs.microsoft.com/en-us/powerapps/connections/…
    – little_big_thoughts
    Commented Dec 22, 2017 at 17:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.