Unanswered

How to send Automatic Birthday / Anniversary Email to Employees using Power Automate (MS Flow) [IT or EN]

(0) Share

Report

Posted on by danielececcarel

Following this guide: https://www.youtube.com/watch?v=tK99-zUFkjo I receive this error message:

"The execution of template action 'Applica_a_ogni' failed: the result of the evaluation of 'foreach' expression 'valor@{outputs('Ottieni_elementi')?['body/value']}' is of type 'String'. The result must be a valid array."

Someone has resolve it o can share me another guide?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @danielececcarel,

It looks like there is a string value (valor) in front of the value Dynamic content field?

If so, can you remove that part and just use value (list of items). Or as an expression just use:

@{outputs('Ottieni_elementi')?['body/value']}

Was this reply helpful? Yes No
danielececcarel 12 on at

Like (0)

Report

Thanks @Expiscornovus .

Now I've another problem:
After verifying that today's date coincides with the date of birth, I have to retrieve the email address of this employee (entered in an "Email" column). how can i retrieve this address and have it available as a variable to be inserted in the form for sending the email?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @danielececcarel,

You could refer to a property of an item in an apply to each by using the function and add the internal name of the field to that.

item()?['internalnameoffield']

In your setup you could probable add this as an expression to your To field (A)

item()?['Email']

If you want to double check for the internal name of the field have a look at @ekarim2020 his blog:

https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/

Was this reply helpful? Yes No
danielececcarel 12 on at

Like (0)

Report

@Expiscornovus I am not able to do it 😞
Knowing how the columns are called (I sent you the screenshoot), do you write me exactly the commands and controls to enter?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @danielececcarel,

Below is a small animation how you could add this expression.

Was this reply helpful? Yes No
danielececcarel 12 on at

Like (1)

Report

@Expiscornovus it's working!

Now, last question: how i can attached an image? I try but i can view the image in the email received (see the attaced).

Was this reply helpful? Yes No
danielececcarel 12 on at

Like (0)

Report

@Expiscornovus solved looking on HTML guide.

The routine is ready, thanks for your support. Last last question (you are my routine boss :)). Do you know how i can insert massively, perhaps from an excel file or other, about 1000 records in my list?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @danielececcarel,

Great to hear that it works 🙂

For the batch insert of list items I would suggest to have a look at this blog from @Paulie78

https://www.tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

Was this reply helpful? Yes No
knsrinath 527 on at

Like (0)

Report

Hi @Expiscornovus

I have more than 500 employees with Images. The flow is failing due to Get Items Size is more than 200MB.

Can you please help me solve this and I need to send one day one email with all the employees who ever is having birthday on particular day.

Thanks & Regards

Was this reply helpful? Yes No