cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to get correct row content in excel by uploaded file

Try to get the email adress in a excel table for sending approval.

s4.png

s1.png

s2.png

But the 'Current item' in Assigned to is not an email address as below.

s5.png

Then, tried to hardcode the email address and print out the value of the 'Current item', it is as below.

s3.png

How to extract the email address correctly? Any suggestion, thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Responsive Resident
Responsive Resident

@alexlee1 ,

 

I think "Current Item" includes everything in the current row that is being iterated through in the Apply to each loop.

 

When you open the Dynamic Content menu, look for the desired column name from the table under "Apply to each" to get the specific data you want out of the row.

 

Hope this helps,

Kyle

View solution in original post

3 REPLIES 3
Highlighted
Responsive Resident
Responsive Resident

@alexlee1 ,

 

I think "Current Item" includes everything in the current row that is being iterated through in the Apply to each loop.

 

When you open the Dynamic Content menu, look for the desired column name from the table under "Apply to each" to get the specific data you want out of the row.

 

Hope this helps,

Kyle

View solution in original post

Highlighted

@kdavis91 

Though the table name and excel format are fixed. But before the excel uploaded to the sharepoint folder, it is not known. Is there any other way to index and read the dynamic content. Really thankful for your answer.

 

The Current item is as below. Is there any way to get the email address out of the array.

[
  {
    "@odata.etag": "",
    "ItemInternalId": "8347 ... 144",
    "Email of xxxD": "xxx@xxxxxxx"
  }
]

 

Any suggestion, thanks.

Highlighted

Parse json is helpful to get the correct value.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Kudoed Authors
Users online (7,818)