You’re offline. This is a read only version of the page.
18
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.
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?
Hi @masaro3 ,
Could you please tell me:
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:
Best Regards
Cheng Feng
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!
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
