Importing Excel Data into Sharepoint List - Dynamic fields not showing up for all fields

[DarrylJP]

I cannot figure out why when attempting to create a flow to import items from excel to my sharepoint list, that one some of the fields allow me to select variables while others don't? Shouldn't they be there for every field. Can someone advise what is going on?

Here i can see the dynamic content

But if i select the field right below, nothing....

I just want this import to work!

[ChristianAbata]

hi @DarrylJP  maeby it's an navigator error, could you try with google chrome?

[DarrylJP]

I did as requested, no change, upon further investigation the problem seems to be with numeric fields only? Is there a flow recommendation on how to populate the numeric fields too?

[Jcook]

Hello @DarrylJP

This is most likely formatting causing this.

For example if your SharePoint list is expecting PO number to be a number, you will have to convert it to a number.

For example: you can add a Compose action.
In the Compose use the expression:
int( )
Inside the () add the dynamic content from excel of a field that needs to be converted.

For your reference:
Use int() for whole numbers
Use float() for decimal numbers

You might also be able to get around this by formatting the excel table before it goes through Flow.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others