cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Some fields turn "null" after condition

I am making a flow to send out a daily email with the current day's check results that are stored on a table in excel.

 

I use the "List rows present in a table" to get all the rows from the table, this returns the values as expected. I then pass it through an if condition to check which row is of the current date to put details of that match into an HTML table and then email that table. However, after it passes through the if condition, some values turn into "null" and show a blank result in the table.

 

Example of the table where the values are stored:

SyedRizvi_0-1707761140723.png

 

Results after passing it through an if condition. Example in the "List rows present in a table" the "Supervisor name" field shows what is entered in the table, but becomes null after the if statement.

SyedRizvi_1-1707761185970.png

 

I have ensured all the formats in the excel table are correct and the if condition is working as expected.

1 ACCEPTED SOLUTION

Accepted Solutions

 The logic of your flow needs to be adjusted. If you only want to return a single row, you do not need an Apply to Each action in your flow. Take a look a this YT Tutorial I recently uploaded: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

 

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

 

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

I'll also cover:

 How to avoid the Apply to Each action with a single item array

 How to use the item() function to access dynamic content in an array

 How to prevent unnecessary nested Apply to Each action loops

 How to use the Select action

 How to convert an array to a string with the Select action

How to use the Filter Query field

 How to count the number of items in an array

 How to use a condition control

 How to use the concurrency control

 How to set a top count

 How to use Compose actions for troubleshooting

 

In your case, you need to use the filter query in the List Rows Present in a table action. Please note that this Filter Query will only accept a single condition. If you need to use more than one condition, use a Filter Array action instead. It's a lot more efficient than using an Apply to Each + Condition action. To learn more about how to use the Filter Array action, please refer to this YT Tutorial I uploaded.

 

Convert Time Zone

Whenever you are using dates and times in your flow—it's best practice to use a Convert Time Zone action. In the base time field, insert the utcNow() expression.

 

Source Time Zone: Coordinated Universal Time

Destination Time Zone: Local Time Zone

Format String: Round Trip

 

Filter Row by Today's Date

Add a Filter Query action to the List Rows Present in a Table action. You will need to ensure your date column text doesn't contain any spaces. 

 

Insert the name of your column first, then eq for equals to. Add single quotes.

 

Between the single quotes you will need to insert the date. You will need to format your date to match the date format in Excel. Add an expression. Use the formateDateTime() function. 

 

Click on the Dynamic content tab. Between the parenthesis, insert the output from the Convert Time Zone action.

 

Add a comma and single quotes. Between the single quotes, enter the date format that matches the date format you have in Excel.

Press OK.

 

Whenever you are working with dates and times in Excel you must always select ISO 8601 as the DateTime Format.

Create HTML Table

Add a Create HTML table action to your flow. In the From field, insert the value dynamic content from the List Rows Present in a table action. 

Change the Columns from Automatic to Custom. Customize this action to suit your needs. 

Run a test. Verify that the Create an HTML action is returning the correct information. 

 

Send an Email (V2)

Add a Send an Email (V2) action, in the body of the email insert the output from the Create HTML table action above.

 

As mentioned earlier, you do not require an Apply to Each action in your flow since you are only returning a single row. If you are planning to use any dynamic content from the List Rows present in a table action in the send an email action—you must use an expression. 

 

I cover how to compose an expression in the tutorial I've linked above.

 

 

Hope this helps!

If I helped you solve your problem—please mark my post as a solution .
Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on
TikTok
 

 

 

creativeopinion_8-1707845646311.png

creativeopinion_7-1707845533866.png

creativeopinion_6-1707845478333.png

creativeopinion_5-1707845431424.png

creativeopinion_4-1707845396020.png

creativeopinion_3-1707845357536.png

creativeopinion_2-1707845256225.png

creativeopinion_0-1707844998068.png

@SyedRizvi

View solution in original post

12 REPLIES 12

@SyedRizvi Could you post a screenshot of your full flow? It would help to provide more insight. If you are using the New Designer, please switch to the Classic Designer and expand all the actions and post a screenshot of your flow in edit mode (with all the actions expanded).

 

This would help to provide more clarity. In the meantime, you might find this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

 

In this tutorial I cover:

 How to troubleshoot a false Condition action result

 How to get dynamic content when it isn’t selectable from the list of dynamic content

 How to troubleshoot an Apply to Each action that isn’t looping through

 How to troubleshoot a skipped Apply to Each action

 How to troubleshoot a Filter Query

 How to use a SharePoint yes/no column in a Filter Query

 How to use Compose actions to troubleshoot a Power Automate flow

How to troubleshoot multiple emails being sent

 How to troubleshoot multiple Teams messages being sent

 

Hope this helps!

If I helped you solve your problem—please mark my post as a solution .
Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok
 

Here's the flow. There are two variables initialized, but one of them is redundant, I was just using them to see different types of tables.

SyedRizvi_2-1707828683196.png

 

SyedRizvi_1-1707828635757.png

 

