Answered

Delete Drop down list

(0) Share

Report

Posted on by CarlosN

Hello,
I have a sharepoint database, I want to delete a data to a record line and then save.
I'm using a dropdown list and I want a button press to delete the data in the sharepoint list.
I need an idea of the syntax

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,374 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CarlosN ,

There are a couple of ways - what are the Items of the drop-down and what is the Update of the Data Card?

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Does the Dropdown match the SP list column exactly. Is there only one record or is there multiple with matching data?

If there is only one then a simple RemoveIf(Source,Lookup(Column=Dropdown?Selected.Value)) Could be (Result)

If Multiple and no fixed ID to select than I would create a Gallery of teh SP list and use the dropdown to filter the gallery. On each row of teh gallery add the trash can. When selected use Remove(Source,Gallery?Selected)

Was this reply helpful? Yes No
CarlosN on at

Like (0)

Report
Copy link

Link copied!

I have three users and I also have an ID in the sharepoint list

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @CarlosN :

The following is my summary, please help me point out any errors:

There are three only options in the dropdown control "Mariana……"/"Setlla Lancheros"/"Johanna……"

The user selects an option in the dropdown control, such as "Setlla Lancheros". Then click the button to delete all records with Title equal to "Setlla Lancheros".

If so ,I suggest you use this formula:

RemoveIf('Solicitudes Expres',Title=DropDown.SelectedText.Value)

Its function is to delete all records where the value of Title is equal to DropDown.SelectedText.Value in'Solicitudes Expres'.

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-remove-removeif

Best Regards,

Bof

Was this reply helpful? Yes No