Create an report with two variable selections and send to ppt

[kbd]

I am struggling with an automation where I want to create a monthly report and send to PowerPoint

I have two fields I want to select - The Month and the Bucket

the month is a field = 'Nov 23" and the Bucket has 1-100, 100-200, 200-300. I only want the Bucket 1-100 and 100-200

I am able to select one field with a variable and also able to send the report to PowerPoint but not use a second variable "bucket" with two bucket selections.  I hope someone can help me. Thanks in advance

[F_B]

Hi Kbd,

I guess you select the month with the "Add selection to report" block.

You can add a second block "Add selection to report", choose the "field name" (bucket) and then "values" (1-100), after that with the button "+ Add value" you can add a second one (100-200). Isn't it working like this?

[kbd]

Hi, Partly got it to work but used another solution which is not as good as I want. I used an apply bookmark which gives me what I want but I would like to have it more dynamic and select from app and get the bookmark I have chosen. I only want to create one automation but the "Nov 2023" can change buckets as well. Is the only soluton to do several automations or do you have another idea. Thanks for the answer!

[F_B]

Not sure if you can link a Variable block of the automation to a variable input in the app... I'll have to study more!

[panosalexand]

Could you please send a screenshot how it's now ?