"Get Item" "list id" missing in flow

[Deniz2]

Hi Everyone,

I have a simple share point flow. There are 2 lists. The "style list" has a style number column which should have a unique number. ( enforced unique values) . The second list is "style_color" list which gets the style number from  "style list" by a lookup. 

We have some additional columns in "style list" which we get these fields by a "get item" action in a flow.  Flow looks like below. 

I had also added a trigger condition to avoid loops. If the value of trigger column is Yes then the flow runs and after this run it changes the trigger column to No.  So this is like a manual trigger.   

This flow worked perfectly in last 1,5 years. But recently the flow is failing as below. 

Because I can not see and select the get item list id in the dynamic content. Now all our operations are stopped as the flow does not work.  I have a case with microsoft about this problem but no improvement in last 3 weeks. Flow team sent me to share point team but no progress so far.I could not talk with anybody in microsoft support team who knows both sharepoint and flows 😞  It looks like this is a bug or something is corrupted as the flow has been working perfectly in last 1,5 years and we did not change anything. Now it does not work.  Did anyone have such a problem ? Can you help me ?

Thank you !!! 

Deniz Ozgentas

[Pstork1]

There are a couple options that might provide a workaround.  First, did you check the output from a previous run to make sure the column you need is included in the output of the trigger?  If it isn't, then check the view settings under the advanced settings for the trigger and select use all columns or a view that explicitly includes that column.

Once the column is showing in the output of the trigger you have two options if it still doesn't show in dynamic content.  First you can add it to a compose or variable earlier right after the trigger.  The dynamic content list gets filtered pretty heavily and that is often why you can't see the dynamic content you need when you need it.  The other option is to hand code the JSON for the dynamic content in the function tab.  That would look something like the following

outputs('When_an_item_is_created_or_modified')?['Style_PO_ID']

[Deniz2]

Hi,

Thank you for your quick feedback. The outputs of  the trigger is as below. It does not show columns existing in STYLE_COLOR list. I also checked the previous successful runs of the same flow and all the columns were listed in the outputs of the trigger. 

{

    "statusCode": 400,

    "headers": {

        "Vary": "Origin",

        "X-SharePointHealthScore": "3",

        "X-MS-SPConnector": "1",

        "X-SP-SERVERSTATE": "ReadOnly=0",

        "DATASERVICEVERSION": "3.0",

        "SPClientServiceRequestDuration": "74",

        "SPRequestGuid": "6773757b-5dde-4973-8d20-864a39d646a8",

        "request-id": "6773757b-5dde-4973-8d20-864a39d646a8",

        "MS-CV": "e3VzZ95dc0mNIIZKOdZGqA.0",

        "Strict-Transport-Security": "max-age=31536000",

        "X-FRAME-OPTIONS": "SAMEORIGIN",

        "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;",

        "MicrosoftSharePointTeamServices": "16.0.0.21423",

        "X-Content-Type-Options": "nosniff",

        "X-MS-InvokeApp": "1; RequireReadOnly",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "false",

        "Cache-Control": "max-age=0, private",

        "Date": "Sun, 11 Jul 2021 11:04:32 GMT",

        "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",

        "X-AspNet-Version": "4.0.30319",

        "X-Powered-By": "ASP.NET",

        "Content-Length": "1506",

        "Content-Type": "application/json",

        "Expires": "Sat, 26 Jun 2021 11:04:32 GMT",

        "Last-Modified": "Sun, 11 Jul 2021 11:04:32 GMT"

    },

    "body": {

        "status": 400,

        "message": "The expression \"*,ID,Title,TRIGGER_YES_NO,Modified,PROGRAM_x002e_,STYLE_PO/STYLE_PO,COLOR_x002C_/COLOR,STYLE_PO_COLOR,SMS_x002F_URETIM_x002e_,SMS_CARPAN_IMALATCI,IMALATCI_FOB_FIYAT,IMALATCI_KOMISYONU_YUZDE_LIST,AMALATCI_ADET_KOMISYON,IMALATCI_NET_ALIS_FIYAT,IMALATCI_KOMISYON_DAHIL_NIHAI_SM,BEDEN_1,BEDEN_2,BEDEN_3,BEDEN_4,BEDEN_5,BEDEN_6,BEDEN_7,BEDEN_8,BEDEN_9,SIPARIS_MIKTAR,IYT,IMALATCI_NIHAI_TUTAR,AYT,BITTI_x002e_,BUFFER,MUSTERI_FOB_FIYAT,NAVLUN_x002F_ADET,MUSTERI_C_x002B_F_FIYAT,MUSTERI_KOMISYON__x0025_,MUSTERI_ADET_KOMISYON,MUSTERI_ADET_KOMISYON_CF,MUSTERI_KOM_DAHIL_SON_FIYAT,MUSTERI_KOMISYON_DAHIL_SON_CF_FI,MUSTERI_NIHAI_FIYAT,SMS_CARPAN_MUSTERI,MUSTERI_KOMISYON_DAHIL_NIHAI_SMS,MUSTERI_NIHAI_TUTAR,PARA_x0020_BIRIMI,QC_x002e_,QTY_x0020_RANGE,SIZE_RANGE_x002e_,FABRIKA_x002e_,ATELYE,URETIM_x0020_NOT,SMS_x002e_SONUC,NAV_TUTAR_x002e_,M_x002e_FOB_x002e_TUTAR_x002e_,PAR_x002e_BIR_x002f__x20ac__x002,S_x002e_METHOD_x002e_,not,Created,ComplianceAssetId,Author/Name,Author/Title,Author/EMail,Author/Department,Author/JobTitle,Editor/Name,Editor/Title,Editor/EMail,Editor/Department,Editor/JobTitle,STYLE_PO/MT_x002e_,STYLE_PO/BRAND_x002e_,STYLE_PO/FABRIC,STYLE_PO/ACCESSORY_FABRIC,STYLE_PO/GARMENT_DESCRIPTION,STYLE_PO/ORDER_NO,STYLE_PO/SHIPMENT_x0020_METHOD,STYLE_PO/STYLE_x0020_GRUBU,STYLE_PO/STYLE_PO,STYLE_PO/STYLE,Modified\" is not valid.\r\nclientRequestId: 6773757b-5dde-4973-8d20-864a39d646a8\r\nserviceRequestId: 6773757b-5dde-4973-8d20-864a39d646a8"

    }

}

