Update SP Field

(0) Share

Report

Posted on by neill_long

708

I have 2 SP Lists.

SP 1 - stores data about exam dates

SP 2 - stores data about students

SP 2 has a lookup field that shows the C_Codes from SP 1.

SP 2 also stores data about staff member who is associated with exam. the data is stored in SP 1, but on my PowerApp, it copies that data and saves it into a field on SP 2.

If member of staff was to leave and new member of staff was added, I need a way to update records with new info. SP 1 would get modified, then flow would run and update all records that match the selected C_Code. But I am struggling to get this to work.

Here is what I have:

When it runs, the Assessor doesn't update.

Can anyone advise on what I am doing wrong?

thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@neill_long is assessor a lookup field? if possible share SharePoint List 1 & 2 screens.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Verified answer

neill_long 708 on at

Like (0)

Report
Copy link

Link copied!

I managed to get this to work. Instead of adding formula in the Filter Query, I added a condition where the C_Code Id is equal to ID.

This worked when run so I'm happy with that

Was this reply helpful? Yes No