Compair text and table for deleting a value

[Shreya308]

• My SharePoint has a list name usertracker ( Username[type: People], Status [type: text])

In PowerApps I have a drop-down for Username at one side of the screen and on the other side it's a browsegallery which is showing the list data. 

Question:

I want to create a button which delete the value from the list. If the user choose his name from the drop-down and his name does exist in the list already. Button will be enabled and he can delete himself. If his name doesn't exist in the list button remains disabled

Error I am getting:  can not compair text and table . possibly because my coloum is people type. So remove is not working. I am very new to power apps. Please help

[v-mengmli-msft]

Hi @Shreya308 ,

Could you tell me the items of drop down and the code on the button?

Best regards,

Rimmon

[AndrewR1 · Accepted solution]

Hi @Shreya308 you can do the following to remove form the list in the on select of the button: 

RemoveIf(YourList,Dropdown6.Selected.FullName in PersonField.DisplayName)

 In the Display Property have this: 

If(IsEmpty(Filter(YourList,Dropdown6.Selected.FullName in PersonField.DisplayName)),DisplayMode.Disabled,DisplayMode.Edit)

You will need to change Your List with your SP list and maybe have Dropdown.SelectedText Depending on how you have set this up. 

 Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[Shreya308]

Hi Andrew,

It worked... Thanks a lot. Can you also help me with one this as well

I also want to do if the username is in the list then the button will get disabled and if not make it enable 

[AndrewR1]

@Shreya308 Awesome!

Can you give me an example of what the User Name would look like as the person field doesn't have a User Name Property? 

It would be something like this as a general guide: 

If(!IsEmpty(Filter(YourList,Dropdown6.Selected.FullName in PersonField.DisplayName)),DisplayMode.Disabled,DisplayMode.Edit)

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[Shreya308]

It not working with the command that you gave .. I was doing the same thing.

Let me explain

• Right hand side of my page there is a field name user with the drop down of all the user existing (Column type: Person) with a "added" button And on the left hand side I have a browsegallery which shows how many user entered in the system. I want to make that button disable if the user name is already exists or visible in the browsergallery . If not it get enable.

But with the code that you shared it's doing the opposite.

[AndrewR1]

Hi @Shreya308 I modified the code it should have the ! at the from of is Empty: 

If(!IsEmpty(Filter(YourList,Dropdown6.Selected.FullName in PersonField.DisplayName)),DisplayMode.Disabled,DisplayMode.Edit)

Apologies I edited my response to update with the ! as I noticed this would be the inverted logic! 

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[Shreya308]

Hi Andrew , 

Thank you for the solution but i am facing delegation warning. Do you have any idea how i can remove that

[AndrewR1]

Hi @Shreya308because you are comparing Text to a table data set, we must use the "in" operator this will be the reason that you are getting a delegation warning as the "in" operator isn’t delegable unfortunately!

You try removing the "in" operator and just using = if you are comparing text to text this will remove the delegation warning! (As im not sure we need to be usig the "in" operator looking over my last reply I think we can just use = )

If(!IsEmpty(Filter(YourList,Dropdown6.Selected.FullName = PersonField.DisplayName)),DisplayMode.Disabled,DisplayMode.Edit)

But as long as the data set that you are comparing isn’t above the apps item limit (Found in the setting defaults to 500 items) then you should also be fine with the delegation warning.

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew