Solved: Store per User Data for application

JulianM · ‎12-19-2021

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!

adamtj · ‎12-19-2021

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?

View solution in original post

adamtj · ‎12-19-2021

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?

JulianM · ‎12-19-2021

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