Answered

Power Automate: Filter All Day Events

(0) Share

Report

Posted on by Schredder

I am trying to use Power Automate to send a daily email showing entries from a shared calendar used to show who is out of the office that day. Some staff are out all day while others are only out part of the day. I can get it to work but it is confusing because all-day events are mixed in with partial events.

To work around this, I tried to create two different tables: one for all-day events and the other for partial events.

I have tried several methods to get this to work but keep running into errors. I have tried the following.

On the Get Calendar View of Events > Filter Query > isAllDay eq 'true'. Error message saying “The expression is invalid”
Tried adding a “Filter Array”
1. From: Outputs
2. Filter Query: items()?['isAllDay'] is equal to True.
3. Error message: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The template action 'Create_HTML_table_1' at line '1' and column '3605' is not valid: "The template language function 'items' must have at least one parameter.".'.'.

Any insight and help is very much appreciated.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

SamLed 2,338 Moderator on at

Like (0)

Report

Hi @Schredder,

Replace items() by item(). First one is use for "Apply to each" or "Do until" loop, and take the name of the action as parameter, second one is use for actions like "Filter" or "select". Both refer to current item but is not used in same context.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Verified answer

SamLed 2,338 Moderator on at

Like (1)

Report

Hi @Schredder,

For your filter issue, change your query to (remove quotes) : isAllDay eq true

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Schredder 23 on at

Like (0)

Report

That worked, thank you.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report

Hi @Schredder,

Great, glad it is working. Please accept post(s) that helped you solve your issue as a solution. So other with same issue will spot the solution.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No