Unanswered

"Get Item" "list id" missing in flow

(0) Share

Report

Posted on by 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

Categories:

Using flows

I have the same question (0)

All responses (14)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
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']

Was this reply helpful? Yes No
Deniz2 14 on at

Like (0)

Report

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 !

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Deniz2 14 on at

Like (0)

Report

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 !

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Deniz2 14 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Deniz2 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Deniz2 14 on at

Like (0)

Report

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 !

Was this reply helpful? Yes No