Create Sharepoint Item with Lookup columns. Only item values available

(0) Share

Report

Posted on by schwibach

2 Moderator

Hello

I'm creating a flow that will let a user (student) from a different tenant create a SP list entry in this tenant.

They fill in a form, that will send an e-mail (the body of the email is a json object) that is parsed into the flow. The e-mail, parsing etc. works fine.

But I have two lookup fields (school and class) in the SP list (students) that have to be filled in. I have the values for school and class available in my json object.

So, the plan is to get both fields from the student list, do an odata filter on the school.value and class.value und Compose the first results for the schoolID and classID into variables that I can then enter into the SP list.

But when I get items from Sharepoint, the two fields don't appear for an ODATA filter. 😞

How do I do this?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report

Hi @schwibach ,

Please refer to this video tutorial and see if it answers your question.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

Unfortunately that didn't work for me.
I created two schools with each a class of the same name. If I filter for the class only as seen below, the flow creates two new items, for each class.... If I manually enter the field for the school to filter I get no results.
Is there another way to deal with this? Or am I maybe doing something wrong? The name of the field is Schule. I have the string value available in the flow.
Also, I don't like the Create items action to iterate (even if it's not really doing that because school + class will always return just one result). Is there an elegant way to do this?

Closing and opening powerautomate again, the error is gone:

This is a part of the SP list
There is one Schule: RefIV and one Klasse: SchB

Here in the flow it shows that the fields are named correctly, but on the Create Item loop, there is no positive result:

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

This is the SP list

Schule is a lookup field from the list with the schools

This is what I entered in the Odata filter
Interestingly enough, it does not show me the field Klasse to filter for. The fields I get are all from the other (parent) list. If I manually type in Klasse eq (and then the variable for Klasse), I get this error.

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

I now only filter for the class and then resolve the issue of the school with a condition inside the loop.
That produces a working flow.
But I'd really like a good solution to create a string variable from lookup values from SharePoint lists in cases where I know that there is only one result and then use that variable without any loops.

Was this reply helpful? Yes No