cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rushil
Frequent Visitor

Excel Business Online issue

Hi All,

 

I'm facing one issue while getting data out of Excel Online - "List all rows present in excel". I have 3 columns from excel which are coming out to be null but instead they do have values present with those particular columns. You can even see the values in the output of Excel Online - 

Rushil_0-1660767079618.png

 

I'm trying to get the values of these columns into compose but it's showing empty or null.

Rushil_1-1660767079597.png

 

int(outputs('Compose')) - using this to convert the value to integer.

 

Output of Compose is showing as null.

Rushil_2-1660767079639.png

 

 

Error;

Rushil_3-1660767079657.png

 

 


Can anyone please help me with this issue?

Thanks in advance 

Rushil_4-1660767079513.png

 

8 REPLIES 8
v-liwei-msft
Microsoft
Microsoft

Hi @Rushil ,

 

 

Could you please tell me:

Are you trying to convert floating point numbers in Excel columns to integers?

According to your first screenshot, the problem occurs because the data in the Excel column is a float and not an integer.

The function Int does not recognize the string version of floating point numbers.

I suggest you use the float function to convert a string version for a floating-point number to an actual floating point number , and then use formatNumber to round it to an integer.

I have made a test for your reference:

vliweimsft_3-1661243521342.png

vliweimsft_4-1661243533510.png

 

formatNumber(float(items('Apply_to_each')?['Column3']),'N0') 

 

vliweimsft_5-1661243556465.png

I think this link will help you a lot:

Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

 

 

Best Regards,

Levi

 

 

 

Hi @v-liwei-msft ,

I really appreciate that you took out time for me.

I tried wat you suggested but the flow got failed showing the below error:

Rushil_0-1661272815847.png

Also, I have other columns in the excel with float value and I am able to directly get the value out of them. But I'm not sure why these 3 columns are behaving weirdly. 

Rushil_1-1661273020982.png

Blue Ticks: Working fine

Red Cross: showing null values but can see values in excel online action's output (attached in the question I posted)

 

Do you have any other thoughts what I'm missing or doing wrong?

 

 

Thanks again 🙂

v-liwei-msft
Microsoft
Microsoft

Hi @Rushil ,

 

Could you please provide me the full formula for the error and a screenshot of the return value of your List rows present in a table? 

Very grateful!!!

 

Best Regards,

Levi

Hi @v-liwei-msft ,

 

Here is the Output from List rows present in the table. You can see the value as highlighted which I'm trying to fetch.

Rushil_1-1661366578331.png

This is the compose part.

Rushil_2-1661366647302.png

 

This is the error message that is coming upon running. It is considering the column value as null

Rushil_0-1661366485401.png

 

 

Thanks for looking.

v-liwei-msft
Microsoft
Microsoft

Hi @Rushil ,

 

Could you please tell me:

Whether the column you want to get has null values?

 I'm sorry, I tried to reproduce the problem you encountered, when the column is not empty and is a number, using float and FormatNumber does not give an error. 

If you have new progress, please contact me in time, thank you!!!

 

 

Best Regards,

Levi 

Hi @v-liwei-msft ,

 

The columns have float data type values and are not null.

Rushil_0-1661442818192.png

 

I haven't got any work around till now and still stuck with this issue 😞

I have tried creating new flow and also by deleting the excel and recreating the excel. But could find the solution till now.

 

 

Thanks

v-liwei-msft
Microsoft
Microsoft

Hi @Rushil 

 

May I ask if there is only one row in the table, or the field in each row is not empty! 

I'm sorry that I tried to reproduce your problem many times, but no error occurred.

 

Best Regards,

Levi

Hi @v-liwei-msft ,

 

There is only 1 data row as of now in the table.

Thanks for trying to help me out. If you want and have time we can connect over call whenever you have time. I would really appreciate that.

 

Thanks.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,062)