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!
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:
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.
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.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional