Answered

Integrated SharePoint Form OnSave issue

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I am working on an integrated SharePoint form. The title of this form is Project Tracker XXXX. The number is calculated by capturing the last number in a separate column and adding one. In order to do this successfully without accidentally duplicating the number it has to be done OnSave.

If I put a button in the form and use this formula it successfully gets the highest number and creates the title.

Set(varTitle, Set(varCurrID, "Project Tracker " & First(Sort('Indirect Procurement Project Tracker New', 'Curr Form ID', Descending)).'Curr Form ID' + 1))

However if I do this in the SharePointIntegration OnSave property, it captures a number that is about halfway through the existing numbers.

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@JR-BejeweledOne

First - You have a syntax issue in your formula. You are using Set to try and Set another variable. Set does not return a value, so there is nothing to set the second variable (varTitle) to. I think this might just be a forum post mishap.

An integrated app works a little differently than a stand alone in that, once the app is instantiated once, every time you open the app again, it is not really re-opening it, it is just making it visible. So there is a very good chance that the data first accumulated in the start up of the app is quite stale.

In this case a Refresh on the datasource would be wise to implement as you will want to have the most recent data.

I hope this is helpful for you.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report
Copy link

Link copied!

Thanks for the tip about the integrated form and Data Refresh. I did not know that and that could have been a big issue.

Was this reply helpful? Yes No