You’re offline. This is a read only version of the page.
Announcements
I'm trying to generate a list of Birthdays from a SP list. I have the following steps - the Get List filters out the null entries. Then the Filter is set to: formatDateTime(item()?['Birth_Date'],'MM') is equal to convertFromUtc(utcNow(),'GMT Standard Time','MM'). I'm then trying to create an HTL table to include in an email. No matter what I put in the "From" I get an apply to each step - which is not what I want - I want to create one table.
I have another flow that generates a table of dates that are less than 60 from now. In that flow I did not get the "Apply to Each"
What am I doing wrong?
Can I Do the filter in the "Get List" step? Is there a better way to filter on a 'MM' formatted date?
Hi @BrianS ,
Please post the full output of Filter Birthday List action in flow run history.
I made a test on my side, but I can't reproduce your issue. If I selected Body (of Filter Birthday List) into from field, no 'Apply to Each' appeared.
However, I still made a workaround for your scenario when the 'Apply to Each' appeared:
1. initialize an Array variable before the 'Apply to Each'
2. Append an item to Array variable within 'Apply to Each' loop, the Item is defined in JSON format, and the value expression resembles as below.
Share
Report
2,407
All responses (
Answers (
items('Apply_to_each')?['Title']3. At last, add a 'Create HTML Table' action to convert the Array to HTML format.
Hope this helps.
Sik
