Answered

Power Automate Approval Flow

(0) Share

Report

Posted on by anjali52

I am getting this error " BadRequest. The request failed. Error code: 'InvalidApprovalCreateRequestAssignedToNoValidUsers'. Error Message: 'Required field 'assignedTo' contained no valid users in the organization'."

When I am using direct value in Assigned to, the flow is working, when I am adding lookup column Endorser which is lookup datatype column which uses USER table to get data.

How can I get this fix?
I need to use that column.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @anjali52 ,

Please try this

// User is the related table.

Best Regards,

Wearsky

Was this reply helpful? Yes No
anjali52 43 on at

Like (0)

Report
Copy link

Link copied!

Thank you for information, I tried to use this flow but I do not understand what you used in filter row systemuserid eq?
Can you please explain that?
Thank you for the help

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @anjali52 ,

This is a filter expression to get the correct user from User table.

'systemuserid' is the unique id column from User table. It's created by system automatically.

Best Regards,

Wearsky

Was this reply helpful? Yes No
anjali52 43 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the answer.

Was this reply helpful? Yes No