Unanswered

better data source for power apps

(0) Share

Report

Posted on by exploringG

Dear Power Appers,

I'm now facing an inconvenient situation with my App. I've designed an App for users to enter their time distribution for different projects monthly. All data is stored in Share Point list. But projects are meant to change. After awhile, some projects will be finished and new projects will be added. In order to add or remove projects, I need to do it manually.

I'm wondering if there is a way for my users to do this. I know that users cannot add columns in SH list or change them from Power Apps. And I know there is a way of storing data in SH list is Parent/Child related lists. From my understanding, it is not suitable for my purpose. There are different types of data source for Power Apps. Is there a more flexible data source which can achieve my requirements?

Here I am again and looking for better ideas. Thanks for your help in advance.

Best,

exploring G

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Fredrik_A 3,644 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

We usually use SharePoint as datasource when we have a requirement for the end-user/someone in the company, to get a good and quick overview of the data from the "back-end" which SharePoint helps us with.

If you want a more "Database" like strucutre id say dataverse is probably more suitable but it depends on what other requirements you have.

You can have look-up columns in a SharePoint list which is kind of (Maybe far fetched) like a child-parent relation since one or many rows point to one or many rows in another list.

Here is a link for dataverse: What is Microsoft Dataverse? - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
exploringG 82 on at

Like (0)

Report
Copy link

Link copied!

Hi @StretchFredrik ,

thank you for the ideas. About look-up column in SP list, I have investigated this method. However, I need my SP list to be in certain structure so that I can export it as csv file for further analysis. If I create a look-up column, there will be two SP lists and also the structure of the child-list will be different from the parent-list. Then there will be more work involved to process the data after exporting them from SP list. Part of the purpose of creating this App is to reduce such work. That's why I'm thinking of changing the data source. Maybe other type of data source could give me more flexibility of storing data. Moreover, easier handling of the data afterwards.

Best,
exploring G

Was this reply helpful? Yes No