Hello.
I built a power app that collects data on form and creates html. When the user clicks submit, it kicks off an approval flow and converts the HTML to a pdf. The flow works fine but I have noticed that it keeps sending the old data when i create a new item in the sharepoint list. Not the new data that has been inputted. I tried resetting the form when its first opened but it doesnt work. I feel like its something simple but I cant seen to figure it out. This is the formula im using to send the data (if its helpful):
Set(varBAHHeader1, JSON(BAHHeader1, IncludeBinaryData));
Set(varBAHHeader2, JSON(BAHHeader2, IncludeBinaryData));
SubmitForm(SharePointForm1);Navigate(Screen1,Fade); Test.Run(HtmlText1.HtmlText,Concatenate(DataCardValue3.Selected.DisplayName,Label4.Text),DataCardValue15.Text, DataCardValue3.Selected.DisplayName,DataCardValue11.Selected.DisplayName, DataCardValue5.Selected.DisplayName, DataCardValue12.Selected.DisplayName, DataCardValue13.Selected.DisplayName,DataCardValue6.Text,DataCardValue7.Text, DataCardValue8.Selected.Value,DataCardValue2.Selected.Value)
Solved! Go to Solution.
I'm not sure, but it looks like the issue is the order. You submitted the form before the flow. It's just a guess.
try putting SubmitForm at end and see if it works
Set(varBAHHeader1, JSON(BAHHeader1, IncludeBinaryData));
Set(varBAHHeader2, JSON(BAHHeader2, IncludeBinaryData));
Test.Run(HtmlText1.HtmlText,Concatenate(DataCardValue3.Selected.DisplayName,Label4.Text),DataCardValue15.Text, DataCardValue3.Selected.DisplayName,DataCardValue11.Selected.DisplayName, DataCardValue5.Selected.DisplayName, DataCardValue12.Selected.DisplayName, DataCardValue13.Selected.DisplayName,DataCardValue6.Text,DataCardValue7.Text, DataCardValue8.Selected.Value,DataCardValue2.Selected.Value);
SubmitForm(SharePointForm1);Navigate(Screen1,Fade);
I'm not sure, but it looks like the issue is the order. You submitted the form before the flow. It's just a guess.
try putting SubmitForm at end and see if it works
Set(varBAHHeader1, JSON(BAHHeader1, IncludeBinaryData));
Set(varBAHHeader2, JSON(BAHHeader2, IncludeBinaryData));
Test.Run(HtmlText1.HtmlText,Concatenate(DataCardValue3.Selected.DisplayName,Label4.Text),DataCardValue15.Text, DataCardValue3.Selected.DisplayName,DataCardValue11.Selected.DisplayName, DataCardValue5.Selected.DisplayName, DataCardValue12.Selected.DisplayName, DataCardValue13.Selected.DisplayName,DataCardValue6.Text,DataCardValue7.Text, DataCardValue8.Selected.Value,DataCardValue2.Selected.Value);
SubmitForm(SharePointForm1);Navigate(Screen1,Fade);
Thank you very much @SebS. I moved the to the end of the formula and it worked! Wouldve nvr guessed it. Thank you again for your help!
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |