cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Excel to SQL Azure not picking up Integer Dynamic Content

I have an Excel file that I want to import to a SQL Azure DB. The flow itself works as expected, however any fields within the SQL Azure DB that are set as number/integer do not pick up there corresponding fields. This does not allow me to select any dynamic fields for each row I wish to import (see below). Text fields work fine and the flow runs, however its pointless without all the data being imported.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

Re: Excel to SQL Azure not picking up Integer Dynamic Content

Hi Worrall1975,

 

Please try to add a Compose action before the action “SQL – Insert row”. You could get the value for number fields by using Compose action.


Then in the action “SQL – Insert row”, configure the Number/Integer field with the dynamic content of Compose action.


A flow I configured looks like below works fine on my side. Hope it could be a reference for you:
3.PNG


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
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

Community Support
Community Support

Re: Excel to SQL Azure not picking up Integer Dynamic Content

Hi Worrall1975,

 

Please try to add Compose actions for each integer field, then in the “SQL – Insert row” action, select the corresponding compose output for each field.

 

Please feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
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

3 REPLIES 3
Community Support
Community Support

Re: Excel to SQL Azure not picking up Integer Dynamic Content

Hi Worrall1975,

 

Please try to add a Compose action before the action “SQL – Insert row”. You could get the value for number fields by using Compose action.


Then in the action “SQL – Insert row”, configure the Number/Integer field with the dynamic content of Compose action.


A flow I configured looks like below works fine on my side. Hope it could be a reference for you:
3.PNG


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
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

Anonymous
Not applicable

Re: Excel to SQL Azure not picking up Integer Dynamic Content

Mabel Mao - many thanks that worked perfectly.

 

It has however opened up a new issue - apologies in advance as I have only just picked up flow, so my knowledge base is currently low.

 

The issue is that that allows me to import one integer field. I have 5 or 6 fields per row that require importing as integers. How can I declare them all in this fashion?

 

Many thansk in advance.

Community Support
Community Support

Re: Excel to SQL Azure not picking up Integer Dynamic Content

Hi Worrall1975,

 

Please try to add Compose actions for each integer field, then in the “SQL – Insert row” action, select the corresponding compose output for each field.

 

Please feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
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

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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

Users online (9,784)