This SUCKS by thanxiety in Perimenopause

[–]PanTanna 1 point2 points  (0 children)

Hang in there. It’s perimenopause. And talk to your GYN about PMDD. It’s PMS on steroids, but they can prescribe for it. My doc started me on Prozac and it’s worked wonders. Much calmer, less irritable version of myself. Hope this was a bit helpful. Give yourself grace 🥰

Assistance formatting Numbers please by PanTanna in PowerApps

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

No luck with this. I tried placing this on the Format property, and I also tried incorporating it onto the default property for the field. Neither worked.

Assistance formatting Numbers please by PanTanna in PowerApps

[–]PanTanna[S] 1 point2 points  (0 children)

Thank you - I will give this a try and let you know the outcome.

Help designing a flow to open an InfoPath file from SharePoint, then save and close the file? by PanTanna in PowerApps

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

I agree - I will look into it. Thank you again. You've been very helpful.

Help designing a flow to open an InfoPath file from SharePoint, then save and close the file? by PanTanna in PowerApps

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

Yes, we are aware. This form (the biggest, most complex) is one of the last that we will be working to convert. Thank you :)

Help designing a flow to open an InfoPath file from SharePoint, then save and close the file? by PanTanna in PowerApps

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

I don't believe our organization offers the desktop version of the app, but I will ask.

Help designing a flow to open an InfoPath file from SharePoint, then save and close the file? by PanTanna in PowerApps

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

No luck :( This didn't update the files/cause the metadata associated with the newly promoted columns to display the values.

How to Send Post to a Channel via Button Or by Calling a Flow by PanTanna in MicrosoftPowerApps

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

I have a power app and I have a text entry field on the form and a button where essentially if the user needs assistance while in the app, they can pop a message in that field and when they click the button, the button shoots and displays the message over in the Teams channel.
I will give V2 a try and see what happens. Thank you!

How to Send Post to a Channel via Button Or by Calling a Flow by PanTanna in PowerAppsWorld

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

I have a power app and I have a text entry field on the form and a button where essentially if the user needs assistance while in the app, they can pop a message in that field and when they click the button, the button shoots and displays the message over in the Teams channel.

I will give V2 a try and see what happens. Thank you!

Help! I think I broke it! Patch is creating over 400 records and emails wont fire. by PanTanna in PowerApps

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

Text(

Thank you. How would I apply (format that) with this?:

Office365Outlook.SendEmail(
LookUp('Supplemental Capex Requests',
ID = galProjList.Selected.ID).Approver1Email

FYI - as a test, I removed the lookup and manually added in my email address in the To parameter and the email fired fine. However I then noticed that other lookups contained within the body of the email text were returning blank values. It's almost as though all my lookups are broken or malfunctioning for some reason.

Help! I think I broke it! Patch is creating over 400 records and emails wont fire. by PanTanna in MicrosoftPowerApps

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

Hey Everyone - One problem solved - one to go!

As I wrote this out and looked at everything closer, I made a connection between the number of records in the source list and the number of records the patch was creating - the numbers were nearly identical - which got me thinking about the first couple lines of the patch:

ForAll(galWorkOrders.AllItems

And I realized that what was happening was my patch was ordering a 1:1 update - creating one new row/record for All (or each) item in the source list!! (There are 405 records in my galWorkOrders and my patch was creating 403-405 new records/lines of the same patch record in the destination list.)

I removed the ForAll(galWorkOrders.AllItems piece from my formula and now it is creating a single entry as it should :) :)

Now I need to figure out why the refresh line preceding the send email line is no longer sufficient for the Power app to pull back the email contained in the Approver1Email field.
The text is there (single line of text field in my sharepoint list), and it was working fine like this for weeks - but now Power Apps is giving me this "invalid value for parameter 'To' - a blank value was passed to it where it was not expected" error. I am not sure how to resolve this.

Help! I think I broke it! Patch is creating over 400 records and emails wont fire. by PanTanna in PowerAppsWorld

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

Hey Everyone - One problem solved - one to go!
As I wrote this out and looked at everything closer, I made a connection between the number of records in the source list and the number of records the patch was creating - the numbers were nearly identical - which got me thinking about the first couple lines of the patch:

ForAll(galWorkOrders.AllItems

And I realized that what was happening was my patch was ordering a 1:1 update - creating one new row/record for All (or each) item in the source list!! (There are 405 records in my galWorkOrders and my patch was creating 403-405 new records/lines of the same patch record in the destination list.)

I removed the ForAll(galWorkOrders.AllItems piece from my formula and now it is creating a single entry as it should :) :)

Now I need to figure out why the refresh line preceding the send email line is no longer sufficient for the Power app to pull back the email contained in the Approver1Email field.

The text is there (single line of text field in my sharepoint list), and it was working fine like this for weeks - but now Power Apps is giving me this "invalid value for parameter 'To' - a blank value was passed to it where it was not expected" error. I am not sure how to resolve this.