Unanswered

Help to create a flow triggered from PowerApps to update data in SPList 1 from SPList 2?

(0) Share

Report

Posted on by KatChi4

Question:

How to create a separate flow triggered from PowerApps to update the ContactID in the 'Trades' SP list with the Client Email from the 'Client Contacts' SP list where 'ACCT' from 'Trades' = 'Client Name' in Client Contacts?

Or should I add this to an existing flow trigged in PowerApps that fetches excel data files from an SP Library and adds new records or updates records to the 'Trades' SP list. The column ContactID is always null since that value is in the "Client Contacts' SP list that I need to bring in somehow.

SP List Info:

'Trades' - with columns ACCT and ContactID.
- ContactID is always null when uploaded to 'Trades' list from Excel.
'Client Contacts' - with columns Client Name and Client Email.
- This list is manually updated (copy/paste) or via a separate screen in my PowerApp that pushes the change to this list.
The match between both sources is ACCT = Client Name.

Thank you in advance for your help.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@KatChi4 you can use Get Items action to get data from Client contacts with filter query Client Name eq 'ACCT Value', this will give you matching item from Client contact list, then you can use output of get items to get the client email and use Update item action or Rest API with Send HTTP Request to SharePoint action to update the Trades list column with client email value in ContactID column.

Was this reply helpful? Yes No
Sawh 115 on at

Like (0)

Report

Hi Anna,

I am having an issue with my cloud flow and was hoping you might help me. I have two SharePoint lists. The first one receives data about the number of personnel needed for an event. It will show multiple records for the event with the same personnel roles but for different scheduled times. The second SharePoint list is set-up to receive the values of each role summed by event name. I created a power automate flow to conduct the increment variable function for this purpose. There are 82 different roles in each list, but only some of them will receive a value due to what role type that may be needed for the event. As a result many of the columns in the first SharePoint list will have null values when the flow runs. I would like to incorporate the coalesce(trigger().outputs, '') to change the column values to an empty string so that the flow will not run into null errors. I am not sure where this expression should be placed within the my power automate flow. Do you have any suggestions?

Ange

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Sawh I would suggest you to create a separate post as this post already has the issus posted by @KatChi4 being discussed. You can create new post and tag me within the post, i will be happy to help.

Was this reply helpful? Yes No
Verified answer

KatChi4 on at

Like (1)

Report

I found a solution to my query with the help of Vivek Navik's video.
https://www.youtube.com/watch?v=IKID3G_z9fA

Thank you to all those who responded.

Was this reply helpful? Yes No