Power Platform Community Forum Thread Details

Proposed workflow:

Part 1: User submits nomination via MS Form -> Create item on Sharepoint List -> Pull data from Office 365 to update Sharepoint List -> Retrieve additional data from an Excel spreadsheet based on the employee email to update the Sharepoint list

List rows present in a table

Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Graph API request failed. Error code is 'ItemNotFound'. Error message is 'The requested resource doesn't exist.'.\r\nclientRequestId: ac96ab45-1acd-4bfe-a3a7-c16ad6ccba1b\r\nserviceRequestId: 2eef8965-30bf-4e78-8f71-96c175795547", "error": { "message": "Graph API request failed. Error code is 'ItemNotFound'. Error message is 'The requested resource doesn't exist.'." }, "source": "excelonline-ncus.azconn-ncus-001.p.azurewebsites.net" }

Facing error in creating filter array:

From: body/value
Filter Query:

toLower(trim(item()?['Work Email'])) is equal to toLower(trim(outputs('Get_response_details')?['body/r7585bba72dc44d1999d7baff4795e77e']))
 
Compose EmployeeRecord
Inputs: Body('Filter_array')

Part 2: Completed Sharepoint List will be shared to 3 different judges for evaluation (3 different views) > Once individual rating is completed, the scores from 3 judges are pulled into the master list which will be averaged