cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JHS2019
Helper I
Helper I

Problems getting data from Excel and Update SharePoint Item (Currency column)

Hi

 

I have an excel sheet where I have a number - This number I should update my SharePoint list Item if their Titel matches, then it should update the number from excel into the currency column in SharePoint. I can see it gets the number from Excel but I won't add it into SharePoint? 

JHS2019_0-1663849226213.png

JHS2019_1-1663849248450.png

 

JHS2019_2-1663849267349.png

JHS2019_3-1663849311753.png

 

 

And If I cannot add the number from excel in the dynamic content as the column in sharepoint is a number column. 

 

If I change it to a currency column the number does not display. 

 

Hope somebody can help 🙂

 

5 REPLIES 5
v-chengfen-msft
Microsoft
Microsoft

Hi @JHS2019 ,

The reason why you met this problem is that:

  1. The value of EDR/pcs may be null or empty value.

 

Here is a formula for your reference:

if(equals(vchengfenmsft_0-1663922484447.png,''),vchengfenmsft_1-1663922484448.png,0.00)

 

Best Regards

Cheng Feng

Does not work, as I cannot get the list price to display 

JHS2019_0-1663923074025.png

 

Hi @JHS2019 ,

Could you please show me how you update SharePoint?
(pay attention to personal privacy)

 

Do you mean that :
1. Match the "Title" in the SharePoint list and "Title" in Excel
2. if their Title matches, Update the "EURO/pcs" column in Excel to the SharePoint list

 

I've made a test for your reference:

Here is SharePoint List

vchengfenmsft_2-1663925894415.png

Here is excel.

vchengfenmsft_0-1663925858926.png

vchengfenmsft_5-1663925999901.png

vchengfenmsft_6-1663926020034.png

vchengfenmsft_7-1663926045489.png

Best Regards

Cheng Feng

 

 

 

Not an option here to select the currency column 

JHS2019_0-1663933240025.png

 

Hi ,@JHS2019 

I'm sorry to get back to you now.

Because [Apply to each] is used nested. You can't get it directly, we need to get it through the formula.

items['Apply_to_each']?['Required Column Names']

 

Best Regards

Cheng Feng

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,694)