Why can't a workbook slicer parameter accept an array as a value - Microsoft Community


i have workbook hosted on onedrive personal use.  i'm using javascript api (ewa namespace) embed workbook onto public schoolwires webpage.  the workbook has 9 slicers, published parameters.  when use setparametersasync method pass single text value slicer, method's callback triggered, value applied successfully, , visible part of workbook filtered.  when pass array of values (to apply multiple filter values), method's callback never triggered , visible part of workbook isn't filtered:

this works: 

objparameters['slicer_grade_level'] = '11';  wbk.setparametersasync(objparameters, setparamsasynccallback, wbk);

this fails: 

objparameters['slicer_grade_level'] = ['11', '12'];  wbk.setparametersasync(objparameters, setparamsasynccallback, wbk);

suggestions?

good day milton,

the task you're trying perform in excel onedrive host more complex answered in microsoft answers forums. since concern involves use of javascript, better post on msdn. msdn has developers can provide better assistance regarding issue. please post query in msdn excel developers forum.

let know if need further assistance.



OneDrive / Options and settings / Web settings / OneDrive Web (OneDrive.live.com)



Comments

Popular posts from this blog

Can't Sign-in to OneDrive - Microsoft Community

Shared mailbox permissions - Microsoft Community

Outlook 2016 for Mac - Multiple Issues, Error 17884 - Microsoft Community