cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
flownew
Level: Power Up

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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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

flownew
Level: Power Up

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?

Community Support Team
Community Support Team

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

fredyano
Level: Powered On

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
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (9,987)