Azure Logic Apps get skipped when running

Question

Azure Logic Apps get skipped when running

Ceeeee-8261 100

Good day! I am trying to build an Azure Logic Apps Consumption Type workflow; From SharePoint we will get the data in rows and will ingest it to SQL Server. The workflow ran successfully but it is giving 202 Status messages, and the trigger history is Skipped. Can you please advise what is wrong with our design?

Please see the screenshot of the design and the output below. Thank you in advance for your help.

User's image

I tried to check the connection for SharePoint, Excel and SQL server and it was connected properly. I would like to know if there's any other blocker as to why it was skipper or not running.

Here's the output:
User's image

User's image

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2023-08-27T10:35:47.3833333+00:00

202 is acceptance message.. by skipping does it mean it doesn't have anything to process(to insert rows in your case)? can you check if the source does generate datas? I know this might not be a solution but we can narrow down
Ceeeee-8261 100 Reputation points

2023-08-27T23:40:37.27+00:00

Hello @Vinodh247 the source (excel) has a table and data, we just want to know why it was not running successfully, is there any blocker?
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2023-08-28T06:01:37.2933333+00:00

if it has any blocker most often it should fail, but skipping and running over to complete the job is different. let me check if anyone else has any idea about it in my circle.

Accepted answer

0 additional answers

Your answer

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2023-08-27T10:35:47.3833333+00:00

202 is acceptance message.. by skipping does it mean it doesn't have anything to process(to insert rows in your case)? can you check if the source does generate datas? I know this might not be a solution but we can narrow down
Ceeeee-8261 100 Reputation points

2023-08-27T23:40:37.27+00:00

Hello @Vinodh247 the source (excel) has a table and data, we just want to know why it was not running successfully, is there any blocker?
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2023-08-28T06:01:37.2933333+00:00

if it has any blocker most often it should fail, but skipping and running over to complete the job is different. let me check if anyone else has any idea about it in my circle.

Answer 1

MayankBargali-MSFT 70,936 Moderator

@Ceeeee-8261 Thanks for reaching out. If you are seeing Skipped in the triggered history then it means that the trigger condition was not met and the trigger did not fire. This can happen if the trigger is set up to only fire when certain conditions are met. If the incoming data does not meet these conditions, the trigger will be skipped and the Logic App will not run.

Please click on three dots on your trigger --> Settings and validate if you have specified any Trigger Conditions which would have not met and your triggered got skipped.

User's image

Ceeeee-8261 100 Reputation points

2023-08-28T08:53:41.85+00:00

Hi, @MayankBargali-MSFT thank you for the quick response. Per checking there no set up in Trigger conditions, can you please advise the example to trigger for this? Or what would be the solution so that it will not skip?

Thank you in advance for your help.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-08-28T10:11:20.3933333+00:00

@Ceeeee-8261 Can you please retry to create a file/modify to confirm if your workflow gets triggered for the same site, library, and folder as you have verified that there is no trigger condition specified.
Ceeeee-8261 100 Reputation points

2023-08-28T14:19:52.6066667+00:00

Hi @MayankBargali-MSFT , I tried to update the file and it triggers now. But I have a currently issue right now. Here's the error:

""status": 400,"message": "Conversion failed when converting date and/or time from character string."

Can you please help us how we can fix this issue?
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-08-28T14:36:07.4+00:00

@Ceeeee-8261 Thanks for your response. It looks like your logic app is triggered now and now you are facing the issue with your SQL insert action. As per the error, it looks like your SQL column is of time date type whereas you are trying to insert a string value which is not able to convert to Date and time.

As per your screenshot input body assuming your Date property should be Date type, but I can see the value as 41865 which is not a valid date. You can validate with your SQL table which filed requires date time value.
Ceeeee-8261 100 Reputation points

2023-08-28T14:42:39.8866667+00:00

Hi @MayankBargali-MSFT I appreciate your quick response. I would like to show you the data from the excel sheet. I just want to ask how can I reflect all the dates to be inserted in the SQL tables. Please see the sample data below:
Ceeeee-8261 100 Reputation points

2023-08-28T14:59:35.3933333+00:00

@MayankBargali-MSFT What would be the right expression for addDays to add all the dates from the column Date in excel sheet?

Hope you can help me on this one. Thank you
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Ceeeee-8261 100 Reputation points

2023-08-29T00:21:55.9233333+00:00

@MayankBargali-MSFT can you recommend solution for this problem? thank you
Ceeeee-8261 100 Reputation points

2023-08-29T07:14:25.4966667+00:00

@MayankBargali-MSFT do you have any update on this? Thank you
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-08-29T07:30:01.5633333+00:00

Ceeeee-8261 The date and function available in logic app are listed here. You can use parseDateTime to convert your text (as shown in your screenshot) 8/14/2023 to datetime output 2023-08-14T00:00:00.0000000 which you can used while inserting the data.

The below is only for reference and you should remove the hardcoded value in the below screenshot with the dynamic value of your excel cell.
Ceeeee-8261 100 Reputation points

2023-08-29T08:31:15.2233333+00:00

Hi @MayankBargali-MSFT I tried to use the parseDateTime and remove the hardcoded, but I receive and error. What would be the right expression to use to include all the dates coming from the excel sheet:

Thank you in advance for your help.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-08-29T10:47:01.9033333+00:00

@Ceeeee-8261 You don't have to hardcode the value as Date string as per your screenshot. Instead use the for each item with your column name to get the dynamic value inside your loop. You can use the expression below to get the Date column value of each row.

parseDateTime(items('For_each')['Date'])

The above is only for reference and modify/test it as per your requirement.

You can find all the logic app function reference documented here.
Ceeeee-8261 100 Reputation points

2023-08-29T11:44:01.1933333+00:00

Thank you so much for the quick response @MayankBargali-MSFT I tried to update the expression with your suggestions. But unfortunately, there's still an error and I don't know exactly what's happening. I hope you can help me. Thank you in advance!

Input:

Output:
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-08-29T11:49:41.28+00:00

@Ceeeee-8261 As per the error Date is not valid property. Can you please confirm if you are using the right excel file and you have selected the right table which has the column Date which you have shared previous that has the Date column.

You can send an email with subject line “Attn:Mayank” to AzCommunity[at]Microsoft[dot]com referencing this thread and your availability so I can review your workflow and other details for quick assistance.
Ceeeee-8261 100 Reputation points

2023-08-29T11:52:35.34+00:00

@MayankBargali-MSFT Thank you so much for the help. I will just email you instead. Appreciate all the quick response! :)
Ceeeee-8261 100 Reputation points

2023-08-29T12:05:57+00:00

@MayankBargali-MSFT I also emailed you about this, I will just post it here. Just want to confirm with you that I am using the right excel and selecting the right table.

Here's the proof that I am selecting the correct folder path and table:

Actually, it was ingesting to SQL Server successfully except the "Dates"
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-08-30T14:52:34.12+00:00

We had a offline sync and found that there was issue with the column name Date and have changed the format to resolve the issue. We discussde further the workflow implementation.

Share via

Azure Logic Apps get skipped when running

0 additional answers

Your answer