Power Platform Community Forum Thread Details

Hi! seeking some guidance :)

Context: I'm trying to build a data log of all travel plans in a Sharepoint List, and get each new item (i.e. each itinerary) consolidated and sent to the manager once a day

Issue: When I initialize the "Travellers' Name" from the item created (there can be more than 1 travellres per itinerary) i get the below line for each traveller as output.

{"name":"variables_InitializeVariable","type":"String","value":""}{"value":"first name, last name"}

- when I Append and attach to email, i just get multiple lines of the above instead of just the first name and last name.

Questions:

1. How do I just extract the value such that in my email body, i only show 1st name and last name?

2. How do I show multiple names if an itinerary contains more than 1 name?

Categories:

General topics

Hi @JQ-01120906-0,

Make sure your For each is running as expected as I see there was Run after configured for For each action, so the for each only work when the previous action is timed out. If Foreach is not working then it will output the empty value because initialize variable by default it will be null.

If you want to work every time then you can click on For each action and go to settings click dropdown as shown below and check Is successful

This will ensure that the previous action is successful then it will run the for each action where you keep append value to work successful if the mappings are correct

If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.

Regards,
Srini