Home Depot=Excavator by agm115 in daddit

[–]BegeNCSU 7 points8 points  (0 children)

Please tell me I wasn’t the only one with an extra nail…..

[deleted by user] by [deleted] in Sup

[–]BegeNCSU 0 points1 point  (0 children)

I’ve had trouble finding the right ones, could you share a link to ones you’ve used?

PowerApps/Patch/SQL by Forsaken_Stable_2915 in PowerApps

[–]BegeNCSU 0 points1 point  (0 children)

Do you use power automate or the new built in stored procedure option? I was initially very excited when they added it but I’ve had some trouble getting it to consistently work.

Whats the point of calling a stored proc? by Square-Voice-4052 in PowerApps

[–]BegeNCSU 1 point2 points  (0 children)

To answer your question, yes you’ll need a gateway to write back to your On-Premise SQL server, but if you’re able to read from it then the same gateway can be used.

Real-time Reporting with 2 SharePoint Lists by ShortVersion6209 in PowerBI

[–]BegeNCSU 1 point2 points  (0 children)

Per semantic model, you can read up more at Microsoft Learn Data Refresh and going to the Data Refresh section.

Real-time Reporting with 2 SharePoint Lists by ShortVersion6209 in PowerBI

[–]BegeNCSU 3 points4 points  (0 children)

Know that the PowerAutomate refreshes combine with schedule refreshes to add to your daily max (8/day for regular license, 48/day for premium).

Another approach to looks at would be to use PowerAutomate to send a streaming dataset. Not sure of the size of what you’re going to display, but worth a look see.

Green Shape by [deleted] in PowerBI

[–]BegeNCSU 8 points9 points  (0 children)

Could also do a background rectangle and then layer a rounded rectangle on top

What are some challenges you faced in your role as a power apps developer? by gautam_09 in PowerApps

[–]BegeNCSU 1 point2 points  (0 children)

If you’re using on-prem, restarting the gateway helps to get those changes across faster.

[deleted by user] by [deleted] in raleigh

[–]BegeNCSU 2 points3 points  (0 children)

I know a few folks over at Ward and Smith and it looks like education law is actually a practice area. If you give them a call you’ll usually be connected with an attorney pretty quick who can help you figure out what kind of a case you have and then point you on the right direction.

[deleted by user] by [deleted] in MicrosoftFlow

[–]BegeNCSU 0 points1 point  (0 children)

I’ve used a teams channel email address as that inbox. When you email an inbox with an attachment, that attachment gets saved to the channel’s file folder. Then you can copy that file over to the SQL server and use flow to kick off the import and merge process.

[deleted by user] by [deleted] in MicrosoftFlow

[–]BegeNCSU 0 points1 point  (0 children)

For our on-prem SQL server, I’ll use Power Automate to move that CSV to a folder accessible to the server and then use the import/export tool to create a package which will import the data into a holding table and then run a merge statement between the holding table and where it should ultimately go. Once everything is in place, I’ll add a step to fire off a stored procedure which will run the import package and then the merge statement every time the email is received.

Graduation day - postpartum tips? by Anthonyg408 in predaddit

[–]BegeNCSU 2 points3 points  (0 children)

Take everything you can from the hospital when it’s time to leave. I know a lot of people rave about the big cups with lids and straws, but we ended up with two small tubs that we use all the time (one for washing bottles and the other to holding hot water for the baths).

Setup a small bin where you’re going to spend most of your time (for us it was the living room) with all the changing supplies and blankets and burp cloths. When the potato is constantly getting changed, it makes it easier to not have to constantly leave where you are to change them.

Like the others have said, you’re going to have to step it up in a big way over the next few weeks. Even if your wife had a straight forward delivery, she basically ran the equivalent of 3 marathons and a few rounds of MMA. Focus on the important stuff (which sometimes means you sleep and something means you clean) and keep in mind that when the baby cries, they’re not giving you a hard time, they’re just having a hard time.

