Hi,
I have a powerapp form where i put numbers and text from 3 fields to populate one field. it all works good with the following formula:-
Solved! Go to Solution.
So in your OnSuccess of the form, you will need to supply the following formula:
UpdateIf(yourDataSource, ID=Self.LastSubmit.ID,
{yourColumnToUpdate: Self.LastSubmit.Code & "-P" & Self.LastSubmit.ID & "-" & Self.LastSubmit.'RFS/W No'}
)
Although you supplied the column names, I am not sure how they relate to the datacards you originally had in the formula you first posted. The above is a guess, so rearrange as necessary.
You will need to do this in the OnSuccess of your form as an additional action.
Let me know what the names of the columns are in your record that make up the three fields you want to put together and I can suggest for you what you need in the OnSuccess.
So in your OnSuccess of the form, you will need to supply the following formula:
UpdateIf(yourDataSource, ID=Self.LastSubmit.ID,
{yourColumnToUpdate: Self.LastSubmit.Code & "-P" & Self.LastSubmit.ID & "-" & Self.LastSubmit.'RFS/W No'}
)
Although you supplied the column names, I am not sure how they relate to the datacards you originally had in the formula you first posted. The above is a guess, so rearrange as necessary.
Great! thanks...it worked.
this is what i have in the OnSuccess now -
Excellent! So if all is working, please go back to my response with the formula and mark it as a solution so others can find similar problems and solutions easier.
Thanks!
Done for you @RandyHayes
You missed out the last & before Self......if you can edit.....stick it in incase others dont spot it 🙂
Thanks again! i had been at that for hours!
Good call...took me a minute to even spot what you were talking about. Saw it and corrected! Thanks for pointing out.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
164 | |
94 | |
64 | |
63 | |
61 |
User | Count |
---|---|
236 | |
162 | |
95 | |
83 | |
81 |