I have two tables
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.
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 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|
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.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.