Submitting Collection items to SharePoint

(0) Share

Report

Posted on by EpicTriffid

364

Morning all,

I know I've done this before, and for some reason it's gone right out of my head.

I'm incrementing a value by 1 for every button press on a gallery item, and then patching that to a SP list. This is to show what is the most searched field. Doing a patch on every press didn't seem to be reliably going through so I decided to patch a collection with that incrementing value, then send that through to the sharepoint list, but for the life of me I can't seem to get the formula to work (The first patch works fine):

Patch(
 faqCol,
 ThisItem,
 {'# Searches': suggested.'# Searches' + 1});
Patch(
 'FAQ Dataset',
 LookUp('FAQ Dataset', ID = Value(faqCol.ID)},
 {'# Searches': Value(faqCol.'# Searches')})

I've also tried:

Patch(
 faqCol,
 ThisItem,
 {'# Searches': suggested.'# Searches' + 1});
Patch(
 'FAQ Dataset',
 LookUp('FAQ Dataset', ID = faqCol[@ID]},
 {'# Searches': Value(faqCol[@'# Searches']})





Patch(
 faqCol,
 ThisItem,
 {'# Searches': suggested.'# Searches' + 1});
Patch(
 'FAQ Dataset',
 ID = faqCol[@ID],
 {'# Searches': Value(faqCol[@'# Searches']})

None of them seem to work. Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!
You could try this instead of patch for the second patch:

UpdateIf('FAQ Dataset', ID = faqCol.ID, {'# Searches': Value(faqCol.'# Searches'} )

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

Like (0)

Report
Copy link

Link copied!

let seek some clarification, are you submitting directly into the Sharepoint list or you are sending the selected items into a collection, then patch the collection into sharepoint?

If Patching directly into sharepoint, then your formula should be:

Patch(
'FAQ Dataset',
ThisItem,
{'# Searches': suggested.'# Searches' + 1})

it would not be necessary to put into a collection in the above approach

If you are patching into a collection, before you move them from the collection to sharepoint:

ForAll(faqCol,

Patch(
'FAQ Dataset',
LookUp('FAQ Dataset', ID = faqCol[@ID]),
{'# Searches': '# Searches']}))

------------

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
EpicTriffid 364 on at

Like (0)

Report
Copy link

Link copied!

hi @eka,

Thank you, they both work! However, I'm pulling from the collection to the Sharepoint list as for some reason it's seems to be more reliable in it's patching. Going direct only patches intermittently. Going from the collection seems very reliable.

Was this reply helpful? Yes No