Approval rejections - pulling data from an array

(0) Share

Report

Posted on by LydonNZ

Hi folks

Here's the scenario:

I'm in the process of automating onboarding of new staff (and learning much as I go).

A csv comes via email from HR team with name/job title/start date etc of new staff members.
My flow extracts the data from the csv and puts it into an array
Within an 'Apply to Each', an approval is started for each of the new starters. One of my team casts their eye over it to make sure no typo's or errors anywhere.
If approved, a new item is added to a SharePoint List, showing name (Test One)/start date etc.
If Rejected, I'm creating a HTML table to hold the name (Test One from screenshot above highlighted yellow) of the staff member.
This table is then sent via email to my team and HR to advise there's something wrong with this particular staff members details.

The part I'm stuck on - I can't get the name out of the array to put into the HTML table.

I tried doing the same as I did for adding the values to the SharePoint List (which works fine), but when I try this in the HTML table (or even directly into an email) I get an error that it's expecting a string, not an object.

split(item(),',')?[1]

Anyone know how I get just the name (Test One from the screenshot above highlighted yellow) into my table?

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@LydonNZ

Can you please share the inputs to this step ?

if you can as well upload a sample of your CSV file to try from my end ?

Was this reply helpful? Yes No
LydonNZ 34 on at

Like (0)

Report
Copy link

Link copied!

Hi Mira, thanks for taking a look at this.

Here's the approval from the flow, and what gets sent through to Teams for approval.

Here's a link to download my .csv file.

Sorry, can't see anywhere to upload it on this post.

https://www.dropbox.com/scl/fi/3sovyw3qvl99es73hk9o9/New-Hires-Export.csv?rlkey=g4wyfnbe2cyirbd231j3kojnl&st=rgca221o&dl=0

Was this reply helpful? Yes No
Verified answer

NickWarner 113 on at

Like (1)

Report
Copy link

Link copied!

If you just reused the code split(item(),',')?[1] in your HTML table, then that might be where you are going wrong as the item() part of that code will be referring to the Responses output.

Try split(items('Apply_to_each'),',')?[1] to refer to the current array item.

Was this reply helpful? Yes No
LydonNZ 34 on at

Like (1)

Report
Copy link

Link copied!

Thank you!!!

Oh my, I spent an entire day trying all kinds of different ways to get that to work.

Still so much to learn about Power Automate but loving it.

Thanks again, much appreciated :-)

Was this reply helpful? Yes No