Unanswered

Question on Initializing Edit Form and Input to Power Automate without Markup

(1) Share

Report

Posted on by WillLi Microsoft Employee

Hi community.

I am recently developing a Power App to trigger an approval flow on Power Automate and I have two questions regarding the issues that I have ran into.

1) The Power app is basically an edit form that uses sharepoint list (named Production Approval List) as the data source. However, when it's initialized, the form is invisible with "Get your data" as the prompt. I have to click the cancel (the button is to call NewForm func) to make it appear. I tried to add NewForm function in the fx field, but there is already something there and I can't add it successfully. Can someone show me a way of initializing the form while opening the app?

2) The power app I made will trigger a power app flow once clicking the submit button with passing a few values of the form to the flow. While I was trying to push some notifications using the power automate, the text from the Action (see the pic above) field always come with the ugly markup (see the pic below) that I can't get rid of. Can someone show me a way of passing the text from power app to power automate flow without the markup text?

Thank you very much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report

@WillLi

For the first one a possible solution could be to just change the Form's DefaultMode property to FormMode.New

You can do this on your existing Form Control called 'EditForm1' for example to test it. Then you can create a new Record with it in that mode. See if this helps

There are also possible alternative approaches. You could also try to use the NewForm(EditForm1) function like you wanted - put this on the OnVisible property of the Screen. You can also just leave it in Edit mode, but under the Item property of the Form, put a reference to the first record of the data source in there - it can work like that as well - however, that would mean the first record is editable, that may not be what you want.

As for your second query about Power Automate, we might have to check on it in some detail, and if we have an idea, we might let you know.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report

@WillLi

For second query, to get the very specific answer, we might have to either check with you specifically or that someone else on this forum can advise about it.

We have some general advice about your second query. Please check and it and see if it happens to be related to your issue:

General advice:

If it is because of SharePoint, it could be this frequently discussed issue. Here are some links to reports and potential discussed solutions, check if anything from these below links to similar posts, work in your case:

Multiline text field and strange output

<div class="ExternalClass8A81C2517A984B118C976176FACDE3DA">

Multi-line textbox ends up with <DIV> text in it

From the above, we think perhaps for you, surrounding the text with the PlainText( PutYourTextHere ) formula

in the Power Apps Canvas App

might be best solution for you, this was mentioned in one of those three links above. We think it is better than having to change the data type in SharePoint.

It is also something to try in case even if you are not using SharePoint, because that PlainText way could work as well for that case too (even for non SharePoint data source in particular) is why.

Please check and see if doing this above works, especially the one with the PlainText function.

Was this reply helpful? Yes No