Dynamic Content not working

[Anonymous]

I have created what I think is a simple flow. Item is added to list, Get file properties, Start and wait for an approval on "Document Owner" which is a people selection field, then I have a condition if the Outcome is equal to Approve, send the next approval, etc. The problem is, I cannot get any of the Dynamic Content fields that I created into the "Assigned to" field. If I use anything other than the file properties that are defaulted like, Created By, Modified By, etc., the flow errors out. 

Any thoughts on why this might be happening?

[Jcook]

Hello @Anonymous
Could you share a picture of your flow


—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Anonymous]

Hi JCook,

I have attached the image below. So, again, basically, I can see the field from my list, however, when I remove the "Created By" and add the "Document Owner Email" the flow does not fire at all and gives me the error message. I tested this theory I have that it's only working with the "Get file properties" that are defaulted to the library/list, like Created By Email, Modified By Email, etc. all of the other fields that I have added, are not working.  Also, what's weird is, as you can see, I also have the "document owner coming into the details, but I believe it's working here because I have it coming is as "display name" instead of "email".  Also, I tried both "Document Owner Email" from the "Get file properties" and "When an item is created" and both are failing. The reason I don't want the "Created By" in this instance, is the "Document Owner" will change each time the library is populated with an entry.  I have to say, I'm finding Flow a bit more difficult to use. I've already reverted back to SharePoint Designer for a few other simple flows. 😞

[Jcook]

Hi,
A couple of things,
What is the error message you mentioned in the post.
When selecting dynamic content you can try to click the ‘see more’ in the dynamic content window pop up.
Lastly what is the output of the get files properties action when the flow does run.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[RobElliott]

@Anonymous the AssignedTo field only shows the dynamic content items that are valid for that field, i.e. Document Owner Email, Created By Email, Stakeholders Email, Modified By Email and possibly some others that are above the scroll line. Other types for dynamic content items won't be displayed.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Anonymous]

1. I changed the "Assigned To" to "Document Owner Email" and ran a test and it timed out initially. Now it just keeps  timing out. I don't know if this is good or bad.

2. I can see the selection I want in the dynamic content window, when I select it and it populates the flow just does run, it sends the above error.

3.  There are a number of Outputs, are we looking for something specific here? (Document owner, Body, ID, Document Owner Display Name, Department, etc.) these are basically all the fields that are being populated in the library. They all appear to be good.

[Anonymous]

Hi RobElliott,

Yes, I thought that I could use the Document Owner Email, but it doesn't work. Based on tests from today, three now, it is just "timing out" when the flow gets to the approval.

[Anonymous]

This is really weird. So it appears to be working now, in that, I received the two tests to the Document Owner Email address, but the  flow timed out each time.

[Jcook]

@Anonymous 

How long does it run for before timing out?

Does the approval email get sent to the person?

The approval has to be actioned before the flow will continue

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Anonymous]

It started to fail again.  See below. 

[Jcook]

Hello @Anonymous
Can you try to add an action right before the approval action:

Add a Compose
Inside the compose put the dynamic content of Document owner (or whatever the content you are passing to the approvals)

Now instead of referencing the dynamic content of document owner directly in the approval action. Select the output of the compose.

Now try and run the flow again.
This will show us what value is exactly being passed in to the approvals action. In the run history.

Post picture of the results please.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Anonymous]

JCook,

This has been very helpful. This started to work in that, it fired the flow, sent the email, but when I clicked on Approve, I got the  "something went wrong" the approval has been reassigned error message (third image).  I had been getting this prior, but it went away when it was firing on the "Created By" in the Assigned To. I'm not able to send the workup on the run, because I can't get pass the Approve to see it.

 

[Anonymous]

I dropped in another test with myself as the "Document Owner" and it failed again. With that same error "Unable to process template language in action Start and wait for an approval doesn't exist", etc. The compose processed fine though.

[Anonymous]

JCook,

It fired the flow and email again on second test, maybe it just needed to propagate the changes.  I was also able to Approve the request. This has been very helpful. Thank you!

[Jcook]

Hi @Anonymous 

The Compose action not showing the outputs, tells me that there is something wrong with that field Document Owner.

Click the click here to download and see what the output is. If nothing shows up or it does not download than this is the reason it is failing.

Sorry if this is a question you already answered, but what is the data type of that field in SharePoint?

Is this field a lookup?

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Jcook]

@Anonymous 

Hmm maybe,

What is your delay set to?

Maybe need to increase?

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Anonymous]

JCook,

The field is a "Person or Group" field. It's firing the flow and e-mail, now the issue is the "something went wrong" upon trying to Approve.

The "Person or Group" field has the following properties:

Require contain information - yes

Allow multiple selections - no

Allow selection of - People only

Choose from - All Users

Show field - Name (with presence)

This is very odd since it is populating and pulling people from the AD.  I clicked on the download and it just sat there, blank screen.

[Anonymous]

The Delay is set to 3 minutes to allow for data input.

[Jcook]

Hi @Anonymous 

In the Compose action can you add this expression to the beginning:

string()

Add the dynamic content of Document Owner inside the ()

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Anonymous]

The Output looks fine now. Again, it's just breaking on the Approval now.