Hello! everyone
Purpose : extract excel data to sharepoint list by power automate
Backgroud :
The target sharepoint list have already been made. There are many data there already. 「Company name 」is a column in sharepoint list A , which is drop down style.
The options of that drop down is refer to sharepoint list B, which is company master data. There are [company No.] 、 [company name] and some other columns in it.
What I did
I used [create item ] action in power automate to match the excel columns with the columns in sharepoint list A . When I fill the 「Company name 」blank in advanced parameter of [create item ] action , the automate showed me to fill integer in it . So I download the master data（list B）to excel book and used vlookup made a [company No.] column in the excel table（resource）. The [company No.] data in excel is number, so it doesn't have comma. And I used custom way, made a function item?['Company name No. '] in 「Company name 」in the advanced parameter of [create item ] action .
Problem: All the columns are correctly reflected in the list A , except the [company name] column. Only when the [Company No.] is from １ to 999 , the corresponding company name is correctly reflected . When the [company No. ] is >= 1000 , the corresponding name is wrongly reflected, Which means the company name does not match the company No. . How can I make the company name relect correctly?
I thought is was the comma problem. The company number >= 1000 in sharepoint list B was showed in a style like 「 1,000」, which has a comma in it. So I tried setting the [company No.]column in sharepoint list to not to show the comma anymore. But after the the setting the company name still be wrongly reflected.
Could you help me with this problem ? Thank you!
4
Share
Report
All responses (
Answers (
