cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Get data based on row id

Hi,

 

I am new in flow so I don't know if it is possible. I have records stored in my table as follows:

aa.png

 

 

Is there any expression with which I can get values from the column Value 1 or Value 2 based on Row ID?

 

For example I have sharepoint list where I send Row ID to excel and I need to match RowID from sharepoint and Row ID from Excel and return data from column value 1 or value 2

 

Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Get data based on row id

Hi @flownew,

 

Please formate your excel date to table refer to link below and please save the excel table in your onedrive for business:

https://www.contextures.com/xlExcelTable01.html

 

I have made a test on my side to create the excel table in my onedrive for business as below:

Capture.PNG

 

I have create a flow as below:

Capture.PNG

 

The expression in the Condition as below:

@equals(int(items('Apply_to_each')?['Row_x0020_ID']), int(triggerBody()?['ID']))

 

The flow would run successfully as below:

Capture.PNG

 

 

 

Best regards,

Alice

 

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Get data based on row id

Hi @flownew,

 

Please formate your excel date to table refer to link below and please save the excel table in your onedrive for business:

https://www.contextures.com/xlExcelTable01.html

 

I have made a test on my side to create the excel table in my onedrive for business as below:

Capture.PNG

 

I have create a flow as below:

Capture.PNG

 

The expression in the Condition as below:

@equals(int(items('Apply_to_each')?['Row_x0020_ID']), int(triggerBody()?['ID']))

 

The flow would run successfully as below:

Capture.PNG

 

 

 

Best regards,

Alice

 

View solution in original post

Highlighted
New Member

Re: Get data based on row id

Thank you @v-yuazh-msft this works when we speak about Get row from excel. When it is case from other connectors (for example Dynamics, Sharepoint then I got an error). 

 

Do you have maybe books or materials where I can learn and see examples of using expressions?

Highlighted
Community Support
Community Support

Re: Get data based on row id

Hi @flownew,

 

You could refer to link below to learn more about the workflow definition language:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

 

 

Best regards,

Alice

Highlighted
Frequent Visitor

Re: Get data based on row id

Hi, @v-yuazh-msft 

Will this work for an Excel file stored in SharePoint document library?

 

Also, is there a way to use the Get selected item to be a parameter for Get a row? 

 

Thanks,

Fred

 

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (4,562)