HiI have an excel file which contains 3 columns like belowNameSystem turnsConsign turnsA11B22 I need to insert data from this excel to oracle dbI

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows How to insert value fo...

Power Automate - Building Flows

Unanswered

How to insert value for my Integer column in oracle from excel data

Like (0) Share

Report

Posted on 12 Mar 2020 10:00:07 by SumanKoduri

243

I have an excel file which contains 3 columns like below

Name	System turns	Consign turns
A	1	1
B	2	2

I need to insert data from this excel to oracle db

I added template as List rows in table from excel and in apply to each i added condition as Insert row for oracle but my problem is number columns from excel isn't showing up in system turns and consign turns field in oracle

All responses (2)

Answers (0)

SumanKoduri 243 on 12 Mar 2020 at 13:21:41

Like (0)

Report
Re: How to insert value for my Integer column in oracle from excel data

Number column isn't showing here to insert from excel
ChristianAbata 8,949 Most Valuable Professional on 12 Mar 2020 at 12:18:33

Like (0)

Report

Re: How to insert value for my Integer column in oracle from excel data

hi @SumanKoduri to do conversions you can use int('VALUEEXCEL') but I'm nor clear if you need just one value of pull all the list? could you share an screnshot to understant better?