Unanswered

Flow only applying condition to first match instead of all matches on an excel sheet.

(0) Share

Report

Posted on by masaro3

Screen Shot 2022-10-20 at 1.51.44 PM.png Hi there.

I have a flow established to send an email two weeks before a given date on an excel document. Its a compliance email. There are multiple people who need to be sent compliance email per each date, however, the condition is only recognizing the first person listed for each date, instead of sending emails for all of the date matches. How can I fix this? Is there something like a repeat that can run until all of the matching dates are recognized?

Thanks a million in advance.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

I would use the Filter Array action, then Parse JSON, to after your List Rows action to get your related dates. Then you can Apply to Each from there.

Like this:

That should do it!

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (0)

Report
Hi @masaro3 ,
Could you please tell me:
Have you set Filter Query in [List rows present in a table]?
if not
Please check :
1.Does the output of [List rows present in a table] contain the second matching date?
(You can use Ctrl+F to query through the page to see if there is a matching date in the output of [List rows present in a table].)
2.Does your Excel table have more than 256 rows?
The Excel (Business) connector's "List rows present in table" action is currently limited to 256 rows in microsoft flow.

I thought the second matching date might be after row 256.

There is a way to around this limit:
Solved: Excel (Business) - List rows present in a table: 2... - Power Platform Community (microsoft.com)

Best Regards
Cheng Feng

Was this reply helpful? Yes No
masaro3 18 on at

Like (0)

Report

Hi! so this did seem to be the issue-- I didn't realize that there was a limit- so instead of adjusting the flow, I adjusted the document, and made sure all matching dates would be in the first 256. I will set up the parameter for the row to be deleted afterwards. However I am now running into a new issue.

The flow is recognizing all of the corresponding information for all 24 rows that match the target date, however the flow won't stop running. It's not a new run, but before the run ends, it is cycling the document (infinitely- I had to turn it off after 2 hours). I want it to just cycle the document once, then stop. Any ideas on next steps?

Was this reply helpful? Yes No