Power Platform Community Forum Thread Details

Hello all,

My current flow setup is.
When an email arrives > Get attachment > Create fil as Excel > List Rows Present in a Table > Create Item

My SP list column is a number

On power automate it doesnt let me populate this field with a value from the Excel table.

My workaround would be to convert column to text, but that means changing settings in PowerApps.

Any ideas?

Thank you in advance!

Categories:

Building flows

Hi,

Maybe the data from Excel is pulled as a string, so you would not be able to populate a numeric SP column with it. You can confirm the data type of the data pulled from Excel by accessing the raw outputs of the List rows present in a table action: if it is enclosed by double quotes in the JSON, it's a string.

To solve this problem, you can use the int() expression in your Create item action. Simply pass the dynamic content of the property that you want to use between the parenthesis in the int() expression, and you will transform the string into an integer.

For further reference:
- Data types in Power Automate: https://digitalmill.net/2023/08/03/data-types-in-power-automate/

- Expressions in Power Automate: https://digitalmill.net/2024/02/27/writing-expressions-in-power-automate/

Let me know if it works for you or if you need any additional help!

If this is the answer to your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

Check more Power Platform content on my website.
Lets connect on LinkedIn.