cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Copying Currency and Percentage from excel

I'm trying to build a flow to copy items from an Excel table into a Sharepoint list...I'm a flow novice, so it may be something I'm doing...

I have two fields in my list that I cannot copy from Excel using the Dynamic content picker...

One is an amount field that is a currency datatype in the Sharepoint list and the other is a probablity field that is a number field shown as a percentage (Option in the column settings).

In both cases, the field is shown in the field list for the Sharepoint list but there is no option to pick a corresponding field/column from Excel. My dynamic content options are flow options for "apply to each" and "Manually trigger a flow"...

I'm not sure if these are unsupported datatypes (seems unlikely) or if I'm missing something...

Thanks!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @CharlieO,

 

You could use the expression that item?['ColumnName'] to get each row of list. Please refer to the following screenshot:Annotation 2019-10-02 111059.png

Run result:

 

Annotation 2019-10-02 111312.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

Thank you Lin!

That worked perfectly for my needs and kept me from having to try to implement something over my head...

Much appreciated!

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Hi @CharlieO,

 

You could use the expression that item?['ColumnName'] to get each row of list. Please refer to the following screenshot:Annotation 2019-10-02 111059.png

Run result:

 

Annotation 2019-10-02 111312.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

Thank you Lin!

That worked perfectly for my needs and kept me from having to try to implement something over my head...

Much appreciated!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,765)