Unanswered

Store per User Data for application

(0) Share

Report

Posted on by JulianM

Hi there!

I want to build an app, which contains articles written by different users. Those articles are stored in a SharePoint list.

Now I want to include a function for marking single articles as favorites and make a screen, that contains all the articles the user set as favorites to access them quickly.

Option 1:

Saving the data locally on the device, which could be a kind of workaround but is not really what I'm looking for.

Option 2:

Is there some kind of way to user e.g. the private ondrive of each user for saving the metadata (small table with Article ID) that contains the data based on the logged in user.

Would there be a way to achieve this or can you recommend an other way? (preferable cross device and not locally) Which is suitable for my favorites scenario or app preferences for each user

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

adamtj 79 on at

Like (0)

Report
Hi @JulianM ,

My approach would be something like this:

Create a sharepoint list called eg "UserFavorites" with the fields "ArticleID" and "User".
Create a button or icon that the user can select a article as favorite, OnSelect you will patch a record to the "UserFavorites" list.
Patch( UserFavorites; Defaults(UserFavorites); { ArticleID: ThisItem.ID; User: User().email } )

On the "My favorites" screen use a gallery and set items to the UserFavorite list.
Filter(UserFavorites; User = User().email)

And inside the gallery item you can do a lookup based on the article ID
LookUp('MyArticleDatasource'; ID = ThisItem.ArticleID).'desired field'

You probaly want some logic to check if the article alredy is in the users favorite list, but something like this perhaps?

Was this reply helpful? Yes No
JulianM 61 on at

Like (0)

Report

Hi @adamtj
thanks for your fast response!

This would definitely be a way to go and I also thought of it before.
OFC this would be a suitable solution for my approach but do you know if there is any kind of way to "generate" a specific data container of any kind for every single user, so the data is stored separately for every user?

But I definitely think this would be a way to go. Do you think it affects performance if I store all the favorites in one table

Was this reply helpful? Yes No
adamtj 79 on at

Like (0)

Report

Hi!

To my knowledge the are not any specific place to store user settings/data.
Regarding performance, no cant se any performance issues with that. Unless your favorite list will be +30 milj rows 🙂

Was this reply helpful? Yes No