web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Struggling with my fir...
Power Automate
Unanswered

Struggling with my first ever flow - Input parameters are invalid

(1) ShareShare
ReportReport
Posted on by 136
I am using Power Automate for the first time. I want to create a flow that will send me a reminder 3 days before the due date of an item from Microsoft Lists. I am getting this message: 
The input parameter(s) of operation 'Foreach' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Foreach'.
 
In the flow:
 
1. Recurrence: (once per day).
 
2. Get items (): from my personal Sharepoint site, List Name of Current Tasks chosen from dropdown.
 
3. For each: body/value from previous steps is chosen as Output from previous steps. 
 
4. A condition that matches the one desribed by -dun- in this post: https://www.reddit.com/r/MicrosoftFlow/comments/19ecu5h/send_email_when_column_due_date_in_sharepoint/
 
My understanding is that body/value means pull in everything from my list items. How can that be invalid? Weirdly, when I copied the steps described by -dun-,  the flow ran just fine.  The Flow Checker found no issues, and I was able to successfully execute a test flow. Then I changed the -1 to a -3 so I'd get a reminder 3 days in advance. And somehow that seems to be breaking the earlier Foreach step, which is very confusing. Reverting the -3 to a -1 does not fix the error, even though the flow is identical to the state it was in when it worked. 
 
Before trying to copy what -dun- provided, I tried creating the condition myself. And asking the built-in Copilot assistant to create a condition did what I needed. And asking copilot to build a whole flow from scratch that would accomplish my task. And asking Chat GPT to walk me through the steps. In all cases, it always tells me my input parameters contain invalid expressions and no further detail is provided. 
 
Any insight or advice you can provide would be greatly appreciated. 
Categories:
I have the same question (0)
  • AnthonyAmador Profile Picture
    2,553 Moderator on at
    Hi,
     
    I don’t think the body/value is the problem. It’s probably something wrong with the expression you are trying to use in the condition. Can you share a screenshot of how you are setting it up?
     
    Thanks,
    Anthony
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at
    You might be interested in these YT Tutorials linked below. If you are still running into issues, ensure that if you are using the new designer, you toggle it off first, click on all actions to expand them and upload a screenshot of your flow in EDIT mode.
     
    Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
    In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

    This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

    📅 Student Birthdays
    📅 Project Due Dates
    📅 Contract/Membership Renewals
    📅 License Expirations
    📅 Client Anniversaries
    ---
    IN THIS VIDEO:
    ✅ How to Send an Email based on a Date Column in SharePoint
    ✅ Using the Recurrence Trigger in Power Automate
    ✅ How to Use the Filter Array Action with multiple conditions
    ✅ How to Get Dynamic Content from a Filter Array Action
    ✅ How to Get a Date Three Days from Today
    ✅ How to Create a Dynamic Date Based on utcNow()
    ✅ How to Return a Count of Items
    ✅ How to initialize and set a variable
    ✅ How to use the Send an Email (V2) action
    ✅ How to send test emails
     
    ---
     
    How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks
    Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. 

    I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.
    IN THIS VIDEO:

    ✅ 4 Date Functions You Need to Know
    ✅ How to use the Convert Time Zone Action
    ✅ How to Get a Future Date
    ✅ How to Get a Past Date
    ✅ How to Return SharePoint Items Due in a Number of Days
    ✅ How to Return SharePoint Items Due within a Date Range
    ✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
    ✅ How to Calculate the Number of Days between Two Dates
    ✅ How to Check for a Birthdate and Anniversary Date
    ✅ How to work with Dates and Times in Excel
    ✅ How to use a Manual Trigger with Date Input
    ✅ How to Output Dynamic Text with an Expression
    ✅ How to Check if a Date Falls on a Weekend


    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • Suggested answer
    David_MA Profile Picture
    12,966 Super User 2025 Season 2 on at
    Since you said your flow was working, I am going to guess that it was. Although I looked at the link you provided and am not sure it would since the dates are not formatted as ISO8601 dates. But I will take your word that it worked. Since you say you want to get items where the date expires in three days, you need to add three days to your expression rather than subtract. Otherwise, you will be checking items that have already been expired for three days.
     
    If you still get the error, format the date in the expressions so it returns it in the format yyyy-MM-dd instead of MM/dd/yyyy. The form yyyy-MM-dd is the ISO8601 date format Power Automate expects. That could be your issue as well, but it wouldn't explain why it was working.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard