I have a Filter Array and Select action that I am using to get a calendar event. The filter Array is set to only return results on the day the Flow is ran. This works in a different Flow I created, but reproducing the Flow to use a different calendar causes an Apply Each when configuring the Select action. I get that there could be multiple items in one day, but I won't in the way I have it set up. How can I avoid the Apply Each in this case? Below is a screenshot of the one that is working fine.
Filter Array = @equals(formatDateTime(item()?['EventDate'], 'yyyy-MM-dd'), formatDateTime(utcnow(), 'yyyy-MM-dd'))
Solved! Go to Solution.
Hi @Anonymous ,
Could you please share a screenshot of your flow when an Apply to each is automatedlly added? I have made a test on my side a don't have the issue the you mentioned.
Also if you would like to get the first item from an array, you could take a try with expression as screenshot below:
Best regrads,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Could you please share a screenshot of your flow when an Apply to each is automatedlly added? I have made a test on my side a don't have the issue the you mentioned.
Also if you would like to get the first item from an array, you could take a try with expression as screenshot below:
Best regrads,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What do we use the select operation for ?
@v-alzhan-msft I tried this with the body from an excel table but here it wouldn't work with just getting the first item. Do you know what the remedy would be?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
42 | |
17 | |
16 | |
15 | |
13 |
User | Count |
---|---|
69 | |
36 | |
27 | |
20 | |
17 |