Correlating two sharepoint lists

(1) Share

Report

Posted on by NilSkillWill

I'm copying this post almost exactly and can't get it to work.

https://powerusers.microsoft.com/t5/Building-Flows/Combine-2-SharePoint-Lists/td-p/2457046

Essentially I have two sharepoint lists, I'm trying to find the same user in each list, and send an email based on certain factors. I get this error:

{ "dataset": "https://unitedfiregroup.sharepoint.com/sites/itsecurity", "table": "eae79325-9d08-4840-a20c-8fb9ac79abcf", "$filter": "Fullname eq Test Agent" }

the column name for both is Fullname, which is also the title column

This should work.

All responses (5)

Answers (0)

Suggested answer

Michael E. Gernaey 43,258 Super User 2025 Season 1 on at

Like (0)

Report

Correlating two sharepoint lists

Hi

Ok I figured that was the case (that it wans't the name). The name is Title (internal name). The other is just the visual label. I wish they would change what they call it lol.

Ok, how can I help you to fix this. Unfortunately I couldn't can't read your posted images even if i zoom in.

Can you add fresh bigger ones or a short video attachment so I can help
NilSkillWill 4 on at

Like (1)

Report

Re: Correlating two sharepoint lists

Thank you for the detailed replies, the name at the end of the URL is Title, as follows
https://DOMAINREMOVED.sharepoint.com/sites/itsecurity/_layouts/15/FldEdit.aspx?List=%7BEAE79325%2D9D08%2D4840%2DA20C%2D8FB9AC79ABCF%7D&Field=Title

Unfortunately when I changed it to Title, it still doesn't work:

Really appreciate your assistance here
Michael E. Gernaey 43,258 Super User 2025 Season 1 on at

Like (1)

Report

Re: Correlating two sharepoint lists

Hi @NilSkillWill

The column name is FullName, and it is set at the Title column in the list.

1. If its FullName then your Equal Filter is wrong because you have Fullname

2. Is this the Title and you changed the Label (you cannot change the name) if so then you need to look for Title

Can you please show me the End Url that I asked for before, so we can verify. Trust me if you have the correct name it won't give you that error.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
NilSkillWill 4 on at

Like (1)

Report

Re: Correlating two sharepoint lists

The data type is single line of text. I'm aiming for a string match, as opposed to an identity match. The column name is FullName, and it is set at the Title column in the list. I have also tried another column that is also a single line of text and called Username.
Michael E. Gernaey 43,258 Super User 2025 Season 1 on at

Like (1)

Report

Re: Correlating two sharepoint lists

Hi @NilSkillWill

Please go to the exact location of the list you say has this name

Is it a Person Column DataType? Or you have named it Full name?

Go to the List

Click List Details

In the List of Fields Click on the Full name one you say exists

Please then look in the URL at the end will be the actual name of the field.

See if it matches, if it does, then you are pointing at the wrong environment, or site.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey