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

Condition for Table Population

Hello,

 

I am trying to use a condition to create a yes/no variable to populate a CSV or HTML table is that possible? How would i create a variable to populate the table? Is it possible at all?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Andrew0228 ,

 

Do different set action in the if yes branch and if no branch, set the value in the if yes branch to Yes, and set the if no branch No.

 

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-alzhan-msft
Community Support
Community Support

Hi @Andrew0228 ,

 

I would suggest that you explain more details about the requirement so we could better understand you.

You should know and could format the CSV or html table with Array data not Boolean data.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sorry, what I am attempting to do is fill out a table based on whether or not a form has been filled out in the past five days. I want to send a table in an email whether it be a CSV or an HTML table. Currently I have a flow that does that but it consists of conditions for each possible outcome and it is quite bulky. So what i was hoping that i would be able to just use the condition and if "yes" then a variable in the table equals "yes" and vice versa for no. Is that possible? There are 9 forms.

Hi @Andrew0228 ,

 

I couldn't help you with the provided information. for the "just use the condition and if "yes" then a variable in the table equals "yes" ", what is the table like?

 

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hello,

 

The table would look a little something like this if that helps. I am wondering how I can have the result of the condition populate the second column without having to have all possible outcomes of the table because it becomes an insanely large flow. I am not even sure if it is possible.

 

FORM:Submission by 5/22:
Form 1Yes
Form 2No

Form 3

Yes
Form 4No
Form 5Yes
Form 6No
Form 7No
Form 8Yes
Form 9Yes

Hi @Andrew0228 ,

 

What would be the Condition? 

Does the form response would be saved in a sharepoint list? If yes , maybe you could check from the list to see if the form reponse existed and then update the second column.

Or there is  no any way to check if the response is submitted.

 

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Yes it populates a SharePoint list and i have a condition that works but i am more wondering how to turn the result of the condition into a variable or just use the result to populate the table.

Hi @Andrew0228 ,

 

Do different set action in the if yes branch and if no branch, set the value in the if yes branch to Yes, and set the if no branch No.

 

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,477)