You’re offline. This is a read only version of the page.
152
I have two tables
Table A:
| Code | States |
| 1 | AK |
| 2 | AL |
| 3 | AZ |
| 4 | AR |
Table B:
| Name | AL | AK | AZ | AR |
| Company A | X | X | ||
| Company B | X | X | X | |
| Company C | X | 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
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.
@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.
| Name | States operated in. |
| Company A | AL, AK |
| Company B | AK, AZ, AR |
| Company C | AL, AZ |
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.
So then you can know how many X have in column AL, or AK, or AZ etc.
@ChristianAbata I am using SQL Tables. I don't have problems getting the tables.
hi @dchan1 you are using excel tables, or sharepoint list?
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
