You’re offline. This is a read only version of the page.
230
We want to have a birthday list > means every contact that born in this month.
It seems to be impossible because the date field is internally a number.
How can we extract all contacts > birthday > month > August (for example)?
Thank you
Hi Axel,
You want to filter out contacts born in August(for example), Power Automate can help you achieve the desired effect.
Specific steps are as follows.
1?Create a column named “Birthday_Month”. Set as shown below.
2?Create an Instant cloud flow, "Manually trigger a flow" is chosen for the convenience of testing.
If you have other needs, you can choose other triggers.
3?Add action “List rows”. Select “Contacts”.
4?Add option “Apply to each” to apply to all eligible contacts.
Select “value” as an output from previous steps.
5?Add Condition.
"Condition" is used to determine if birthday is not null.
6?Add an action “Update a row”.
To add the retrieved month to the column created in the first step.
Expression:
substring(items('Apply_to_each')?['birthdate@OData.Community.Display.V1.FormattedValue'],0,1)
8?Select "Test Flow" and we can see that the month has been added to the field.
9?Create a view with Advanced Find to display the result.
Share
Report
All responses (
Answers (
