Answered

Delete item from SP list, using different datasources (calendars).

(0) Share

Report

Posted on by Verlet

Hey all.

I have created a custom Calendar app linked to 30 SP-lists (different calendars for conference rooms - without Outlook-connector).

After selecting the right calendar, the variable 'CaltoUse' is set to 'Calendar#' - ex Set(CaltoUse,Calendar1).

In the CalenderEventsGallery on the next screen I use for 'Items' the Switch-function to connect to the corresponding calendar (SPlist 'Cal#') - ex. Switch(CaltoUse, "Calendar1",Cal1,"Calendar2",Cal2).

In every datacard I have an Icon (icnDelete) and I want to delete the selected record when pressed.

Question: what is the right formula to achieve this?

Remove (Cal1, ThisItem) works, but I want to implement the right calendar, depending on the variable CaltoUse.

Remove (Switch(CaltoUse, "Calendar1",Cal1,"Calendar2",Cal2), ThisItem) doesn't work.

Any ideas?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Verlet ,

Please change to use If() function, instead of Switch(), like this.

If(CaltoUse="Calendar1",Remove(Cal1,ThisItem),CaltoUse="Calendar2",Remove(Cal2,ThisItem))

Hope this helps.

Sik

Was this reply helpful? Yes No
Verified answer

Verlet 29 on at

Like (0)

Report
Copy link

Link copied!

Hey, as I have 30+ calendars, 'IF' would be hard to create. But, you made me realise that I needed to put the Remove in the Switch function and not the other way.
So I have: Switch(CaltoUse; "Calendar1";Remove(Cal1;ThisItem);"Calendar2";Remove(Cal2;ThisItem);"Calendar3";Remove(Cal3;ThisItem) ...) and it works!
Thanks for the help in rearranging the statements!

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Verlet ,

Of course, the Switch() function is the first choice, but it still can't work in my test, so I changed to use If function.

Anyway, it helps, right.

Sik

Was this reply helpful? Yes No