Unanswered

when an item is added update or add item to another list - multiple entry

(0) Share

Report

Posted on by ChrissyRamirez

107

I created an automated flow that adds warranty information to my warranty list when I add new sales item. The flow is setup to look for the system ID, if it already exits update the item, if not create a new item. It is creating the same item. Only one item has both the customer ID and system ID. I am not sure what is causing this.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Anil_g 668 Moderator on at

Like (0)

Report

@ChrissyRamirez

It might be the list size issue

one thing that you can do is use an odata filter on list - idcolumnname eq 'Th ID to check' …and then directly check the return value count ..if >0 update else add

cheers

Was this reply helpful? Yes No
ChrissyRamirez 107 on at

Like (0)

Report

I am having trouble with the filter. Can you help? I have verified the internal names of columns multiple times. Now I am getting this error. Column 'System_x0020_ID' does not exist. It may have been deleted by another user.
clientRequestId: 68eb9223-58e6-4c88-b8e6-489389d71419
serviceRequestId: 07e934a1-e07a-5000-b9c4-c9c7d68ed42d

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (0)

Report
Hi @ChrissyRamirez !

The error you are getting is because you are not using an internal name of that column. Internal names don't have spaces. x0020 indicates space.

Go to your SharePoint list, and do this:

You will get the internal name after that = sign. Then use that into the Filter query like this:

SystemID eq 'field_2'

You can also refer to this blog to get an idea of how to extract the internal name in different ways: How to find the Internal name of columns in SharePoint Online?

I hope this helps.

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like (0)

Report

@ChrissyRamirez

Looks like youa re composition it wrong..

please use a proper name..where did you check the internal name?

you can check either by inspecting element or clicking grouping option

cheers

Was this reply helpful? Yes No
ChrissyRamirez 107 on at

Like (0)

Report

This is what my link for that columns displays
/_layouts/15/FldEdit.aspx?List=%7B4B43E4B3-23EC-4EC2-B272-B5E3962AC61E%7D&Field=System_x0020_ID

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like (0)

Report

@ChrissyRamirez

better create thw column without spaces and the include a space as it is creating a problem

it has already been discussed..

https://powerusers.microsoft.com/t5/Building-Power-Apps/x0020/td-p/49455

cheers

Was this reply helpful? Yes No
ChrissyRamirez 107 on at

Like (0)

Report

I created a new column and the id is marked at SystemID in the address. I resubmitted it and received another error. The query that I used is 'SystemID' eq 'field_2'. Can you tell me if you can point out any other changes I should make?

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like (0)

Report

@ChrissyRamirez

SystemID should not be in single quotes

cheers

Was this reply helpful? Yes No