Power Platform Community Forum Thread Details

Hello all, I want to duplicate the first 200 records of an ODS table. I want to change only the CLIENT from CLIENT1 to CLIENT2 and all the other fields should not change. And i want to duplicate the attachments for those as well. The attachments are saved in sharepoint list. Is this possible? Thank you.

The fields in ODS are these:

PROJECT_NUMBER
REV_NO
CLIENT
STATUS
CLIENT_AGR_NO
BUSINESS_UNIT
PRODUCT_LINE
MANAGING_OFFICE
SITE_LOCATION
PROJECT_TITLE
CLIENT_PROJECT_NO
PROJECT_DEFINITION
REQUEST_DATE
CLIENT_RESPONSE_DATE
PROJECT_START_DATE
PROJECT_END_DATE
SUMMARY_AUTHORIZED_HOURS_
SUMMARY_AUTHORIZED_PRICE
PRICING_CURRENCY_
INVOICING_BASIS
REASON_FOR_HVE_INELIGIBILITY
REQUESTOR_NAME
REQUESTOR_EMAIL_ADDRESS
CLIENT_APPROVER
CLIENT_APPROVER_EMAIL_ADDRESS
CLIENT_R_O_S_VERIFIER
R_O_S_VERIFIER_EMAIL_ADDRESS
PROJECT_MANAGER
PROJECT_MANAGER_EMAIL
PROJECT_ENGINEER
PROJECT_ENGINEER_EMAIL
COST_PR_SRVCS_SPECIALIST
COST_EMAIL
CLOSE_DATE
CLIENT_RESPONSE
STATUS_FLAG
IS_INTERNAL
WORK_TYPE
INTERNAL_APPROVER
INTERNAL_APPROVER_EMAIL
DT_VALID_FROM
DT_VALID_TO
IS_VALID
IS_CURRENT
DT_CREATED
CREATED_BY
DT_MODIFIED
MODIFIED_BY
IS_BEING_EDITED
DT_RESPONSE_INTERNAL
AUTO_INCREMENT_
INVOICE_ID
KEY
DESCRIPTION_
PROJECT_START_DATE_STRING
PROJECT_END_DATE_STRING
CLOSE_DATE_STRING
REQUEST_DATE_STRING
DT_RESPONSE_INTERNAL_STRING
DT_CREATED_UTC
DT_MODIFIED_UTC
CLIENT_RESPONSE_DATE_STRING
DT_RESPONSE_INTERNAL_UTC
STATUS_CODE

Categories:

Building Power Apps