You’re offline. This is a read only version of the page.
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:
Thank you in advance for your help.
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.
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
@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.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
