Unanswered

Power Automate Append to string variable issue

(0) Share

Report

Posted on by kregistre

I'm creating an automated flow process to receive weekly email updates on any reports that I have open via a teams list. When using power automate, I'm encountering issues with the append to string variable function whenever I try to add the dynamic content "Assigned to Display Name" append to string variable will open an external function "Apply to each" which I do not need to incorporate. Any suggestions on how to fix this issue would be appreciate and any suggestions on formatting would be appreciated.

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

schwibach 2 Moderator on at

Like (0)

Report
Copy link

Link copied!

You're missing the part of the flow that's interesting... where you get the data from.

It seems like you're getting multiple rows, not just one. So, the output of the action that you are referencing are an array, not an object.

Try getting only one row... If you cannot do that, show us what's written in the apply to each action (reference to the previous action) and then the reference inside the apply to each action, then I can write the code for you to get the data you want.
Don't worry, it's not an unsolvable problem.

Was this reply helpful? Yes No
kregistre on at

Like (0)

Report
Copy link

Link copied!

Thanks for the assistance! If you don't mind taking a look where my cursor is on the second photo, is where the "Assigned to DisplayName" should be placed, however when doing this it opens up a new apply to each tab within the if yes box and around the append to string variable box.

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you use the "Get Item" action instead of the "Get Items" action in SharePoint you will not get that problem.

The easiest option for you would be to find out the item id and then use the "Get Item" action... then you can easily reference the sharepoint item without the loops.

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report
Copy link

Link copied!

If getting the item ID is hard for you, just filter the sharepoint list inside the "Get Items" action so that you will only get one item.... Then you can ignore the Apply_to_each because it will only run once.

Was this reply helpful? Yes No
kregistre on at

Like (0)

Report
Copy link

Link copied!

What is the Id for the item? I need it specifically to read the list and get all the open items from the list and email it weekly.

Was this reply helpful? Yes No
kregistre on at

Like (0)

Report
Copy link

Link copied!

There may be multiple open reports on the list I would like it to email me all open reports.

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report
Copy link

Link copied!

So, you actually want the apply to each action that will send you an email for each item in sharepoint

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

If you want all items in one email, you should create an html table first

Was this reply helpful? Yes No