Visible by 'Created by' column in Sharepoint

[Anonymous]

Hi All,

I am trying to create a button that gets visible for the users who have created a "ticket" in my Gallery list. Their names are recorded in the 'create by' column in Sharepoint.

Is there any formula that can make this able?

I hope someone can help me 🙂

Thanks in advance!

Ramon

[eka24]

On your Gallery items put:
Filter( TestTable, 'Created By' = User().Email)

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

[Anonymous]

Hi @eka24,

If I read that formula correctly it will filter the "tickets" on the Gallerylist, but my idea was that everyone could see all the tickets in the Gallarylist, but only the person who created the "ticket" can open/edit the "ticket".

Is there a way to create this?

[eka24]

To edit or not was not part of your question. Now that you want it, select the datacard that has the ticket. Then on its Displaymode in the put: If(emailDatacardValue=User().Emal.Displaymode.Edit,Displaymode.View)

emailDatacardValue is the field that holds user email

[Anonymous]

Correct to Edit isn't part of my question, I mentioned it to try to describe the desired situation.

It is more like how to create a button that gets visible for the users who have created (so only they can select it)

With your informtion i've tried something like

(visable) If(DataCardValue63=User().FullName,true,false)

Datacardvalue is based on the 'created by"column but this doesn't work.

Any ideas?

[eka24]

What is the name of the datacardvalue that has the Ticket. Is it DataCardValue63 then If(DataCardValue63.Text=User().FullName,true,false) should work.

I also assume you have a field on your form for email?

[Anonymous]

What do you mean by "What is the name of the datacardvalue that has the Ticket"? 

In my form I don't have the field which asks for email. But in Sharepoint there is an automatic "create by" column that register the Fullname of the person who created the ticket, so I mentioned to try that.

I've added DataCardValue63 in the review page to try to link the datavaluecard in de formula but it looks like it dont work.

Right now i've tried If(ThisItem.'Created By'.value=User().FullName,true,false) but this also gives me an error. "Invalid argument type"

[v-yutliu-msft · Accepted solution]

Hi @Anonymous ,

Do you want to insert an edit button inside the gallery and only make the button visible if the item's creator is current user?

If so, you need to compare two value: the item's creator's Email and current user's Email.

You could use "Created By.Email" to represent the item's creator's Email.

Use "User().Email" to represent  current user's Email.

I've made a similar test for your reference:
1)click the pen icon on the left top of the gallery to insert button inside the gallery.

2)set the button's Visible:

If(ThisItem.'Created By'.Email=User().Email,true,false)

Then the edit button's visible will be decided by whether current user is the item's creator.

Best regards,

[Anonymous]

Hi @v-yutliu-msft,

This is exactly what I needed!

It didn't really needed to be a Edit button, but I can use the formula for my desired solution.

Thanks!

[pgeory]

I have the same situation however, the item "created by" is a display name. I have been told to use Office365Users connector and I have tried;

Visible if(thisitem.'created by' = (office365users.userprofileV2(User().Email).Displayname,true,false)

I can't get it to work though. any suggestions.