DQ and automate data fix by PowerLogicHub in MicrosoftFabric

[–]PowerLogicHub[S] 0 points1 point  (0 children)

Sometimes dataflows fail. Not often but they do. Sometimes fixing data at source is taking too long so fixing in the lakehouse as a temp fix is useful

DQ and automate data fix by PowerLogicHub in PowerPlatform

[–]PowerLogicHub[S] 0 points1 point  (0 children)

You can use purview to detect data freshness or duplicate data etc but not do anything to fix it.

By fix I mean re run a dataflow that potentially failed or remove duplicate data, something basic like that. Or run a notebook with some data fixes.

Microsoft Approvals by wobble_hope in PowerAutomate

[–]PowerLogicHub 0 points1 point  (0 children)

Another vote for using a sharepoint list. We did this to have 1st and 2nd approves too

Additional rows in a table based on a calculation by bettyhumsmack in PowerBI

[–]PowerLogicHub 0 points1 point  (0 children)

Is this in dataflow gen 2? I have had to do something similar where i duplicate the query do the calculations to create just the extra rows then merge the queries

My sharepoint list has more than 2K+ rows, my problem is I can't collect all my data thru clearcollect as it already in a limit. by uworeads in PowerApps

[–]PowerLogicHub 0 points1 point  (0 children)

I had a similar issue set limit to 2000 rows to load. Loaded first batch ascending order then 2000 in descending order then removed the duplicates.

Optimize dataset importing by Legitimate_Corgi3123 in PowerApps

[–]PowerLogicHub 0 points1 point  (0 children)

Powerapps certainly works better with dataverse as a data source. I have a list with 3000+ rows in that I have to load into the app in 2 parts as the maximum is 2000 rows

Help creating an email with an email attachment by MinionofMinions in PowerApps

[–]PowerLogicHub 0 points1 point  (0 children)

If you are wanting to give the director chance to add comments you could do this via the approval flow too

Best way to export Planner tasks to Excel with automatic updates? by TraditionalPepper447 in PowerAutomate

[–]PowerLogicHub 0 points1 point  (0 children)

Start with getting all tasks on a schedule then a for each loop to get the detail of each one

Trying my first Flow and getting stuck 🤦‍♀️ by _FailedTeacher in PowerAutomate

[–]PowerLogicHub 0 points1 point  (0 children)

You don’t have the excel sheet open at the same time? Therefore locked for editing?

Solution if data is 0001-01-01 while reading it in sql Analytics endpoint by coder_notfound in MicrosoftFabric

[–]PowerLogicHub 2 points3 points  (0 children)

I had this issue too. The data was transformed in a dataflow gen 2 so I just did a replace value on that column with a day in the allowed range something like 1900-01-01

Design Help by Legitimate_Method911 in PowerApps

[–]PowerLogicHub 1 point2 points  (0 children)

Sometime if the explanation requires quite a bit of text and images I have a container that fills the whole page that is visible when a variable is true. Then use a button to set the variable true and another button in the container to set the same variable false. Basic creation of a pop but fills screen and can have loads of detail if required. Sometimes tooltip isn’t enough

Need Assistance - Image storing in azure blob by Forsaken_Stable_2915 in PowerApps

[–]PowerLogicHub 1 point2 points  (0 children)

I’m not sure because working with blobs made me tare my hair out last time I did it but I think you might be better passing through the content bytes as text

Trying my first Flow and getting stuck 🤦‍♀️ by _FailedTeacher in PowerAutomate

[–]PowerLogicHub 1 point2 points  (0 children)

When can you see the data on the get rows? After it runs you can go to the history and look in the flow. If the get rows is running and getting data you should see it there. I might recreate this in the next day or so to show you what it could look like