cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lbrodt1
Frequent Visitor

Select approver from column in the spreadsheet and send email in power automate

Hi There;

I have created a simple workflow in power automate on a sharepoint list for document approval,  I am using a Person/Group column to select a custom approver.  (we have multiple approvals for each document and are storing them separately in the row in sharepoint.  Everything works when i hard code the approver email, but when I trie referencing the column email  and the just column in the "to" field, it fails.  I have tried copying into a variable. i have tried creating a column with just the email as text.  all fails...

any thoughts?

 

User lookup request to Graph failed lookup for user identifier: '{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|xxxx@company.com","DisplayName":"Ny Name","Email":"xxxx@company.com","Picture":"ht'.

5 REPLIES 5
lbrodt1
Frequent Visitor

all emails are failing now even when i select my name directly and when i use dynamic content - the system email columns, created by, modified by...this has to be something easy that i corrupted...

 

annajhaveri
Super User
Super User

Hello,

 

Are you trying to get the approver from the list, or update the approver to the list? I would also like to know why you are using Graph API here, SharePoint rest api should also work.

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
lbrodt1
Frequent Visitor

i didn't write the code - I am just using the template workflow - I used the approval Action, and selected "start an approval"

 

lbrodt1_0-1608128166338.png

I have gotten it to work before....either I can't remember what i did, or i corrupted it somehow...

lbrodt1
Frequent Visitor

PS.  I am not a coder 🙂 but here is a peek at the default code...

 

lbrodt1_1-1608128255468.png

 

annajhaveri
Super User
Super User

Hello,

 

Your flow looks correct, can you please help with the screenshots of the flow run as well.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (55,823)