workflowLogic apps

Question

workflowLogic apps

Niren Adhikary (NAD) 146

Hello,

We want to setup a logic app work flow which will read data from .xlsx file(from a particular worksheet in the .xlsx file) from sharepoint and insert it into sql database table for each rows in the .xlsx file excluding the header.

1 answer

Your answer

Answer 1

Kamlesh Kumar 3,866

Hi @Niren Adhikary (NAD) ,

Welcome to Microsoft Q&A Platform. Thank you for the question.

You can build your logic app workflow like:

Get File Content (From Sharepoint) --> List Rows present in a table (having filter query) --> Insert row (SQL Server connector to insert the data.)

Apart from this if you have tried some different design then let us know so we can review or if in case have any issue then please post it on Microsoft Q&A Platform.

Regards,
Kamlesh Kumar

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How

Want a reminder to come back and check responses? Here is how to subscribe to a Notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Niren Adhikary (NAD) 146 Reputation points

2022-08-03T18:19:03.767+00:00

Thanks for the response.

I have created the same workflow but we need to read the particular worksheet from xls file for that I tried get workshet and it failed
Niren Adhikary (NAD) 146 Reputation points

2022-08-03T18:26:00.78+00:00
Niren Adhikary (NAD) 146 Reputation points

2022-08-04T00:52:30.407+00:00

Hi

I was able to read the file from share point but issue with reading each rows from the sheet excluding the header. The rows need to be further inserted in a sql table.

I did like this but it failed.
MayankBargali-MSFT 70,936 Reputation points Moderator

2022-08-09T04:03:51.867+00:00

@Niren Adhikary (NAD) Can you share more details about what error you are getting while inserting the data to Insert row (v2) action?
Niren Adhikary (NAD) 146 Reputation points

2022-08-10T01:24:23.13+00:00

@MayankBargali-MSFT Thanks for your reply.

I have removed Get Table and Created a table manually, the workflow worked and able to insert records. Further we noticed some issue with data format, for example excel sheet has few columns with dates but when we insert it into sql table it gets recorded as number instead of date. Could you please advise where we should fix this in sql table data type or excel formatting ?

If I look at the output of the list rows from table from the below workflow then date_delivered column value returns a number instead of date as it exists in excel ?
MayankBargali-MSFT 70,936 Reputation points Moderator

2022-08-10T07:01:20.383+00:00

@Niren Adhikary (NAD) What is type of Date_Delivered column in your xls file. In case if this is plain text format then you need to leverage different functions such as split, date etc to format your text/integer value to your desired date/date time.
In case if you still need assistance I will suggest you to create a new QnA post with the sample input (exact string/integer value) with your desired outcome (example of datetime you want to save) so it can other help other community member facing the similar issue.

Feel free to "Accept as Answer" if your initial query has been resolved.
Niren Adhikary (NAD) 146 Reputation points

2022-08-10T07:04:15.867+00:00

Date_Delivered column is of type date format

Share via

workflowLogic apps

1 answer

Your answer