You’re offline. This is a read only version of the page.
Announcements
16
Hi everyone,
I'm building a flow that update a certain file in OneDrive folder when some file is uploaded to that folder.
Onedrive/root/test/may/Trial-Balance.xlsm is a file to update. It has a table "TrialBalance" with rows "Account#" and "Approved?".
When file is uploaded it triggers the flow that should make a http request to Trial-Balance.xlsm file, find the uploaded file name in "Account?" column and mark the corresponding "Approved?" column.
As there will be multiple folders Jan, Feb, march... I'm constructing the URI based on the folder path where the file was uploaded.
@Expiscornovus helped me to construct the JSON object that will hold the parameters for the HTTP request. Now I have a problem with an URI.
This is my URI:
https://graph.microsoft.com/v1.0/sites/root/drives/b*********************4/root:/BS Reconciliations/2023/Test/Trial-Balance.xlsm:/workbook/tables('TrialBalance')/rows/itemAt(rowIndex=(match('100500', TrialBalance.[A])), columnId='L')/values
Where {driveId} and {filePath} I got from uploaded file metadata. 100500 is a filename and a value in "Account?" column in TrialBalance table. I get this error: Action 'Send_an_HTTP_request' failed.
URI path is not a valid Graph endpoint, path is neither absolute nor relative or resource/object is not supported for this connector.
I've checked that URI in Graph Dev Center it didn't work either.
I'm new to Power Automate and HTTP requests, please advise.
Thank you!
Hi @andriii,
It looks like you are using the Get item at method of the Graph API, correct?. In the docs I only see the usage of a index parameter.
You are using a parameter called rowIndex. I cannot find that parameter in the docs, that might explain why the URI is invalid/does not work.
Where did you find your example you are using?
Share
Report
All responses (
Answers (
