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
Solution Supplier
Solution Supplier

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
Solution Supplier
Solution Supplier

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
Community Champion
Community Champion

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,600)