Unanswered

Problem with a flow

(0) Share

Report

Posted on by SR_MS

I'm trying to build a flow to push and then sync values from a Sharepoint list to another Sharepoint list within our company's site.

I tried to replicate the instructions found on this page, but unsuccessfully: https://powerautomate.microsoft.com/tr-tr/blog/copying-using-filtering/

I'm receiving the following message shown below...

Screen Shot 2021-12-12 at 6.17.40 PM.png

I believe it may be due to the fact that when I've added a condition there is no advanced mode and I'm unable to enter the string provided in the instructions shown below...

Screen Shot 2021-12-12 at 6.21.22 PM.png

I appreciate any help you can provide to help me fix the issue.

Other details that may be helpful...

Screen Shot 2021-12-12 at 6.25.06 PM.png

Screen Shot 2021-12-12 at 6.23.57 PM.png

Thanks

All responses (7)

Answers (0)

jdoss 458 on at

Like (0)

Report

Re: Problem with a flow

It's possible. You can click the "Click to download" links on both the when an item is created and the get items and compare them. You can user the browser search (ctrl+s) and look for the "PROJECT NAME" and see if it is the correct term to search for in the Destination list. You may also see if there are any special characters that could be messing up the filter query. See here for more info on that: https://powerusers.microsoft.com/t5/Using-Flows/Unable-to-Properly-Parse-quot-amp-quot-ampersand-within-odata/td-p/283086#M6886
SR_MS on at

Like (0)

Report

Re: Problem with a flow

I'm sorry jdoss and grateful for your time. I added the compose action as suggested as you will see below...
But, after running suceessfully, if I click on "Get Items" this is what I see. It seems that there is only one project from the list and it is still not copying to the destination folder...
Can the issue related to the filter query I have in the Get Items section...
jdoss 458 on at

Like (1)

Report

Re: Problem with a flow

The Create Item is fine, it isn't being trigger though because the expression is resulting in false. Before the condition, use the action "Compose" and put in body('Get_items_in_Destination')?['value'] as an expression. Then you'll see what is being returned from that action.

Or on the flow run, expand the Get items in Destination and take a screenshot of the outputs.
SR_MS on at

Like (0)

Report

Re: Problem with a flow

OK.. I made the change and again the flow ran successfully but did not add any data to the source list (currently empty). I received the same message in the Create Item section as shown previously.

Since the list is empty, should this trigger copy the data from the source and push to the destination list? I don't understand why this "branching condition" is not satisfied.

Thanks again for the help.
jdoss 458 on at

Like (1)

Report

Re: Problem with a flow

Yes now you need to remove the first part of the expression that you already had and leave only the part you added from my response. Right now your expression says if the value of get items in destination is equal to the number 0 and it is also empty then do this. You just need it to say the last part, that it is empty.
SR_MS on at

Like (0)

Report

Re: Problem with a flow

Thanks jdoss!

So, I copy and pasted your expression as shown below into the expression builder...
and the flow shows that it ran successfully but no data has been pushed from the source list to the destination list. Since the destination list does not have any data I'm expecting that the flow will push data from the source to the destination list. Note the message in the Create Item section after running the flow...

Here are the details of the Create Item section. I confirm that I've used the site address of the destination list with values from the trigger list ("When an item is created or modified").

Any ideas? Appreciate the help.
jdoss 458 on at

Like (1)

Report

Re: Problem with a flow

In the condition, use the expression tab (not the dynamic content), then put in length(body('Get_items_in_Destination')?['value'])