cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to use table values as fieldname of another table?

I have two tables

Table A:

CodeStates
1AK
2AL
3

AZ

4AR

 

Table B:

NameALAKAZAR
Company AXX  
Company B XXX
Company CX X 

 

So, in Power Automate, I want to check if AL, AK, AZ, AR, fields has a 'X' on Table B. 

I wonder if I can use Table A to somehow streamline the Power Automate steps.  

Straight up, I can check AL, AK, AZ, AR fields individually.  When all 50 States are there, this will get tedious.  

 

Any idea?  

 

Thanks!  

 

Dchan

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: How to use table values as fieldname of another table?

hi @dchan1  you are using excel tables, or sharepoint list?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Helper I
Helper I

Re: How to use table values as fieldname of another table?

@ChristianAbata I am using SQL Tables.  I don't have problems getting the tables.  

Highlighted
Super User III
Super User III

Re: How to use table values as fieldname of another table?

hi @dchan1  what you can do is use FilterArray first to list every value in a colum that contains X, then you can use leght two know the number.

filter.PNG

So then you can know how many X have in column AL, or AK, or AZ etc.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Helper I
Helper I

Re: How to use table values as fieldname of another table?

@ChristianAbata Sounds like what you are suggesting is for seeing  for each State, which companies has a check.  

 

However, what I want is to show which States each company is operating in and export this to a GoogleSheet.  

NameStates operated in.
Company AAL, AK
Company BAK, AZ, AR
Company CAL, AZ
Highlighted
Super User III
Super User III

Re: How to use table values as fieldname of another table?

mmm @dchan1  what I'll do for that is create a sharepoint list that save a yes or no depending on the result I get from my sql query, after that I'll read the sharepoint list to create a table and send it to google sheets.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (7,352)