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

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

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

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

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (9,701)