Power Apps

Formula for Submit button

(1) Share

Report

Posted on by MR-14041422-0

Hi, pretty new to power apps.

I have created an app that has the following:

Name (dropdown)

Date (Date Picker)

Glasses (Radio Button)

Ear (Radio Button)

Shoes (Radio Button)

HighViz (Radio Button)

Gloves (Radio Button)

Where (Radio Button)

I have also added a PowerAppV2 called PPE_Insert, firstly with the above inputs, then 'add a row into a table'

I am trying to add a trigger to the submit button, do perform the above, but I am really struggling, this is what I currently have, but I have red error lines underneath (see image):

PPE_InsertFlow.Run(
    ddName.Selected.Result;
    DatePicker1.SelectedDate;
    RadioGlasses.Selected.Result;
    RadioEar.Selected.Result;
    RadioShoes.Selected.Result;
    RadioHighViz.Selected.Result;
    RadioGloves.Selected.Result;
    RadioWhere.Selected.Result
);
Notify(
    "PPE record submitted successfully.";
    NotificationType.Success
);

What am I doing wrong, other than replying on AI!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@MR-14041422-0

You could try this

Use .Selected.Value instead of .Result
Make sure the flow name is correct (PPE_Insert)
Try re adding the flow too

PPE_Insert.Run(
    ddName.Selected.Value,
    DatePicker1.SelectedDate,
    RadioGlasses.Selected.Value,
    RadioEar.Selected.Value,
    RadioShoes.Selected.Value,
    RadioHighViz.Selected.Value,
    RadioGloves.Selected.Value,
    RadioWhere.Selected.Value
);
Notify(
    "PPE record submitted successfully.",
    NotificationType.Success
);

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
you can also try below :

If( !IsBlank(ddName.Selected.Value), PPE_InsertFlow.Run( ddName.Selected.Value, DatePicker1.SelectedDate, RadioGlasses.Selected.Value, RadioEar.Selected.Value, RadioShoes.Selected.Value, RadioHighViz.Selected.Value, RadioGloves.Selected.Value, RadioWhere.Selected.Value ); Notify("PPE record submitted successfully.", NotificationType.Success), Notify("Please fill all required fields.", NotificationType.Error) )

In Microsoft Power Apps:

Use , for parameters

Use .Value (most cases)

Ensure flow parameters match exactly

Was this reply helpful? Yes No
MR-14041422-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks for both your replies, but unfortunately I am still experiencing the issue

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MR-14041422-0,

It is important here that you look at the error message (what does it say when you hover over the red X ?). Also does it come up before you submit (so the code is an error) or when you submit (the Flow is not accepting whatever you are sending) ?

I also suspect that you are using an older version of a Distinct filter on the drop-down and radio controls for you to receive Result as an output, so please post the Items of one of them to confirm this. You can use a much simpler version to receive Value as an output, however I do not believe this is your issue if Result is valid.

The next thing is the Flow itself - can you please expand all the elements and post a screenshot. This should give a good clue to what may be the issue. In addition, can you confirm that all controls have a value selected when you run the Flow.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
MR-14041422-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

HI WarrenBelz

The error occurs before before the flow is submitted. I have used a simple formula to insert values and this works fine. I have attached a couple of screenshots what the error says (sorry didn't realise you could do this as pretty new to this) I hope this helps

Was this reply helpful? Yes No
Suggested answer

rezarizvii 352 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MR-14041422-0, hope you are doing well.

I wholeheartedly agree with @WarrenBelz here. Please follow his instructions and share more details.

One thing I would like to add is that sometimes, when you add a flow to an app and then make changes to it, it does not automatically sync with the app. Your code looks fine until you submit, and then it breaks, and red squiggly lines appear.

If this is what you are experiencing, you could try removing the flow from the app and adding it again. It usually fixes the desync issues.

If that doesn't fix it still, please share the details as Warren suggested. Also, if possible, share the "Code view" of the trigger you have for your flow as well.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like! 🩷

_______________________________

Reza M. Rizvi
LinkedIn | Email

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MR-14041422-0,

I wanted a screen shot of the Flow (in particular the first item with the incoming parameters), however your error (it may not be the only one) suggests that ddName is not a valid control reference. You also have not included the Items of the controls (start with the drop-down) or confirmed that Result is a valid reference for the output (see my earlier comment) - when you type in (example) RadioWhere.Selected. what then comes up as a selection (Result or Value)

So I will set out the debugging process we need to follow: -

All the control names and their outputs need to be valid - initially it seems that ddName is not, so you need to check the actual name of the control.

The Flow should be expecting 7 parameters (which is why I wanted a screenshot)

Dates need to be sent in the format yyyy-mm-dd from Power Apps, but we will get to that one once the other items are sorted.

So please check and confirm all the control names as that seems to be your initial issue.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
MR-14041422-0 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Guys with a little playing around a googling I final got it to work, using the following.

Set(varSubmitting, true);

PPE_Report.Run(

Name.Selected.Name,

Text(

Coalesce(Date_Reported.SelectedDate, Today()),

"yyyy-mm-dd"

),

Where.Selected.Value,

Glasses.Selected.Value,

Ear.Selected.Value,

shoes.Selected.Value,

Gloves.Selected.Value,

HighViz.Selected.Value

);

Notify(

"PPE record submitted successfully.",

NotificationType.Success

);

Navigate(scrThankYou, ScreenTransition.Fade);

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MR-14041422-0,

It seems that firstly the problems was the date format (which was what I suggested).

Also your output for the drop-downs was not Result (but rather Value ) - when I commented, I assumed that you had tested that part as older converted variations of Distinct produced that output, however I also asked you for the Items of those drop-downs to confirm whether this was the case.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@MR-14041422-0

Glad it is resolved

Happy coding

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No