Power Platform Community Forum Thread Details

Using SharePoint Online "ID" Dynamic Content as Key Value for "Get Rows" Action returning an Error

Hello. I built an auto requisition process using Power Automate that automatically populates an excel spreadsheet using the dynamic content generated by a file that is uploaded to a certain Sharepoint library. Im able to automatically populate this spreadsheet using the "add a Row (Excel Business)" action just fine. However I have a column (column E in the screenshot below) that is not auto-populated and that I fill in manually. I would like to be able to grab this data using the get row (excel business) action and dump it into another sheet.

The problem is when I try to use the Requisition column (column A) as the key column and the values in there (which are generated using the "ID" dynamic content of each file) as key values I receive the following error:

No row was found with Id '"85375"'.
clientRequestId: 9ef9d349-05c6-4acc-b7a9-0c9a5aeff1f1
serviceRequestId: 03e28467-219b-43ef-8e2b-e1441f038f10;f498b2df-3d32-4f49-a454-2f8a3b835d61;96c0d850-87c8-4b1c-8bea-395d7275d803;656f6073-f4ee-4eac-885d-89383b8afa22

This doesnt make sense because the key value for a specific file that the process is looking for matches the value that was used to populate column A in the first place. Its the same value generated by the same dynamic content. Any ideas on what could be going wrong?

I need to be able to find a specific row using column A as the key column and the value in a specific cell as the key value and then pull the corresponding data in column E for that row. As a reminder, column E is not dynamic content. I manually enter that.

Hi,

Looking at what you are describing here, the only thing I can think of is there is some kind of issue in the dynamic values of the flow. Without being able to see the flow its hard to visualize fully what is going on just off of your description. This might be a better question to bring to Microsoft Support who can better help you. I'll include a link below if you would like to go down this path. Otherwise if any other communities members have any ideas feel free to chime in.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Quick Links

Leaderboard > Power Automate