Unanswered

icon should be visible when the user email is listed

(1) Share

Report

Posted on by KevinGador

822 Super User 2025 Season 2

I am just trying to find out whats my mistake in my formula

I have a gallery where there is an icon that is supposed to be visible if the current user is listed in that specific column named isDownloadedBy

my varCurrent user definition:

Set(varCurrentUser, User().Email); 

here is the button that downloads the file which patches the user's email to the column. I have checked the list and what email was patched and it is all in lowercase.

ForAll(
    Filter(galDownloadNDAFiles.AllItems, cbSelectFile_ADFS.Value = true), 

    //for each selected record, download the file
    Download(
        "https://xyz.sharepoint.com/sites/xyz/_layouts/15/download.aspx?" & "SourceUrl=https://xyz.sharepoint.com/sites/xyz/" & ThisRecord.'Full Path'
    ); 


    //put the email of the user who downloads the file
    Patch(
        'Uploads', 
        ThisRecord,
        {
            isDownloadedBy: 
                If(
                    IsBlank(ThisRecord.isDownloadedBy), 
                    varCurrentUser,
                    ThisRecord.isDownloadedBy & ", "& varCurrentUser
                )
        }
    );
)

heres my visible property formula for the icon inside the gallery.

With(
    {
        splitAdmins: Split(ThisItem.isDownloadedBy, ",")
    }, 
    varCurrentUser in ForAll(splitAdmins, Lower(Trim(Value)))
)

doesn't seem to work even though my email is listed in the column.

Categories:

Error handling

I have the same question (0)

All responses (6)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi!

Can you please share an example values for both the var and isDownloadedBy? Without that it's a guessing game.

Perhaps the issue is that there are calitals in the variable value. This can be fixed by using the Lower fuction:

Set(varCurrentUser, Lower(User().Email));

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report
@KevinGador Hi,

This totally depends on your 'isDownloadedBy' value,

If it has values like full name, it will absolutely not work.

and the code you have , it's better to use :

With( { splitAdmins: Split(Gallery1.Selected.Value ,",") }, !IsEmpty( Filter( splitAdmins, Lower(Trim(Value)) = Lower(Trim(varCurrentUser)) ) ) )

Also, you have to consider the empty value.

So, please check what is the value in isDownloadedBy, if it contains full name, the varCurrentUser should have User().Fullname

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (0)

Report

Apologies for posting a question with incomplete codes.

I have updated the post with the download button functionality which puts the user's email in the isDownloadedBy column.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi!

Still it's hard to give feedback without seeing sample values.

What is clear from the additional formula is the delimeter that is used. Based on this, the formula for the visible propert of the icon can be simplified to:

Lower(varCurrentUser) in Split( ThisItem.isDownloadedBy, ", " )

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

@KevinGador Hi,

I think your with (......) won't reflect the updated record immediately after the patch. At least I didn't see it from your description.

After For All, add :

Refresh('Uploads') // assume this is your gallery data source, otherwise change it to your gallery data source.

Then you will get the patched result.

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (1)

Report

@stampcoin ahh yess! This is the case! I can now see the check. I ddn't realize that it needs refreshing.

Was this reply helpful? Yes No