cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dchan1
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
ChristianAbata
Super User II
Super User II

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

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

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

@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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,992)