cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CharlieO
Level: Power Up

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
Community Support Team
Community Support Team

Re: Copying Currency and Percentage from excel

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

CharlieO
Level: Power Up

Re: Copying Currency and Percentage from excel

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
Community Support Team
Community Support Team

Re: Copying Currency and Percentage from excel

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

CharlieO
Level: Power Up

Re: Copying Currency and Percentage from excel

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 406 members 5,140 guests
Please welcome our newest community members: