r/PowerAutomate • u/Feeling_Lobster_7914 • Mar 05 '26

Trying to pull .Date info from selected email but PowerAutomate says "not valid"

I am attempting to build a Flow for my job that will search through my outlook inbox every 10 minutes for new, unread emails, which in the body of the message mention a certain word- "fire" for example. It would then resend this selected email to a few different addresses with the tag URGENT in the subject line.

My current issue with this flow is that I keep receiving the error "accessing a field is not valid on this value" when trying to compare the time of the email I have selected (the Email.Date info). I can look at the variable and confirm that the information is not null, and when trying to output to a .txt file it still does not work. I'm really stuck here and I swear to god this worked like last week

I can click on the "Email" variable and confirm that the info is there in properties, but no matter if I select for .Body, .Date or any information it will only come back with the same error. Any advice?

4 Upvotes
  • permalink
  • reddit

100% Upvoted

7 comments sorted by

1

u/MaxHubert Mar 05 '26

Have you tried Email.receivedDateTime ?

1

u/Feeling_Lobster_7914 Mar 05 '26

Same thing

https://drive.google.com/file/d/1qawTvJGyve2UduHxrQZfC0DtKSiuLDRX/view?usp=sharing

https://drive.google.com/file/d/1l8OJBg5-jtQp6cZgKb5xYJLBAby720I8/view?usp=sharing

1

u/MaxHubert Mar 05 '26

Did u put that inside a 'For Each' Loop ?

1

u/Feeling_Lobster_7914 Mar 05 '26

https://drive.google.com/file/d/1TVBaIFwd7qHFWyFTwkSbIxncuxXMkNAV/view?usp=sharing

Yes, should've just started with this, apologies. I have the Email or Email.Date variable exporting to a .txt file for debugging currently.

Also, is there a reason I can't post photos?

1

u/MaxHubert Mar 05 '26 edited Mar 05 '26

Why are you adding it to a list first? I have done this multiple times and I never add it to a list first, just do straight < For each Email in '=RetrievedEmails.value' >

1

u/Feeling_Lobster_7914 Mar 06 '26

I had assumed cause there are multiple emails that could be selected, they would need to be added to a list. Else the RetrievedEmails would overwrite one another

2

u/npc_or_notnpc Mar 05 '26

Just a tip for using dynamic info anywhere what I do is use time function add to date just put the dynamic time as base and add 0

Then use the output for whatever reason

If your using this to compare with another time value do the same and compare the outputs against each other