I tried to add a compose or JSON after trigger ( before get item ) but those did not work either. The result is failed checks as below 

Once again my get item list dynamic content is missing. Therefore can not select get item LIST ID from dynamic content. 

However get item dynamic content still shows in update item action. I guess if I can not select get item ID then get item dynamic content were not supposed to be shown in update action ? Flow does not run anyway. This was perfectly working until 2 weeks ago ?

Thank you ! 

[Pstork1]

If the trigger is based on the style list then there values from the style color list won't be there. You need to use the value for whatever column is the reference between the two lists.  That would be the Style number.  I would also assume the style number isn't the ID from the Style list.  If that is the case then you'll need to use a Get Items, not a Get Item.

[Deniz2]

Hi,

thank you for your reply. Yes you are right, I need to select the style_po id from STYLE list in get item action. STYLE_COLOR list selects the style_po ( which is unique in STYLE list) from STYLE list. This way we can see the columns of the get item ( STYLE list) in the dynamic contents and add to UPDATE ITEM action. Now the only problem I have is "when an item is created or modified" flow with trigger condition (@equals(triggerBody()?['TRIGGER_x002e_'],True)  does not trigger. 

This is the trigger condition 

 This is the error message I am getting 

This listed under failed checks as below 

it says bad request , status code 400. 

I also tried to make a simple new get item flow with the same conditions and it worked . 

Could it be something related with connectors etc. I am nor experiences with the admin functions maybe microsoft can solve this  ? 

https://docs.microsoft.com/en-us/power-automate/triggers-troubleshoot#sharepoint-trigger-issues

thank you for your help ! 

[Pstork1]

For the moment remove the trigger condition and add it to a Compose statement using the expressions tab.  That will let you see the values being evaluated and the result.

[Deniz2]

Hi,

I just removed the trigger condition and tried to run the flow. It did not work. Same error. Failed check

I also tried to add a compose action right after trigger 

added below condition in expessionstab

@equals(triggerBody()?['TRIGGER'],True)

But it says expresion is not valid. ? I guess i am doning something wrong ? do you mean the above ? 

In the meantime microsoft team is working on the related sharepoint list and they asked me to reduce total number of lookup columns to 10. It did not help either 😞 

i do not understand why a flow working for 1,5 years without a problem and not working now even we did not change anything in the list structure or flow details ? 

thanks  

[Pstork1]

The code you put in the Compose isn't the same as what you had in the Trigger condition.  Also, if you have a substantial number of Lookups you should be using a view to limit the number of  columns being returned by the trigger.  To answer your question of why it breaks now after running for over a year, there are two options.  One, someone may have made a change to the underlying list.  For example adding an additional Lookup column.  Or Two, MS is continually refining the connectors to improve performance.  It may be that one of those changes broke the way you were using the list.

If you removed the Trigger condition and still got an error then the flow did run and the problem wasn't with the Trigger.  In the flow run itself what action is throwing the error?

[Deniz2]

Hi,

Thank you for your reply.

Actually the the code in compose is same as the condition in the trigger. The screenshot does not show the Beginning part of the code. it is below

@equals(triggerBody()?['TRIGGER'],True)

The trigger of the flow is "when an item is created or modified" in the list. Now I removed above condition from the flow trigger, It triggers as below. It gets all the get item columns from STYLE list. But Fails at update item ( meaning can not go to other steps ?) .

On the other hand the flow without above additional trigger condition is not usable as it gets into a infinite loop and stops at the end. 

My total number of lookup columns is 10 and below MS max 12 limit! MS support teams can not solve this too.

I spend 2 weeks with flow team and they passed me to sharepoint teams and after addtional 2 weeks they passed me to flow team again. This is very slow and frustrating process!!! 

This is very dissapointing when you move all your company date to sharepoint and using the flows and MS could not solve this problem in last 4 weeks !! 

thank you for your help. 

[Pstork1]

Your original screenshot says the field for the trigger condition is ['TRIGGER_x0002e_'].  That is not the field name you used in the Compose. Are you sure the field is just TRIGGER?  Not TRIGGER_x0002e_ or TRIGGER_Yes_No which I see in the error message?

For the Update Item when the trigger condition isn't in place what field are you using for the ID?  Would you provide a screenshot of the Update Item action?

[Deniz2]

Hi,

Thank you for your reply. I just checked the field name used in trigger condition and in the TriggerBody dynamic content. You are right! For some reason the filed name in dynamic content is TRIGGER_YES_NO so i added this field name in trigger condition as below and the trigger condition worked.  ( I do not know how it was changed to TRIGGER_YES_NO  ??  )

Now i can trigger the flow with condition without having a loop.  It gets the values from STYLE list. But it fails in next update item action as below. So flow does not perform the other steps. 

 it says BAD REQUEST STATUS 400

thank you !

[Pstork1]

Can you provide a screenshot of the Update Item action and how its configured?  Something in the way its configured is incorrect.

[Deniz2]

Hi,

please see the structure of the update item in the flow. id is the list ID of the triggerbody list ID which is STYLE_COLOR list.

1. program no is a get item. comes from STYLE list. right now it works. 
2. style_po_color is a concatinated field.  this is the expression. concat(triggerBody()?['STYLE_PO']?['Value'],'-',triggerBody()?['COLOR_x002C_']?['Value']) . this works and i can see concatinated value in this field now.
3. S/U.  is a get item. comes from STYLE list. right now it works
4. SMSXIM. is a get item. comes from STYLE list. right now it works
5. BITTI. is a get item. comes from STYLE list. right now it works
6. SMSXMUS. is a get item. comes from STYLE list. right now it works
7. PARA is a get item. comes from STYLE list. right now it works
8. QC.  is a get item. comes from STYLE list. right now it works
9. SIZE RANGE.  is a get item. comes from STYLE list. right now it works
10. FABRIKA. is a get item. comes from STYLE list. right now it works
11. PAR.BIR/EURO is a get item. comes from STYLE list. right now it works
12. S.METHOD. is a get item. comes from STYLE list. right now it works

Actually now this update action is performing perfectly as before and completed all the actions. But flow does not go to next step

I got below error message

[Pstork1]

I don't really see anything wrong, but I did notice that you haven't filled in the Title field and that its no longer displaying as a required field.  I would recommend not making those kinds of changes to system level settings.  They can often have unexpected side effects.  Other than that I don't have any other suggestions on what may be wrong with the flow.  It appears pretty straight forward.  But given the confusion and unexpected changes to the trigger condition column name I would suspect it has something to do with changes that have been made to the underlying list.  You may have to remove and re-add some of the actions to clear up any corrupted metadata.  Or worst case scenario start over with a new flow.

[Deniz2]

Hi,

Thank you for your reply. I added title value in one of the raws and tried to run the flow but it still fails in the update item action after performing all necesseary actions there. As you said my field name in STYLE_COLOR list is TRIGGER in the list settings as below.

However when I select it from dynamic content it shows as TRIGGER_YES_NO  ?? Also existing flow which triggers with condition works with below condition which is TRIGGER_YES_NO

@equals(triggerBody()?['TRIGGER_YES_NO'],True) 

I guess field name is supposed to be be same but it is triggering ???  maybe there is a corruption with the list ? 

My actual flow is a very long one with many conditions and actions. It would take long time to create the same but of course it is possible as I have been working on this problem in last 5 weeks ! Also I tried to create a new flow from scretch.  you can see below. The trigger condition is same as above.   

The flow does not trigger. it says there is a problem with the trigger of this flow

and report shows as below in failed checks 

It looks like I am not able to create the flow from scretch 😞 on the other hand STYLE_COLOR list has about 1000 raws and there is another list that gets the items ( same way with GET ITEM ) from STYLE_COLOR list. this list has about 1500 raws. So I have to fix this and use the existing STYLE_COLOR list data. do you think Microsft engineers can fix this ? Their flow team said this is related with the list. sharepoint team said there is nothing wrong with the list. now they passed me to flow team again but i am not sure if this is a flow problem as all the problem is related with STYLE_COLOR list. My other flows ( same structure, pretty basic) about other lists works fine. 

All our activities are almost stopped as we depend on these lists and flows and this is really frustrating as microsoft is very slow to take action on these. The support staff do not know details of the subject. They could not make analysis anywere close to you have done so far ! thanks !   

thanks for your suggestions !