@SyedRizvi Can you explain what you are trying to do in your flow? It's not clear to me.

I have a table where I store daily data (one row/date). In the flow, I am trying to send an email everyday with the row from the current day in a table format.

Here's the steps:

> The flow triggers when I receive an email containing a keyword

> It lists rows present in a table

> It filters the listed rows to find the row with today's date

> Creates a HTML table with that one filtered row

> Sends an email with the created HTML table

 

Hope that explains it.

 The logic of your flow needs to be adjusted. If you only want to return a single row, you do not need an Apply to Each action in your flow. Take a look a this YT Tutorial I recently uploaded: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

 

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

 

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

I'll also cover:

 How to avoid the Apply to Each action with a single item array

 How to use the item() function to access dynamic content in an array

 How to prevent unnecessary nested Apply to Each action loops

 How to use the Select action

 How to convert an array to a string with the Select action

How to use the Filter Query field

 How to count the number of items in an array

 How to use a condition control

 How to use the concurrency control

 How to set a top count

 How to use Compose actions for troubleshooting

 

In your case, you need to use the filter query in the List Rows Present in a table action. Please note that this Filter Query will only accept a single condition. If you need to use more than one condition, use a Filter Array action instead. It's a lot more efficient than using an Apply to Each + Condition action. To learn more about how to use the Filter Array action, please refer to this YT Tutorial I uploaded.

 

Convert Time Zone

Whenever you are using dates and times in your flow—it's best practice to use a Convert Time Zone action. In the base time field, insert the utcNow() expression.

 

Source Time Zone: Coordinated Universal Time

Destination Time Zone: Local Time Zone

Format String: Round Trip

 

Filter Row by Today's Date

Add a Filter Query action to the List Rows Present in a Table action. You will need to ensure your date column text doesn't contain any spaces. 

 

Insert the name of your column first, then eq for equals to. Add single quotes.

 

Between the single quotes you will need to insert the date. You will need to format your date to match the date format in Excel. Add an expression. Use the formateDateTime() function. 

 

Click on the Dynamic content tab. Between the parenthesis, insert the output from the Convert Time Zone action.

 

Add a comma and single quotes. Between the single quotes, enter the date format that matches the date format you have in Excel.

Press OK.

 

Whenever you are working with dates and times in Excel you must always select ISO 8601 as the DateTime Format.

Create HTML Table

Add a Create HTML table action to your flow. In the From field, insert the value dynamic content from the List Rows Present in a table action. 

Change the Columns from Automatic to Custom. Customize this action to suit your needs. 

Run a test. Verify that the Create an HTML action is returning the correct information. 

 

Send an Email (V2)

Add a Send an Email (V2) action, in the body of the email insert the output from the Create HTML table action above.

 

As mentioned earlier, you do not require an Apply to Each action in your flow since you are only returning a single row. If you are planning to use any dynamic content from the List Rows present in a table action in the send an email action—you must use an expression. 

 

I cover how to compose an expression in the tutorial I've linked above.

 

 

Hope this helps!

If I helped you solve your problem—please mark my post as a solution .
Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on
TikTok
 

 

 

creativeopinion_8-1707845646311.png

creativeopinion_7-1707845533866.png

creativeopinion_6-1707845478333.png

creativeopinion_5-1707845431424.png

creativeopinion_4-1707845396020.png

creativeopinion_3-1707845357536.png

creativeopinion_2-1707845256225.png

creativeopinion_0-1707844998068.png

@SyedRizvi

Thank you for such a detailed explanation. I redesigned my flow with your suggestions and it is working much more efficiently. However, the table output still shows some blank values although it shows that those have a value in the previous step.

> Here it shows all the fields have a value:

SyedRizvi_0-1707853592160.png

> The table shows blank for the same fields:

SyedRizvi_1-1707853683100.png

 

 

@SyedRizvi Can you use a Compose action to output a dynamic content that is showing a blank value?... Also, how are these columns set up in your Excel table? The ones that are displaying a blank value?... Are they formatted differently than the other columns that display values?

@creativeopinion the formatting is the exact same for each column, they are all formatted as "general" in excel. Also, when I try to compose the blank ones, the compose goes into an "apply to each" but the output of the compose action also returns blank.

@creativeopinion I tried using what you showed in your video tutorial to use the compose action without it being nested into apply to each automatically, but that returns an error/blank as well

SyedRizvi_0-1707914501134.png

SyedRizvi_1-1707914793531.png

All the other values that were previously showing also go blank now

SyedRizvi_2-1707914858370.png

 

@SyedRizvi Are you using the new designer or classic designer? The new designer is still buggy. If you are using the new designer, please switch to the classic designer and try again.

 

If it's still showing up blank you might be to create a new flow, switch to the classic designer first before making any edits to your flow.

@creativeopinion I am using the classic one, new designer doesn't work really well. I'll try starting a new flow from scratch using the classic designer.

@creativeopinion it's working now, there must've been a glitch from the new designer.

Thank you for all the help!

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages