cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
syb03
Frequent Visitor

Invalid integer

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

 

syb03_2-1663166211154.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Caspar_Rubin
Responsive Resident
Responsive Resident

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)

 

2022-09-14_16h51_06.png

 

cheers

 

View solution in original post

3 REPLIES 3
Caspar_Rubin
Responsive Resident
Responsive Resident

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)

 

2022-09-14_16h51_06.png

 

cheers

 

Sundeep_Malik
Memorable Member
Memorable Member

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. 

 

Sundeep_Malik_0-1663167258890.png

Rest everything looks correct. 

If you have any further doubts just comment. 

Great, thank you!

That was the trick, it is working now 🙂

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,546)