web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dynamics Email Paramet...
Power Apps
Answered

Dynamics Email Parameter - Failing - SQL Modified Item

(0) ShareShare
ReportReport
Posted on by LyonsBI_BRL 214

I recently got my Flow working correctly for When Item is Modified in SQL. 

However, when I change it to be dynamic, it fails saying Parameter cannot be NULL, when though the email address is present there

 

This is the Inputs showing that it's thinking email address is null

LyonsBI_BRL_0-1620003596338.png

 

 

Below as mentioned above it's thinking the Parament of email is null

LyonsBI_BRL_1-1620003664937.png

 

No one idea I have tried was in the Conditions

where triggerOutputs()?['body/Ex002d_mail'] is not equal to null which didn't seem to work. However, if I hard code it in and it goes to my email address, (i.e. my O365 address) it works fine. So the issue is getting it to work with a dynamics email address. 

 

Any good suggestions as to what else I could try?

LyonsBI_BRL_4-1620004145705.png

 

 

 

 

 

 

 

Categories:
Building Power Apps
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @LyonsBI_BRL ,

     

    So, where do you dynamically enter your email address to pass it to flow? Powerapps?

    Please provide complete flow as much as possible.

     

    Best Regards,
    Wearsky

  • LyonsBI_BRL Profile Picture
    LyonsBI_BRL 214 on at

    @v-xiaochen-msft Yep I pass it into the flow through PowerApps. 

    This is my Trigger - 

    LyonsBI_BRL_0-1620012742251.png

    It then calls on this condition triggerOutputs()?['body/NICS_x0020_Status']

    LyonsBI_BRL_1-1620012797122.png

     

    And then I call upon this action for Send Mail

    LyonsBI_BRL_2-1620012837085.png

    Now I have confirmed the email address is present for that particular item in that row. 

    What's so weird, is another one of my flows When Item is Created, uses the dynamic E-Mail value, to email based upon what's being passed within the E-Mail column for that record, and it works fine. Though for this, it acts as if nothing is even there. 

    LyonsBI_BRL_3-1620012992775.png

     

     

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @LyonsBI_BRL ,

     

    I did a test for you .I did not encounter your problem.

     

    1\ This is my table

    v-xiaochen-msft_0-1620017385509.png

    v-xiaochen-msft_1-1620017444058.png

     

    2\ This is my flow

    v-xiaochen-msft_2-1620017492060.png

     

    3\ When I modify a record, this is the result.

    v-xiaochen-msft_3-1620017551977.png

    v-xiaochen-msft_4-1620017819156.png

     

    Did I miss something?

     

    Best Regards,
    Wearsky
    If my post helps, then please consider Accept it as the solution to help others. Thanks.

     

     

     

     

     

  • LyonsBI_BRL Profile Picture
    LyonsBI_BRL 214 on at

    @v-xiaochen-msft 

    I think I've discovered this issue here. So in the DB of course I can see the email address.

    LyonsBI_BRL_0-1620018553819.png

    Now if I go into my EDIT screen for each item

     

    LyonsBI_BRL_1-1620018596033.png

    So something here is not having the email address displayed. Everything else is.

    Any thoughts?

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @LyonsBI_BRL ,

     

    Please provide the following information.

    1\ your edit form's Item formula

    2\ the formula of your email 's TextInput control

    3\ The data type of Email is in the sql table (Is it a varchar column?)

     

    Best Regards,
    Wearsky

  • LyonsBI_BRL Profile Picture
    LyonsBI_BRL 214 on at

    @v-xiaochen-msft 

    For my Item's Formula I have a variable as to setting it up for editing for each line item, This is for the edit screen 

    LyonsBI_BRL_0-1620020247423.png

    Now for the Edit button for each item OnSelect I have this

    LyonsBI_BRL_1-1620020554365.png

     

    LyonsBI_BRL_2-1620020582722.png

    And yes my SQL table, it is a varchar(50)

    LyonsBI_BRL_3-1620020718411.png

    On the screen for adding a new customer I have the email box set as Parent.Default which allows me to enter the email address for the customer

    LyonsBI_BRL_4-1620020809183.png

    Let me know if you need something more as I continue to troubleshoot as well here.

     

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @LyonsBI_BRL ,

     

    This is weird, please try the steps below.

    1\ Manually refresh your data source

    v-xiaochen-msft_0-1620021168613.png

     

    2\ Add a label control to do a test . Set its Text property to:

    varEditCustomer.your email column name in sql table

     

    3\ Select a record with Email in the gallery and click the Edit button.

     

    4\ Check if the label has an mail output

     

    Best Regards,

    Wearsky

     

     

  • LyonsBI_BRL Profile Picture
    LyonsBI_BRL 214 on at

    @v-xiaochen-msft 

    Okay so this worked, using varEditCustomer.'E-Mail'

    LyonsBI_BRL_0-1620021616540.png

    Same thing now, if I select a record in the Gallery and click the edit button same result (used one with my email account)

    LyonsBI_BRL_1-1620021689744.png

    For 4) what did you mean by checking to see if the label has a mail output? are you meaning if it's displaying the email address?

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @LyonsBI_BRL ,

     

    From the picture, I thought your email could not be displayed.

    v-xiaochen-msft_0-1620022158310.png

    But your latest reply, Email has a value. So I'm confused,does it has a value or not?

     

    Best Regards,

    Wearsky

     

  • LyonsBI_BRL Profile Picture
    LyonsBI_BRL 214 on at

    @v-xiaochen-msft Yep it was like that until I changed the data card and my Edit button formula to read 

    Set(varEditCustomer, ThisItem);Navigate('Edit Customer');ResetForm('Edit Customer')

     

    But now for each record even in the edit screen I can see the email address. This is just bizarre. That it continues to think there's no email address in the email field for the record. Any other suggestions?

    LyonsBI_BRL_0-1620022591420.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans