Unanswered

email dynamic user list with overdue excel actions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I've looked at about 10 different posts, none of which seem to fix the specific issue I have.

I want to run a monthly trigger action, where my excel online (in SharePoint) file pushes any item in a "status" column flagged as "overdue" to those users. Overdue is determined by a nested if statement referenced against "today()" in the spreadsheet, so again, this is dynamic over time.

Users will be dynamic each time the trigger happens.

I can make it work when I just send the list to a static distribution list, but not everyone will be needing the email monthly. As soon as I introduce the dynamic list, the flow runs, but no emails are sent.

Copy of my flow below - as soon as the "value" from the xlsx file is introduced, it doesn't work.

I've also tried an OData filter when listing the rows present, but think I may have the wrong syntax. Some of the posts suggested that inserting that ahead of the HTML table may be a way around it. I'm not a coder - be kind!!

Help much appreciated!

issue with dynamic users 2 of 2 .png issue with dynamic users.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous :

First, could you please check weather the output of 'list rows' is empty?

Secondly,Is there any error message since the email could not be sent? Can you provide a screenshot of the run history?

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Firstly, thanks for reaching out to help.

I've done 2 runs this morning to try and make it work. the OData filter was blocking any output, so I took it out altogether and it's worked better, but has still said it's failed.

Test 1 - OData still in place

2) with OData removed (NB I did receive 3 emails, which is the number that in the test data are showing as "overdue")

in terms of run history, here you are - as you can see, it's never fully worked according to the parameters. if you need the code on what it's saying isn't working, happy to share.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous :

The first image shows that no field named 'status' could be found, can you check if this field actually exists in the data source?

The second picture shows that the value of the parameter 'to' is empty, could you filter the data source first to prevent this from happening?
Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi bof, thanks for the note.
please see below - the field definitely exists.

reference the second point - how do I do this?

Kind regards,

Duncan

Was this reply helpful? Yes No