Power Platform Community Forum Thread Details

Hi Community Members,

I am trying to make a Power App based Homepage.
I would want this homepage to link to some basic reports BI reports.
I also want the option for users to add their own favorite reports besides the main reportset.

Therefor I made a menu linked to a gallery, that has a menupoint to add a report available for the user to the favorits, and a separate menupoint for removal.

In the Gallery of the app, users can select to add an element to their favorites.
If they select an item in the gallery, a popup will show up.

If they click yes to this "Button1", I want the selected item to be exported to a SharePoint list called "User Dataset" .
Specifically in a Collumn called "UserFavorite_DS", and for that specific user.

I have 2 Connectors in the app an Office365Users Connector and a Sharepoint connector to "User Data" .
Have been trying to make it work, but wasnt able to.
Could I kindly ask for the community for help ?

I Have attached an example of my test dataset.
Please note that the UserFavorite_DS column in the SharePoint List is a "Person" Column type.

(Attila Liebmann already has some favorites, but this is only why I wanted to test some things so I added it manually in the list.)

I was experimenting with this formula, but I might be not on the right track :

// Get the current user's details using Office365Users connector
Set(currentUser,
    {
        DisplayName: User().FullName,
        Email: User().Email,
        UserPrincipalName: Office365Users.UserProfileV2(User().Email).userPrincipalName
    }
);
// Add or update the selected item in the SharePoint list
Patch(
    'User Dataset',  // Replace with your exact SharePoint list name if different
    LookUp(
        'User Dataset',
        Mail_DS = User().Email &&
        Bericht_DS = ThisRecord.Bericht_DS
    ),  // Find the item to update based on unique fields
    {
        UserFavorite_DS: {
            Claims: "i:0#.f|membership|" & Lower(currentUser.UserPrincipalName),
            DisplayName: currentUser.UserPrincipalName,
            Email: currentUser.Email
        }
    }
);





Please help! 

Thank you in advance

User Dataset Extr...

Categories:

Building Power Apps

hey

can u try this approach:

Set(currentUser,
    {
        DisplayName: User().FullName,
        Email: User().Email,
        UserPrincipalName: Office365Users.UserProfileV2(User().Email).userPrincipalName
    }
);

If(
    IsBlank(
        LookUp(
            'User Dataset',
            Mail_DS = currentUser.Email &&
            Bericht_DS = ThisRecord.Bericht_DS
        )
    ),
    Collect(
        'User Dataset',
        {
            Mail_DS: currentUser.Email,
            Bericht_DS: ThisRecord.Bericht_DS,
            UserFavorite_DS: {
                Claims: "i:0#.f|membership|" & Lower(currentUser.UserPrincipalName),
                DisplayName: currentUser.DisplayName,
                Email: currentUser.Email
            }
        }
    ),
    Patch(
        'User Dataset',
        LookUp(
            'User Dataset',
            Mail_DS = currentUser.Email &&
            Bericht_DS = ThisRecord.Bericht_DS
        ),
        {
            UserFavorite_DS: {
                Claims: "i:0#.f|membership|" & Lower(currentUser.UserPrincipalName),
                DisplayName: currentUser.DisplayName,
                Email: currentUser.Email
            }
        }
    )
);

button onselect:

Set(
    confirmationVisible,
    true
);

if my answer helped please mark as verified sanswer,

cheers

Community site session details

Exporting Gallery Data to Sharepoint - "Person" Column

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the January Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates