Power Automate doesn't seem to like numbers or dates?

(2) Share

Report

Posted on by SB-12091310-0

Hi everyone,

So I'm building a relatively simple 'For a selected Row (excel), send an email' flow.

I am able to get the flow to run successfully with any dynamic content that is text, such as Customer name, address etc.

However as soon as I try to add dynamic content that is a number or date, the flow doesn't work, and shows an error of "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Integer.'.

When I change any of the data within the excel cells to make it like text, the flow works. For example if I change a date from '31/08/2024' to just '31 08 2024', the flow works. Or if I change an account number from '12345' to '1 2345' that enables the flow to run too.

Would anyone have any suggestions please?

Many thanks in advance.

EDIT: Here's the flow, sorry. The 'Last_bill_to' (date) dynamic content and 'AccNo' (number) cause the problems. If I either remove these fields from the flow, or the data in the excel file is written as text, it works (for example writing the date with spaces, or an account number with letters added to it).

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

PA does like Numbers and dates ;)

Just format your Excel columns to the required types and stick to it.

Was this reply helpful? Yes No
SB-12091310-0 23 on at

Like (0)

Report

Thanks Chriddle. I've formatted numbers as numbers, and dates as dates, but the flow fails. I can't see what I'm doing wrong here?

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,345 Super User 2025 Season 2 on at

Like (0)

Report

Hi

That is specifically because whatever action you are using requires it to be Text. FYI next time share your flow please, dont just write paragraphs.

Its very straight forward, you have a requirement in your Flow for the "thing" to be a string.

Why would you expect it to accept a Number, where its literally required to be a string.

Was this reply helpful? Yes No
SB-12091310-0 23 on at

Like (0)

Report

Deleted this comment after adding the flow to the original post

Was this reply helpful? Yes No
Verified answer

SB-12091310-0 23 on at

Like (0)

Report

Fixed - I changed this to use the NON deprecated version of 'For a selected Row' which then enabled me to use the formatted dynamic content selections, and it now takes the dates and numbers absolutely fine.

Was this reply helpful? Yes No