Answered

Unable to get the output after filter array action

(0) Share

Report

Posted on by Yoga

I am creating a scheduled cloud flow.

Recurrence is daily. It should get data from the row that matches the function "utcNow('yyyy-MM-dd') from excel. I am attaching the SC of Excel. So I am using List rows present in Excel and after this action, I am using filter array to filter the Row that has the same date.

After this action, the output is empty. Can you please help me with this?

Categories:

General topics

All responses (4)

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @Yoga ,

Please try change is equals to for contains in Filter array.

Best Regards,

Sunshine Gu
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Use
utcNow('yyyy-MM-ddT00:00:00:000Z')
in the filter array.
Yoga 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, It worked. But could you help with how to remove the first 2 rows?

And also, I want format this table into HTML format in compose action, is this possible?
v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Yoga ,

You can use the Create HTML Table to select the Custom mode and fill in the attributes you want.

item()?['Date'] item()?['Location'] item()?['Email']

Best Regards,

Sunshine Gu