Unanswered

Check data type of a cell in Excel

(0) Share

Report

Posted on by rcardenasb

I am working with List rows present in a table and I need to know what data type a column, string, integer, date, decimal has, how can I do it? I can't find a way to do it and have it return the type in order to process it.

Thanks for the help

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Re: Check data type of a cell in Excel

Hi , @rcardenasb

You can use the expression in flow to process your data in your Excel file. In general , from the List rows present in a table, the return type is always the string type in the flow output.

For the integer type and decimal type , you can use the int()/decimal() function to parse it :
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

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

And for the date, you can use the Date and time functions in the flow, like this:

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

rcardenasb 43 on at

Like (0)

Report

Re: Check data type of a cell in Excel

Thanks for the tip Yueyun Zhang, For the moment i resolve the problem using scope.

Was this reply helpful? Yes No