Unanswered

Check if a field exists in Sharepoint list

(0) Share

Report

Posted on by brokencornets

Hi guys

I'm creating a Flow which is checking around 100 SharePoint lists in a site to get a number of list items that have been "validated" and update a Spreadsheet - this is now working perfectly thanks to some help on here and from Google.

However, there's one part that I can't get, and I'm not sure why. Each of the lists I'm looking for has a field called "AssignedUser" - this user is the same for every item in the list. So I created a Compose with the following input: first('Get_Items')?['AssignedUser']

But doing this seems to break everything. My initial thought is it could be because not every list has this field? If that's the reason, is it possible to have a kind of 'IFERROR' Excel-type logic to ignore these lists completely and skip to the next? Or am I just using the 'first' function incorrectly?

Thanks for any help in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

sudharsan1985 1,325 on at

Like (0)

Report
Hi @brokencornets

You can check whether the field is there in the lists or not using the flow. There is no direct out-of-box action to check but you can use the SharePoint REST API to check whether the field is available in the lists or not.

I had changed the name of the action to 'Check List Field', use the below expression in the 'Condition' action to check for the length, in the 'Yes' block do the action if the field is present, and in the 'No' block do the actions if any.

length(outputs('Check_List_Field')?['body']?['d']?['results'])

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
brokencornets 42 on at

Like (0)

Report

Hi Sudharsan

Thanks for your help - I've now managed to set up a condition to only bring back the lists that contain the AssignedUser field, but it seems like I'm using the 'first' function wrong as it's still breaking at this point.

How would I go about bringing back the data from the AssignedUser field in the first item (or any item) of the list?

I try:
first(body('Get_Items')?['AssignedUser'])
first('Get_Items')?['AssignedUser']
first(body(‘Get_Items')?['Value'])?['AssignedUser']
body(‘Get_Items')?['Value']?[0]?['AssignedUser']

but nothing is working 😞

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report
Hi @brokencornets

I assume that its a Multi People Picker field. Use the 'Apply to each' action with the following condition. I just used from the triggerBody output, you can use the same with the other outputs.

triggerOutputs()?['body/AssignedUsers']

Inside the loop use the below condition. Here I took the user's email address.

items('Apply_to_each')?['Email']

Was this reply helpful? Yes No