Unanswered

Getting Data added to a list today

(0) Share

Report

Posted on by cbrownEagers

Hi, I am trying to resolve a problem with a flow that I have built. I have checked other posts but cannot find a resolution that fits my needs or that I understand, very new to flows and trying to keep it as basic as possible.

In summary, a MS form is used to collect data, when it is submitted, a flow is triggered which updates a MS List. At a set time in the morning, (10:00am) the flow I am having trouble with runs. I want it to look at the MS list, extract the entries created earlier in the morning and email the items returned to a selected email address. The email runs fine but the query does not extract the data entered on the day. However, if I run the flow at 14:30 in the afternoon, the flow picks up the entries added to the list that morning.

I have asked the IT desk to check the time settings which are set correctly (NZ, Auckland/Wellington).

The code I have used in the "Get items" function is to filter the list using the following function

formatDateTime(utcNow(),'yyyy/MM/dd')

The format for the field being queried is dd/MM/yyyy. Because the query picked up the entries later in the day, I'm not sure if that is the issue.

Thanks in advance for any help or guidance.

Regards

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cbrownEagers

is the formatDateTime(utcNow(),'yyyy/MM/dd') is the expression u are using for OData query ?

Was this reply helpful? Yes No
cbrownEagers 8 on at

Like (0)

Report

Hi Nived, I'm not sure if it is a OData query or not, I have attached a screen shot below of how I have created it so far

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cbrownEagers

Current filter should work fine

Also u are saying that when it runs at 10 am , it won't pickup morning's list items, while at 14:30 run it pickup the mornings data right, if yes is it picking all data in the morning ?

Was this reply helpful? Yes No
cbrownEagers 8 on at

Like (0)

Report

Hi Nived
Correct, at 10am it picks up the previous days checks and at 14:30 it picks up the data from the current day. It doesn't take all data from the table, just 3 selected fields Date/Name/Hoist Number. I have attached 2 images of the emails returned on the 16th of March

ScreenshotEmailSa...

ScreenshotEmailSa...

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cbrownEagers

is DateTime a column created in it to capture the created date?

Was this reply helpful? Yes No
cbrownEagers 8 on at

Like (0)

Report

Hi Nived
DateTime is a column in the MS list that captures the date value. Because it worked some of the time I figured the format was ok. However I cannot see the format as when I look at the table it just comes up with Today, Yesterday or April 21. Being in NZ, the usual format is dd/MM/yyyy, could this cause an issue?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cbrownEagers

For finding the reason behind the issue, check the value of DateTime column how it appears in power automate while retriving via Get items and also compare with value present in list

Also show me how it looks like in MS list and also in power automate

Was this reply helpful? Yes No
cbrownEagers 8 on at

Like (0)

Report

Hi Nived
Hopefully this is what you are meaning. I created a test flow looking at the raw data from the form (I think) the submit time is way out but the Date field at the top of the email is the format out of the form. This was run at 16:10 NZ Time. The list view is at the bottom, sorry if this is not what you were looking for.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cbrownEagers

Wondering how datetime column looks like, it is not showing date , but showing today, tommorow like that .

Also what i meant by this is Also show me how it looks like in MS list and also in power automate
when you run the get items from power automate without any filter query you can get full list , in which you can view how DateTime column looks like.

Was this reply helpful? Yes No