cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Field not found/Compose Issue :(

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
getitem.JPG
as you can see the person_location field is there and populated
 
but my Compose function says it doesnt
gcompose.JPG
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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

13 REPLIES 13
Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

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.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@ChristianAbata 

Thank you for replying

 

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

 

So i cant understand why not working

Gary

Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

could you share a complete screanshot @gazzo1967 ?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@ChristianAbata 

Capture1.JPG

 

My expression is 

split(triggerBody()['person_location'],'-')[1]
Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

@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.

getformsImage.gif



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@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?

Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@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 

Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

@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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@ChristianAbata 

My first compose shows this
Capture.JPG

i copy the inputs

 



Capture1.JPG

 

i get an error

Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@abm 
The field is populated by the O365 Connector

Highlighted
Super User III
Super User III

Re: Field not found/Compose Issue :(

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Field not found/Compose Issue :(

@ChristianAbata 

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

Thank you for your help 🙂
Gary

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,716)