cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
antonio_piernav
Helper III
Helper III

remove with many datasource

i need help please

 

I have a gallery connected to various data sources using an "if" formula, and I want to delete it when selecting an icon in the gallery, I have tried with the "remove" formula and as a data source I put the "if" formula and it gives me a error, tells me that this formula is not valid for that formula, Any solution?

 

Error =” the specified data source can not be used with this function”12.png

any ideas??

thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Delid4ve
Impactful Individual
Impactful Individual

Not know any language other than English but hey worth a go..

 

RemoveIf(Datasource,ID=ThisItem.ID)

 

get rid of the If functions and just do:

 

RemoveIf(Datasource,ID=ThisItem.ID);RemoveIf(Datasource,ID=ThisItem.ID);RemoveIf(Datasource,ID=ThisItem.ID)

View solution in original post

antonio_piernav
Helper III
Helper III

What a good solution! It work very well...thank you very much you have helped me a lot, thank!!

View solution in original post

3 REPLIES 3
Delid4ve
Impactful Individual
Impactful Individual

Not know any language other than English but hey worth a go..

 

RemoveIf(Datasource,ID=ThisItem.ID)

 

get rid of the If functions and just do:

 

RemoveIf(Datasource,ID=ThisItem.ID);RemoveIf(Datasource,ID=ThisItem.ID);RemoveIf(Datasource,ID=ThisItem.ID)

antonio_piernav
Helper III
Helper III

What a good solution! It work very well...thank you very much you have helped me a lot, thank!!
dimi
Impactful Individual
Impactful Individual

@antonio_piernav

 

I am facing the same issue here but i think either i am overseeing someting or you are Smiley Very Happy

So lets say you have 2 datasources, lets call them S1 and S2.

S1 has 5 items so therefore lets say they each have id's incrementing (1,2,3,4,5), same for S2.

 

Now what happens when you apply above functions (lets say ThisItem.ID is 2), it will delete an item with ID 2 in S1 AND in S2 isn't it?

 

So i don't get why this removeIf with the nested if's is not working... it should be possible.

Let me know what you think about it please.

Kind regards

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,937)