Field not found/Compose Issue :(

[gazzo1967]

Hi All

Hope everyone ok during this difficult time!

Ok i have an issue that i can't resolve

i have a flow that updates a sharepoint list with using the office365 user connector.
i then do a second get item to gather a text string from a field populated by the O365 user connector where i need to split the text string which would look like this 

one two three - red

I am using a compose expression to split the string here is my code 

split(triggerBody()['person_location'],'-')[1]

But i am getting an error stating my field does not exist!

Here is the get item before my Compose

as you can see the person_location field is there and populated

but my Compose function says it doesnt

Is it because my Split formula is wrong?

I have double check the column name in my sharepoint list and it is the correct name (checked the url field name )

Thanks

Gary

[ChristianAbata]

hi @gazzo1967  I recomend you to add a compose with the value of person location and then another to split the output compose, try this.

[gazzo1967]

@ChristianAbata 

Thank you for replying

i am using a Compose
but it not 'seeing' the field.

So i cant understand why not working

Gary

[ChristianAbata]

could you share a complete screanshot @gazzo1967 ?

[gazzo1967]

@ChristianAbata 

My expression is 

split(triggerBody()['person_location'],'-')[1]

[ChristianAbata]

@gazzo1967  what I'll do is use parse json to get all the data in Get Item, and then use compose to see if I have someting in the value parsered into a compose.

See an example of how can you can use parse json.

[gazzo1967]

@ChristianAbata 

Again thank you for your help :0)

I have tested my first compose and that works now adding the Json
What do i add to the parse Json Schema?

[abm]

Hi @gazzo1967 

Make sure you have some data in that field. If no data in that field that means ODATA don't show the schema name.

Thanks

[gazzo1967]

@ChristianAbata 
Sorry i think i communicated that wrong 😞

I don't know what to put into the Parse Json Schema

Thanks for the Kudos but not deserved 

[ChristianAbata]

@gazzo1967  firs you need to get the output from getItem an then copy that output and create ParseJson, and in create Generate schema paste the GetItemOutput

[gazzo1967]

@ChristianAbata 

My first compose shows this

i copy the inputs

i get an error

[gazzo1967]

@abm 
The field is populated by the O365 Connector

[ChristianAbata · Accepted solution]

ohhh @gazzo1967  from your output just do this first(split(YOUR OUTPUT COMPOSE,'-')) to get Landiwood fire station or last(split(YOUR OUTPUT COMPOSE,'-')) to get red

[gazzo1967]

@ChristianAbata 

Im sorry.
i found my mistake!
the expression should be
last(split(outputs('location'),'-'))

Thank you for your help 🙂
Gary