Answered

Cannot find the Value option in Dynamic Content

(1) Share

Report

Posted on by peter43

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?

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
peter43 16 on at

Like (1)

Report
Copy link

Link copied!

Yes, but the value is still absent

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
peter43 16 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
peter43 16 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like (1)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
peter43 16 on at

Like (2)

Report
Copy link

Link copied!

Yes, the problem is solved. Thank you very much.

Was this reply helpful? Yes No
peter43 16 on at

Like (2)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (1)

Report
Copy link

Link copied!

No problem @peter43 ! Do mark my reply as "Accept as Solution" so that it can help the future learners.

Was this reply helpful? Yes No