Capturing Out of Office of a list of users and create a HTML Table to be used in next steps

(0) Share

Report

Posted on by LukeShore

Hi All.

I have not a great Expertise for Programming so it's not easy for me to understand the logical steps of a flow.

I know How to capture the Out of Office ( using "get email tips f).

Having multiple users to check I created a "Apply for each" , capturing the variable from a list of items in Sharepoint.

The problem is to create a HTML table with the result of the output for any "apply", with the name of the user and the result of the "get email tips".

Any suggestion here?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @LukeShore ，

You could try:

1\Create an array type variable before doing the apply to each.

2\Append the items to the variable in each loop by 'Append to an array'

3\Convert the array to a HTML table by 'Create a HTML table'

Best Regards,

Bof

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report
Copy link

Link copied!

Hi,
check this article , use the same in apply for each
https://soundharyasubhash.wordpress.com/2021/05/13/how-to-check-if-user-is-out-of-office-before-sending-email-power-automate/

Was this reply helpful? Yes No
LukeShore 23 on at

Like (0)

Report
Copy link

Link copied!

Thanks.
Attached my flow...
the source is a sharepoint list with names duplicated (for different reasons). so first I create a variable with email address removing duplicates.
Then, using the variable to lookup on Outlook, for each item...
Then.. append the result to a variable ( to be used for a HTML Table and email notification with a final step)

the PROBLEM is that I Find only the first Approver listed in the Variabale/HTML table and not all

Where AM I wrong?
thnaks

Was this reply helpful? Yes No
LukeShore 23 on at

Like (0)

Report
Copy link

Link copied!

Hi, thnaks, but this is an article for getting results form Outlook.
See my reply to the other post for have details of the issue I'm having.

appreciated any help here!!!
Thanks!!!

Was this reply helpful? Yes No