Skip to main content

Notifications

Community site session details

Community site session details

Session Id : W4lM6OnvhSlZWrmaGM0sIy
Power Automate - Building Flows
Answered

How can I pass empty values to "Ask in Powerapps" variable?

Like (0) ShareShare
ReportReport
Posted on 14 Dec 2022 15:28:35 by 67

Hello,

I have a form in Power Apps that submits an image and some data with it to a SharePoint Document Library.

- (Reference: (164) PowerApps Upload Attachment/File/Image to SharePoint Document Library - YouTube)

I'm using the template flow 'Upload a photo to SharePoint from Power Apps'. 

Capture.PNG

 

 

 

I'm using 'Ask in PowerApps' to fill up the fields and the flow works perfectly but only when all the fields are filled even though many fields are not required.

Ex: If I leave 'Height' or 'Note' form fields empty and submit I'll get an error probably because the related Ask in PowerApps is being passed as empty or not being passed at all (since we're not filling it in the form). Is there a way to solve this issue?

Note: The flow runs on the OnSelect property of the submit button not OnSuccess of the Form

 

Capture2.PNG

 

In PowerApps:

Capture3.PNG

 

 

 

 

  • Verified answer
    v-jefferni Profile Picture
    on 15 Dec 2022 at 09:10:44
    Re: How can I pass empty values to "Ask in Powerapps" variable?

    Hi @Joseph_Nasr ,

     

    Could you please share more detail about your scenario? Are those columns you mentioned all Number columns? If so, please try below:

    1. remove the PowerApps trigger 

     

    2. add PowerApps trigger again to refresh the input parameters "Ask in PowerApps"

     

    3. initializing 3 string variables, use Ask in PowerApps dynamic contents

    vjefferni_3-1671095425138.png

     

    4. in create item action, use below expressions for the numeric columns:

    if(equals(variables('variableName'),''),null,int(variables('variableName')))

    vjefferni_0-1671094805854.png

     

    5. in PowerApps, use TextInput.Text directly, drop the Value functions.

    vjefferni_1-1671095091590.png

    item flow created:

    vjefferni_2-1671095239352.png

    Best regards,

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

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard
Loading started