PowerAppsrequestapproval.Run('Doa Request'.LastSubmit

(0) Share

Report

Posted on by PaulDG

Hey everyone,

I am hoping you can help me out, I cant work out why my Power apps call isnt working for the like of me.

I have a button to submit a form DOA Request which updates an excel table

OnSelect - SubmitForm('DOA Request')

And then trigger power automate PowerAppsrequestapproval passing in the last submitted ID

OnSuccess - PowerAppsrequestapproval.Run('DOA Request'.LastSubmit.ID)

However I get the below error.

PowerAppsrequestapproval.Run fialed: The method 'Run' has an invalid value for parameter 'number'

From what I can work out I think its passing through a blank value and some other people were having issues resetting the form but I am not doinf that anywhere.

Thanks in advance

Paul

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @PaulDG ,

That is because Excel does not have an ID field.

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
developerAJ 4,664 on at

Like (0)

Report

@PaulDG

'DOA Request'.LastSubmit.ID
if you did not get any error here means i guess ID is one of the column of Excel but the value when you submitted form is not a number it could be blank or string thats the issue i am guessing.

if you don't have any primary key i mean column that identifies the row uniquely what you can do is create a column in excel lets say primarycolumn.
create a variable varPrimarycolumnValue ; in form add a datacard for this column;set default value for datacardvalue as varPrimarycolumnValue
on submit button.
Set(varPrimarycolumnValue,Last(Sort(tabledatasource,primarycolumn,SortOrder.Descending)).primarycolumn)
submitform(urform)

Please click Accept as solution and Thumbs Up. 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 giving it Thumbs Up.

Was this reply helpful? Yes No