Power Apps Dataflow

Question

Power Apps Dataflow

Menz, Paul J (FAA) 20

PowerApps dataflow and how to configure tables to append stale data for new. Additionally, how can I perform a total join on tables. I need to know step by step instructions.

Menz, Paul J (FAA) 20 Reputation points

2026-07-01T16:01:31.2466667+00:00

One additional question. The date on my PowerApps table shows yesterday while the dataflow > power query shows today. Weird anomaly. Any support you can provide.
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-07-02T14:37:58.8633333+00:00

Hi @Menz, Paul J (FAA)

Thanks for the update. Could you please give me a bit more time to research this issue? I'll get back to you as soon as I have more information.
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-07-03T14:38:58.9566667+00:00

Hi @Menz, Paul J (FAA)

This behavior is commonly caused by timezone conversion between the dataflow, the target table, and Power Apps. Power Query/Dataflows may evaluate date/time values in UTC in the online service, while Power Apps or Dataverse may display the value based on the user/system timezone or the column’s date-time behavior.

Please first verify whether the target table already stores the date as yesterday or whether only Power Apps displays it as yesterday. If the target table value is already wrong, adjust the Power Query transformation to use an explicit timezone conversion before loading the data. If the target table value is correct but Power Apps displays yesterday, check the Date Picker control’s DateTimeZone property and the Dataverse/SharePoint column behavior.

If the field is intended to store only a calendar date, the best practice is to use a true Date Only field or a Time-Zone Independent configuration where appropriate, so the value is not shifted by timezone conversion.

Thank you.

Answer accepted by question author

Michelle-N 19,700 Microsoft External Staff Moderator

Hi @Menz, Paul J (FAA)

Based on your request, I understand you want to configure a PowerApps Dataflow to append new data to old records and perform a Full Outer (total) Join in Power Query.

In Power Apps dataflows, you can combine old/stale data with new data by using Power Query “Append queries”. Append adds rows from one table/query under another table/query. If the columns do not fully match, Power Query keeps all column headers and fills missing values with null.

If you want a “total join” between two tables, the closest Power Query equivalent is usually Merge queries > Full outer join. A full outer join returns all rows from both the left and right tables, including rows that only exist in one table.

Step 1: Create or edit the dataflow

Power Apps dataflows let you connect to business data, clean/transform it with Power Query, and load it to Dataverse or Azure Data Lake Gen2. Microsoft’s documentation describes the main flow as: author the dataflow, schedule refresh, then use the loaded data.

Please refer: Create and use dataflows in Power Apps

Step 2: Append stale/old data with new data

Use this when both tables have similar structure and you want to stack rows together. Microsoft’s Power Query documentation states that append creates a single table by adding the contents of one or more tables to another, and that the result uses the combined column headers from the appended tables

Please refer: Append queries

However, since Power Apps is currently not supported in the Q&A forum. So, I suggest you start a new discussion in the PPower Platform Community on this issue so that you can get more professional help, there will be very professional people to tell you the steps on how to realize this function.

Thank you for your understanding.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-06-30T14:43:49.6666667+00:00

Hi @Menz, Paul J (FAA) Is there any update from you?

If yes, please feel free to let me know.
Menz, Paul J (FAA) 20 Reputation points

2026-06-30T18:48:23.9633333+00:00

I have the tables in my dataflows however I need to combine columns from both tables into a new table for view. I need some instructions on how to accomplish.
Julian Sharp 34,861 Reputation points

2026-06-30T18:51:44.53+00:00

https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Menz, Paul J (FAA) 20 Reputation points

2026-06-30T20:48:27.68+00:00

I created a view in our database and all is good in PowerApps. Thank you!
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-07-01T14:03:03.8833333+00:00

Hi @Menz, Paul J (FAA)

I'm glad you were able to find a way forward. If you need any further help related to this, just let me know.

1 additional answer

Your answer

Menz, Paul J (FAA) 20 Reputation points

2026-07-01T16:01:31.2466667+00:00

One additional question. The date on my PowerApps table shows yesterday while the dataflow > power query shows today. Weird anomaly. Any support you can provide.
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-07-02T14:37:58.8633333+00:00

Hi @Menz, Paul J (FAA)

Thanks for the update. Could you please give me a bit more time to research this issue? I'll get back to you as soon as I have more information.
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-07-03T14:38:58.9566667+00:00

Hi @Menz, Paul J (FAA)

This behavior is commonly caused by timezone conversion between the dataflow, the target table, and Power Apps. Power Query/Dataflows may evaluate date/time values in UTC in the online service, while Power Apps or Dataverse may display the value based on the user/system timezone or the column’s date-time behavior.

Please first verify whether the target table already stores the date as yesterday or whether only Power Apps displays it as yesterday. If the target table value is already wrong, adjust the Power Query transformation to use an explicit timezone conversion before loading the data. If the target table value is correct but Power Apps displays yesterday, check the Date Picker control’s DateTimeZone property and the Dataverse/SharePoint column behavior.

If the field is intended to store only a calendar date, the best practice is to use a true Date Only field or a Time-Zone Independent configuration where appropriate, so the value is not shifted by timezone conversion.

Thank you.
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-06-30T14:43:49.6666667+00:00

Hi @Menz, Paul J (FAA) Is there any update from you?

If yes, please feel free to let me know.
Menz, Paul J (FAA) 20 Reputation points

2026-06-30T18:48:23.9633333+00:00

I have the tables in my dataflows however I need to combine columns from both tables into a new table for view. I need some instructions on how to accomplish.
Julian Sharp 34,861 Reputation points

2026-06-30T18:51:44.53+00:00

https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Menz, Paul J (FAA) 20 Reputation points

2026-06-30T20:48:27.68+00:00

I created a view in our database and all is good in PowerApps. Thank you!
Michelle-N 19,700 Reputation points Microsoft External Staff Moderator

2026-07-01T14:03:03.8833333+00:00

Hi @Menz, Paul J (FAA)

I'm glad you were able to find a way forward. If you need any further help related to this, just let me know.

Answer 1

Julian Sharp 34,861

Dataflows use Power Query https://learn.microsoft.com/en-us/power-query/

Append https://learn.microsoft.com/en-us/power-query/append-queries

Join https://learn.microsoft.com/en-us/power-query/merge-queries-overview

0 comments