Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Power automate requiri...
Power Automate - Building Flows
Suggested answer

Power automate requiring an integer, but the information is alphanumeric.

(1) ShareShare
ReportReport
Posted on by KR-30071928-0 2
Hello! I am making a flow to go through Planner tasks, go through Sharepoint list items, find matches, and then update one of the Sharepoint list values. To do this, my shared "value" between the list and planner for mapping is the planner task ID. The value is alphanumeric. Some examples of this format are: xtQHOdQX60mt7Mwr0VBJoWUAIwVs, YQzAf8ZRzkejcr_2ZL0XiQ2UAH3JX. However, at the end of my flow, it says "  Error details: Input parameter 'id' is required to be of type 'Integer/int64'. ."
 
However, it will not let me convert it to an integer. This is the only shared value available to me. Any ideas? 
Categories:
Business Process Flows
  • ChadVKealey Profile Picture
    ChadVKealey 1,393 on at
    Power automate requiring an integer, but the information is alphanumeric.
    It sounds like in your SharePoint list you have a column that's storing the "Planner Task ID", is that correct? If so, you'll need to use a "Get items" (plural) action with an appropriate filter to retrieve the matching SP list item. If that column is named "TaskID", your odata filter query would be something like:
     
    TaskID eq '<planner-task-id>'
     
    The output of Get items will always be formatted as an array, even if only one item is returned. So, for example, if you add an "Update item" action and choose the ID from dynamic content, Power Automate will wrap that in an "Apply to each" loop. This is normal, but can be annoying. I usually add a Compose action with the expression:
     
    first(<get-items-output-value>)
     
    which will give you that first response value as an object. It's a little trickier to access the values in it (you need to use the proper notation), but better than a bunch of apply-to-each loops.
  • Suggested answer
    Pstork1 Profile Picture
    Pstork1 67,045 Most Valuable Professional on at
    Power automate requiring an integer, but the information is alphanumeric.
    I think the error is referring to the SharePoint list item ID, not the Planner Task ID. The SharePoint ID is an Integer.  Can you provide a screenshot of a flow run with the error?
  • David_MA Profile Picture
    David_MA 11,736 Super User 2025 Season 1 on at
    Power automate requiring an integer, but the information is alphanumeric.
    Please capture a screen shot of the action where the error occurred and show its configuration and post it with your question.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans