Data not writing back to Sharepoint list

(0) Share

Report

Posted on by JerryH

431

When i click on Verify - i am wanting some information to populate on my Sharepoint list.

I have a feeling its because it cant reference Serial number due to an error in my coding?

ForAll(
colVerifiedDevices,
Patch(
AssetManagementHelpdDesk,
LookUp(AssetManagementHelpdDesk, SerialNumber = colVerifiedDevices[@SerialNumber]),
{
NameVerified: User().FullName,
DateVerified: Now(),
Status: "Confirmed"
}
)
);
Navigate(VerificationComplete)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Can you show the error you have
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
JerryH 431 on at

Like (0)

Report

Hi, there is no Error - only a warning (below). When i click on verify (screensnip below), it should write information back to Sharepoint.
Perhaps it does not know where to write it too - hence i used serial number to identify the row

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

That seems to be delegation warning.
How many rows do you have. If have less than 2000, increase the delagation limit to 2000. Go to FILE.. Setting.. Advance Setting and increase it.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

JerryH 431 on at

Like (0)

Report

hi
NameVerified: User().FullName,
Date: Now(),
Status: "Confirmed"

- I changed "DateVerified:" in my code to "Date: and its worked, however, the column in my Sharepoint list was named "DateVerified:" so am not sure why it did not write back to Sharepoint? Surely it would look for the column name?

Thanks
Jerry

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Yes if DateVerified is a column name, it should have worked. Or is the column a calculated field?

Are there any restrictions you have put on that particular column
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
JerryH 431 on at

Like (0)

Report

hi
No - the Sharepoint was NOT a calculated field.
The date was: Date: Now() - so very strange.
But thank you for your support.
Kind regards,
Jerry

Was this reply helpful? Yes No