Unanswered

I need to do a lookup in Flow. Not sure how to write it.

(0) Share

Report

Posted on by martinav

3,340

The value for SolidworksStatus needs to come from another table keyed on PartNumber. Its an SQL View with the column name "Status". Any idea how to do this?

In powerapps it would read:

Lookup(SQL_Table, PartNumber=Part_Number, Status)

Thank you.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

In flow you would need to to a "get items" action and use the filter like PartNumber eq 'Part_Number'

Then initialise a string variable - call it something like varPN

The set variable varPN to be the Status field. It will do an apply to each, but as you have done a filter it will only find the one result

Then put the varPN in the select statement

Was this reply helpful? Yes No
martinav 3,340 on at

Like (0)

Report
Copy link

Link copied!

@leyburn19 ,

Thanks for the reply. The create table action only works with a single "Apply to All" situation. That is why I need a lookup style of command.

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

I do this a lot. I have two tables (Lists - as they are sharepoint). One contains a list of our 29 Stores, the other contains a list of orders at each store. I want to show all open orders but by store in my result.

I do a 'get items' action on the store list to return all the stores.

I then do a 'get items' action on the order list and in the filter I put:
CurrentliststorelinkID eq 'StoreListLinkID' and STATUS eq 'Open'
(The first is name of the field that would match the store list and the second comes from the Dynamic Content. The last part is a known filter status)

I then do a 'select' action rather than create HTML and use the result of the select for the create HTML table. I base the value of the select (like your HTML) to be the value of the Stores List get Items from Dynamic content

I do one last thing - a compose action with a replace statement. This puts code into the HTML result to give my table and cells a border

This loops through all the stores and creates a list based on the particular store only.

I then email the result each time so I see it in a table in the email, which can be cut and paste into excel if wanted. You could also put the result into an excel table on your onedrive, but I found this problematic

Was this reply helpful? Yes No
Blank 6 on at

Like (0)

Report
Copy link

Link copied!

Hey @leyburn19

I follow you up to here:
"I then do a 'select' action rather than create HTML and use the result of the select for the create HTML table. I base the value of the select (like your HTML) to be the value of the Stores List get Items from Dynamic content

I do one last thing - a compose action with a replace statement. This puts code into the HTML result to give my table and cells a border"

- Could you provide some context or examples for how you use the result and potentially a sample of the the Compose action?

Thanks!

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Not sure if this is what you need but some pictures below. The expression in the last compose in

replace(body('Create_HTML_table'),'<table>','<table border="1" padding="5">')

This takes the html table and gives it lines in the outpout

Was this reply helpful? Yes No