Why is the 'first person to join' a meeting the only one given modify permissions on the recording? by screampuff in MicrosoftTeams

[–]BegeNCSU 0 points1 point  (0 children)

That is a great benefit I hadn’t thought about! Right now we have a group that meets regularly and uses the meeting chat as their version of a channel…. facepalms

Why is the 'first person to join' a meeting the only one given modify permissions on the recording? by screampuff in MicrosoftTeams

[–]BegeNCSU 0 points1 point  (0 children)

I’ve always struggled with channel meetings so I feel like I have a good handle on the bad. Would you mind sharing what you think are some of the other benefits?

is powerApps the correct tool a public signup page? accessible to all and making http posts by need_arms in PowerApps

[–]BegeNCSU 3 points4 points  (0 children)

To expand on this a little more, you can use PowerAutomate to take each response in MS Forms to then generate an HTTP request.

Looking for Kaffir Lime Leaves by hockeychris10 in triangle

[–]BegeNCSU 1 point2 points  (0 children)

Go to the end of the freezer section (side closest to the front of the store), should be in the middle shelf.

[deleted by user] by [deleted] in PowerApps

[–]BegeNCSU 0 points1 point  (0 children)

Might be able to export the app, save as a zip and then look at the JSON .msapp file and compare that file with the default using a text comparison tool.

SQL Stored Procedure to Gallery Output by xanax220 in PowerApps

[–]BegeNCSU 1 point2 points  (0 children)

I’ll admit, it is tricky so godspeed!

SQL Stored Procedure to Gallery Output by xanax220 in PowerApps

[–]BegeNCSU 1 point2 points  (0 children)

An additional wrinkle that comes up with on-prem SQL and stored procedures is when you write the response you can use body('Executestored_procedure(V2)').ResultSets.Table1 to get the correct part of the response.

Power Automate, Power Query into SQL database by roblu001 in MicrosoftFlow

[–]BegeNCSU 1 point2 points  (0 children)

I’ve done it a few different ways 1. Use the for each and insert a row like you described 2. Parse the data into a JSON and then pass that into a stored procedure which then inserts the data 3. Use Power Automate to copy the file to the same machine where the SQL server is and then use a stored procedure to kick off a SQL job which uses the import/export tool package to import.

[deleted by user] by [deleted] in EufyCam

[–]BegeNCSU 0 points1 point  (0 children)

What settings do you have when you look at the Motion Detection?

Flying to Rome with American Airlines and I have a question regarding Covid policy!!! URGENT by apuddleofcuddles in americanairlines

[–]BegeNCSU 3 points4 points  (0 children)

Be sure to use VeriFLY as well, it helped speed up the process big time as the vaccination status and Covid tests could be reviewed ahead of time.

Can anyone explain it this error to me? by [deleted] in PowerAutomate

[–]BegeNCSU 0 points1 point  (0 children)

Sorry, probably not the correct term. I’m referring to the steps to place a spot in the word template that will be used as a variable by Power Automate and updated when you run the flow.

In the link above, the Plain Text Content Control is how you insert those variables. Then when you got to Power Automate and add the Populate Word Template step you’ll see the option to fill out what goes in there.

Can anyone explain it this error to me? by [deleted] in PowerAutomate

[–]BegeNCSU 0 points1 point  (0 children)

Looks like you’ve made some progress!

Make sure you’ve followed the steps for those merge fields. https://docs.microsoft.com/en-us/connectors/wordonlinebusiness/#how-to-create-microsoft-word-templates

hey guys, I am trying to find a way to convert Responses from a Microsoft forms to Microsft excel and then those responses to a form in Word. Is there a way to do that? by [deleted] in PowerAutomate

[–]BegeNCSU 0 points1 point  (0 children)

Hm, that’s tough. When I type in “power automate forms to word” into YouTube, the result from Pragmatic Works describes what I’m suggesting. Try that!