Answered

Using Filter Array that shows input but the output is a blank []

(0) Share

Report

Posted on by sanhana

Hi everyone,

Recently I have been using Power Automate to help my company set some reminders for certain calibration. However, I have an issue where it started giving null outputs when initially the flow was able to show me the ID NO, Model and Calibration Date with the same flow program.

I previously triggered this flow at the start of August this year and it was fine. But after going into it today, it suddenly just had no output.

Flow:

Output:

Current flow:

Current Output:

Hope someone here could help me if possible 😞

Thank you.

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sanhana ,

Is it a Date column in the Excel table, but not Text or General type? If this is the case, have you selected the ISO 8601 format in List rows action?

Best regards,
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @sanhana

Can you show the expressions you have used in filter array?

And also tell what exactly you are trying to achieve and also give an example.
sanhana 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

Thanks so much for your reply. I realized it was an oversight on my end as I did not put the addDays expression with the correct duration hence there were no output.. haha
Verified answer

sanhana 11 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Sundeep_Malik
Thanks so much for your reply. I realized it was an oversight on my end as I did not put the addDays expression with the correct duration hence there were no output.. haha