Invalid integer

[syb03]

Hi,

For me it is quite new to build a flow in Power Automate and I am struggling with error messages "Enter a valid integer".

I like to check daily if a date field will expire within a few days and if a field has a certain value.

I think I formulated it correctly, also looking at posts on the internet. But apparently I do something wrong.

See attached screenshot.

Anybody have an idea what could be wrong?

Thanks

Syb

[Caspar_Rubin · Accepted solution]

Hey, 

you're trying to Filter the SharePoint list by a date and a Status.

If you want to do that, use the "Get items" action (with an s), click on "Show advanced options" and put your filter query in the Filter Query field (You can't filter the "Get item" action)

cheers

[Sundeep_Malik]

Hey @syb03 

Unfortunately you cannot write so many things in the id. I will give you a workaround. 

I will suggest you to use get items action and add whatever you have added in id in the above screenshot, in the filter option of the get items action. 

Rest everything looks correct. 

If you have any further doubts just comment. 

[syb03]

Great, thank you!

That was the trick, it is working now 🙂