cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Eric6
Level: Powered On

Dynamic content not showing up for number fields

Hi! I'm trying to import some fields from EXCEL Online into a SharePoint List via a flow. This works well for string fields or selection fields. However, for any number fields, the dynamic content window does not contain the fields of the EXCEL row. 

 

The below shows the dynamic content how it comes up for text fields of the SharePoint item. For number fields the section "List rows present in a table" is simply missing, even though there are number fields in the table as well.

 

 I wonder if I can import the number fields with an expression, but I did not find the correct one.

 

Annotation 2020-02-27 120106.png

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Dynamic content not showing up for number fields

Hi!

Yes, when you get used to the dynamic content doing its magic, writing manually the name of an output property is hard to deal with.

 

My suggestion is to add a Dummy Compose action block, insert there the excel column from dynamic content, hover with your mouse over it and you will see the nae you have to use in your expression.

There is also the option to inspect flow execution, but it is more time consuming in my opinion since you need to get out the edition mode

 

Hope this helps

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

5 REPLIES 5
Dual Super User
Dual Super User

Re: Dynamic content not showing up for number fields

Hi

I think the problem is... the API converts Excel number column values into strings.

When working in Flow, you need to convert them into numbers again by means of int() or float() based expressions.

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Eric6
Level: Powered On

Re: Dynamic content not showing up for number fields

Thanks. This means I need to refer to the SharePoint field via an "Expression", not "Dynamic content".

What do I put into the bracket of the int() function though, to refer to a field in my SharePoint list?

I tried a few options, but it says that the expression is invalid...

Would you have an example on how to refer to a SharePoint field with text?

When using Dynamic Content I can only see directly the field name

 

Erik

Dual Super User
Dual Super User

Re: Dynamic content not showing up for number fields

Hi!

Yes, when you get used to the dynamic content doing its magic, writing manually the name of an output property is hard to deal with.

 

My suggestion is to add a Dummy Compose action block, insert there the excel column from dynamic content, hover with your mouse over it and you will see the nae you have to use in your expression.

There is also the option to inspect flow execution, but it is more time consuming in my opinion since you need to get out the edition mode

 

Hope this helps

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Eric6
Level: Powered On

Re: Dynamic content not showing up for number fields

Amazing, thanks a lot.

 

It turned out that "items('Apply_to_each') has to be added to the expression, as I'm inside a loop there. It shows when hovering over the other fields.

 

Cheers,

Eric

Dual Super User
Dual Super User

Re: Dynamic content not showing up for number fields

@Eric6 

Thankx for your kindness, glad to help!

You can also use item(), if so please note this abbreviated formula always refers to the inner loop when you are inside several nested loops (Apply to Each + Filter array inside; Apply to each + Select inside; Apply to Each inside another Apply to Each...)

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,126)