Ramzi

My feedback

  1. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi supported this idea  · 
  2. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  (General Feedback) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  3. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  4. 140 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Azure Cosmos DB » Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  6. 71 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Logic Apps » Management  ·  Flag idea as inappropriate…  ·  Admin →
  7. 116 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Logic Apps » Connectors  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  8. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
  9. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Workflow runtime  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi supported this idea  · 
  10. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  11. 17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Logic Apps » Workflow runtime  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ramzi commented  · 

    Let me just add... I need more flexibility than what FilterArray can do
    . Complex where clauses
    . Projection in the select
    . Top x

    An error occurred while saving the comment
    Ramzi commented  · 

    I'll provide a simple example... if you need more details, let's sync over Skype for Business (I'm a Microsoft employee)...

    SCENARIO: from the logic app... I call an SP, passing in multiple Serial Numbers, and I get back a JSON representation of the results..
    My next step (or action) is a foreach (for each serial number) with an inner compose that needs to extract the relevant result data that came back from the SP for a particular SN....

    It would be great to have a function like so
    linq(collection: SP_Result, query: "select top 1 c.* from c where c.DeviceSerialNumber = " + item()["sn"]);

    Example of JSON result from SP call
    {
    "Table1": [
    {
    "DeviceSerialNumber": "DeviceSN-9179",
    "DeviceEventTime": "2016-10-21T08:56:54",
    "ComponentLocation": "CompLocName-599",
    "ComponentLotTrackingNumber": "CompLotTrackNumb-186",
    "PartNumber": "CompPartNumb-343",
    "ComponentLocationCount": 180,
    "ComponentVendorPartNumber": "CompPartNumb-138",
    "ComponentVendorName": "CompVendNam-202",
    "ComponentSerialNumber": "CompSN-43",
    "AssemblyKey": "AssemKeyN-167",
    "IsSerialized": "True"
    },
    {
    "DeviceSerialNumber": "DeviceSN-6963",
    "DeviceEventTime": "2016-10-21T08:56:59",
    "ComponentLocation": "CompLocName-774",
    "ComponentLotTrackingNumber": "CompLotTrackNumb-80",
    "PartNumber": "CompPartNumb-181",
    "ComponentLocationCount": 188,
    "ComponentVendorPartNumber": "CompPartNumb-909",
    "ComponentVendorName": "CompVendNam-181",
    "ComponentSerialNumber": "CompSN-648",
    "AssemblyKey": "AssemKeyN-175",
    "IsSerialized": "True"
    },
    {
    "DeviceSerialNumber": "DeviceSN-9424",
    "DeviceEventTime": "2016-10-21T08:57:17",
    "ComponentLocation": "CompLocName-203",
    "ComponentLotTrackingNumber": "CompLotTrackNumb-879",
    "PartNumber": "CompPartNumb-270",
    "ComponentLocationCount": 184,
    "ComponentVendorPartNumber": "CompPartNumb-674",
    "ComponentVendorName": "CompVendNam-255",
    "ComponentSerialNumber": "CompSN-672",
    "AssemblyKey": "AssemKeyN-171",
    "IsSerialized": "True"
    },
    {
    "DeviceSerialNumber": "DeviceSN-5222",
    "DeviceEventTime": "2016-10-21T08:56:37",
    "ComponentLocation": "CompLocName-579",
    "ComponentLotTrackingNumber": "CompLotTrackNumb-566",
    "PartNumber": "CompPartNumb-864",
    "ComponentLocationCount": 180,
    "ComponentVendorPartNumber": "CompPartNumb-131",
    "ComponentVendorName": "CompVendNam-577",
    "ComponentSerialNumber": "CompSN-438",
    "AssemblyKey": "AssemKeyN-167",
    "IsSerialized": "True"
    },
    {
    "DeviceSerialNumber": "DeviceSN-7937",
    "DeviceEventTime": "2016-10-21T08:57:57",
    "ComponentLocation": "CompLocName-275",
    "ComponentLotTrackingNumber": "CompLotTrackNumb-826",
    "PartNumber": "CompPartNumb-727",
    "ComponentLocationCount": 17,
    "ComponentVendorPartNumber": "CompPartNumb-57",
    "ComponentVendorName": "CompVendNam-485",
    "ComponentSerialNumber": "CompSN-469",
    "AssemblyKey": "AssemKeyN-4",
    "IsSerialized": "True"
    },
    {
    "DeviceSerialNumber": "DeviceSN-3088",
    "DeviceEventTime": "2016-10-21T08:56:50",
    "ComponentLocation": "CompLocName-924",
    "ComponentLotTrackingNumber": "CompLotTrackNumb-578",
    "PartNumber": "CompPartNumb-211",
    "ComponentLocationCount": 188,
    "ComponentVendorPartNumber": "CompPartNumb-522",
    "ComponentVendorName": "CompVendNam-805",
    "ComponentSerialNumber": "CompSN-506",
    "AssemblyKey": "AssemKeyN-175",
    "IsSerialized": "True"
    }
    ]
    }

    Ramzi shared this idea  · 
  12. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  13. 48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  14. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  15. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  16. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Designer  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 
  17. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Management  ·  Flag idea as inappropriate…  ·  Admin →
    Ramzi shared this idea  · 

Feedback and Knowledge Base