You’re offline. This is a read only version of the page.
Hello everyone,
I was working on automatic email reminders and followed the procedure from Ms. Mynda Treacy. However, I cannot find the "Value" option in the select section. So I used body/value to run the flow and there is no input and output. May I ask how can I fix the problem?
No problem @peter43 ! Do mark my reply as "Accept as Solution" so that it can help the future learners.
Hi @peter43 !
Sorry for the late reply. The reason why Select action is returning an empty array is because there is nothing matching the filter query action.
So what I am trying to say is that its searching for the current date i.e. 08/07/2024 in the ReminderDate column. And as I can see, there is no date matching that format in your table hence it returns empty array.
Can you try adding one current date of today in that column and see if it works? Like this:
The formula in filter query is: formatDateTime(convertFromUtc(utcNow(),'China Standard Time'), 'yyyy-MM-dd')
And the table is not empty which includes 12 categories. My table is similar to the example of Ms. Mynda Treacy
Hi @peter43 !
Can you extend the actions of your List rows present in a table and Select.
Need to see the expressions used there.
And another thing, is your table empty in your excel file? Please check that as well.
Yes, I found the 'Value" option, thank you so much. But still, one problem that I don't know is why there is nothing in the input and output. I saw the video from Ms. Mynda Treacy and the input should be the contents from the Excel, such as the Task, reminder date, and email.
Hi @peter43 !
Please switch to the Old designer (or classic designer) by clicking the toggle button.
And then click "Save and Switch". And then add the value from the dynamic content.
The New Designer is not preferred for any editing purposes. Its just too new and lots of bugs. So please use the old designer from now on.
Hi @peter43
Please drag out select action outside "For each" loop.
If this helps & solves your problem, please remember to give a đź‘Ť and accept my solution as it will help others in the future.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
